Tip of the week # 587
29 October 2019


Flip through your worksheets (Microsoft Excel) *

Moving the cell pointer from one worksheet to another worksheet in the same workbook can be done with either a mouse or the keyboard. Anybody who ever attended one of my courses or is an astute reader of this tip series knows I absolutely love keyboard shortcuts. So unless you really want to pick up your mouse and click on the worksheet tab at the bottom of the workbook window or use the tab scrolling buttons to the left of the worksheet tabs, try out these nifty keyboard shortcuts.

Here's how:

  1. Press CTRL + PGUP to jump to the last selected cell in the previous worksheet.
  2. Press CTRL + PGDN to jump to the last selected cell in the next worksheet.

It doesn't matter whether you use the Page Up and Page Down buttons on the numeric keypad or elsewhere on the keyboard.

Related tips:

  1. Tip # 265: Switching between multiple browser tabs (tip_265.php)
  2. Tip # 419: Preview and flip through your open windows (tip_419.php)
  3. Tip # 433: Use a keyboard shortcut to switch between open workbooks (tip_433.php)
  4. Tip # 553: Flip through the tabs of a dialog box (tip_419.php)

.


* Unless stated otherwise, these tips were written for Microsoft Office 2010.