Question

Sally needs to copy data from the first worksheet to the fifth worksheet in her workbook. Which combination of keys will she use to navigate between the worksheets?

A. Ctrl and Page Up or Page Down keys
B. Alt and Page Down or Page Up keys
C. Shift and Page Down or Page Up keys
D. Ctrl and up or down arrow keys
E. Ctrl down and up arrow keys

Answer 1

The correct answer is A: Ctrl and Page Up or Page Down keys.

Ctrl + Page Down - from left-to-right

Ctr + Page Up - from right-to-left

Answer 2

Ctrl and Page Up or Page Down keys

You can easily use your keyboard to switch between worksheets in excel. Actually, it is easier to use the above keyboard combination keys rather than having to click on an individual sheet. Therefore, in order to move through worksheets in an excel workbook using the keyboard, press and hold CTRL and then press and release PgUp or PgDn to switch sheets from right-to-left and vice versa.