Shortcut to Navigate Between Worksheets in Excel
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
The correct answer is A: Ctrl and Page Up or Page Down keys.
Ctrl + Page Down - from left-to-right
Ctrl + Page Up - from right-to-left
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.
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? The correct combination of keys that Sally will use to navigate between the worksheets is Ctrl and Page Up or Page Down keys.