How to move on a Workbook (Keyboard Shortcuts to switch between Worksheets)

Use Keyboard Shortcuts to switch between Worksheets

Use Keyboard Shortcuts to switch between Worksheets

Use Keyboard Shortcuts to switch between Worksheets:

It is very important to know the keyboard shortcuts to move on and between worksheets. Below is the list of shortcut keys that can help to improve the speed and efficiency.

  • CTRL + ARROW KEY: Moves to the last cell of current data region. If you are on the last cell of current data region, then it will move to first cell on next data region.
  • SHIFT + ARROW KEY: Select one more cell in the direction of arrow key used.
  • CTRL + SHIFT + ARROW KEY: Extend the selection to the last cell of current data region. If you are on the last cell of current data region, then selection will extend to first cell on next data region.
  • CTRL + PAGE UP: Switch to next sheet towards right.
  • CTRL + PAGE DOWN: Switch to next sheet towards left.
  • CTRL + SHIFT + PAGE UP: Extend the selection of worksheets towards right. (It is used to select multiple sheets. Quick Tip: Right click on selected sheets and click “Ungroup Sheets” to cancel multiple selected sheets.
  • CTRL + SHIFT + PAGE Down: Extend the selection of worksheets towards left. (It is used to select multiple sheets. Quick Tip: Right click on selected sheets and click “Ungroup Sheets” to cancel multiple selected sheets.
  • SHIFT + PAGE DOWN: Extend the selection to one page down.
  • SHIFT + PAGE UP: Extend the selection to one page up.
  • ALT + PAGE DOWN: Move one page towards right.
  • ALT + PAGE UP: Move one page towards left.
  • ALT + SHIFT + PAGE DOWN: Extend selection by one page towards right.
  • ALT + SHIFT + PAGE UP: Extend selection by one page towards left.
  • F6: Switch to next pane in a worksheet. Quick Tip: It is very useful when you have worksheet split and wants to toggle between two panes of the worksheet.
  • SHIFT + F6: Switch to previous pane in a worksheet. Quick Tip: It is very useful when you have worksheet split and wants to toggle between two panes of the worksheet.

Hope you found Shortcuts to switch between Worksheets useful.

Courtesy: learnadvancedexcel.com

Show Comments

No Responses Yet

Leave a Reply