ExcelSheetNavigator

Python script to quickly navigate between sheets in large Excel workbooks

Dependencies

• Windows
• Excel
• Python 2.7
• PyWin32

Usage

1. Make sure Excel is open.
2. Start the script.
3. In order for this to actually save any time, the script should be started by using a hotkey tied to a Windows shortcut or using for example AutoHotkey).
4. Use pythonw.exe instead of python.exe to avoid the cmd window to pop up.
5. Type a partial case-insensitive name of the sheet to navigate to. Multiple search terms are separated by spaces. For example, "impo tabl" will match "MyImportantTable".
6. Press Enter to switch to the first sheet in the list.