Sheet Switcher for Excel

ALT-TAB equivalent for Excel to navigate between sheets in large workbooks

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 panel features all sheets in a workbook
  • The most recent sheets are always on top of the list
  • Set your own shortcut keys

XLTools Sheet Switcher Alt Tab equivalent for Excel


Add XLTools Sheet Switcher to Excel 2016-2007

Works with: Microsoft Excel 2016, 2013, 2010, 2007, and desktop version of Office 365.

Download XLTools Add-in


Learn your way around:


How to review the list of all sheets in a workbook

  1. Click on the ‘Sheet Switcher’ button on the XLTools tab > The navigation panel appears.
    Or, use the shortcut combination Shift+Ctrl+W.
  2. Review the full list of sheets in the workbook. The most recently opened sheets are always in the front.
  3. To close the panel use Esc
    Or, select a required worksheet using mouse or arrow keys.

How to switch between worksheets

  1. Use Alt+Right/Left Arrow to flip though and preview the sheets.
  2. Release the Alt key when you have found the necessary sheet.

How to change shortcut keys of the Sheet Switcher

  1. Click on the ‘Settings’ button on the XLTools tab.
  2. Open the ‘Shortcuts’ tab.
  3. Change hot key combinations as you wish.
    Note, that some shortcuts may not be available if they are assigned to other Excel operations.

Change shortcut keys for XLTools Sheet Switcher

 

Any questions or suggestions? Contact us or 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 *