Sheet Switcher for Excel

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.)

 

Add "Sheet Switcher" to Excel 2016, 2013, 2010, 2007

Works in: Microsoft Excel 2016 – 2007, desktop Office 365 (both 32 bit and 64 bit).

Download XLTools Add-in

Excel Sheet Switcher Button

 

Learn your way around:

 

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. Click the 'Sheet Switcher' button on XLTools tab > The navigation pane appears.
    Or: use the shortcut combination Ctrl+Shift+Right.
  2. To open a worksheet, navigate to its name using Arrow keys (up, down, left, right) > Press Enter.
    Or: use a mouse to select the necessary worksheet.
  3. The navigation pane stays on top. To close it, select a worksheet or press Esc.

XLTools Sheet Switcher: alternate between the worksheets in a large workbook

 

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+Right arrow to move to the right.
  • Alt+Left arrow to move to the left.
  • Alt+Up arrow to move up.
  • Alt+Down arrow to move down.

XLTools Sheet Switcher to switch between the most recent Excel sheets

 

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 > 'Settings' button > 'Shortcuts' tab > Set your own shortcuts > OK.

Change default shortcuts for XLTools sheet switcher

 

Any questions or suggestions? Please leave your comment below.

 

Any questions or suggestions? Please leave your comment below.

2 Responses to Sheet Switcher for Excel

  1. udi says:

    Is there an option to set a different key-combo?

Leave a Reply

Your email address will not be published. Required fields are marked *