Alt+Tab equivalent to navigate large Excel workbooks and quickly switch between worksheets

When MS Excel workbooks turn into massive files, navigation between numerous worksheets becomes a frustrating challenge.

The Sheet Switcher for Excel works similar to the Alt+Tab shortcut in Windows:

  • Navigation pane features all worksheets in a workbook
  • The most recent sheets are always on top of the list
  • Use Alt+Arrows shortcuts or set your own hot keys
(Note: the video may not reflect the latest upgrades. Please use the guide below.)

The Sheet Switcher works similar to Alt+Tab shortcut in Windows – it allows to alternate between recent sheets in a large Excel workbook.

The navigation pane displays the list of worksheets in a workbook. Worksheets are arranged in Z-order, the most recently opened sheets are always in the front. As you navigate the list, watch corresponding worksheets open in the background.

  1. Use the keyboard shortcut combinationCtrl + Shift + Right.
  2. To open a worksheet, navigate to its name using Arrow keys (up, down, left, right) PressEnter.
    Or:use a mouse to select the necessary worksheet.
  3. The navigation pane stays on top. To close it, select a worksheet or pressEsc.

How to switch between recent worksheets in a workbook

Similar to the Alt+Tab shortcut in Windows, you can use XLTools shortcuts to switch between the most recent worksheets in a workbook. Watch the selected worksheets open in the background as you flip through the workbook.

Hold Alt key Use arrows to switch between worksheets Release Alt on a required sheet The navigation pane will hide.

  • Alt + Rightto move to the right.
  • Alt + Leftto move to the left.
  • Alt + Upto move up.
  • Alt + Downto move down.

How to change default shortcuts for the Sheet Switcher

You can change the hot key combinations for the Sheet Switcher at any time. Note, some shortcuts may not be available if they are reserved for other operations in Excel.

XLTools tab Settingsbutton Shortcutstab Set your own shortcuts OK.

Any questions or suggestions?
udiIs there an option to set a different key-combo?
November 4, 2014 at 23:38
Peter LiapinHi, Yes, you can change keys bindings. Please go to XLTools ribbon menu -> Settings -> Shortcuts.
November 4, 2014 at 23:45
How can we help?