Do you have files with many sheets? Really a lot – a few dozen? Going to the right sheet in such a book can be annoying – until you find the right sheet tab, until you click on it …
Method 1. Hotkeys
Combinations Ctrl+PgUp и Ctrl+PgDown allow you to quickly flip your book back and forth.
Method 2. Mouse transition
Just click the right click on the scroll buttons to the left of the sheet tabs and select the desired sheet:
Simple and elegant. Works in all versions of Excel.
Method 3. Table of contents
This method is laborious, but beautiful. Its essence is to create a special sheet with hyperlinks leading to other sheets of your book and use it as a “live” table of contents.
Insert an empty sheet into the book and add hyperlinks to the sheets you need using the command Insert – Hyperlink (Insert — Hyperlink):
You can set the text displayed in the cell and the address of the cell where clicking on the link will lead.
If there are a lot of sheets and you don’t want to make a bunch of links manually, then you can use the ready-made macro for creating a table of contents.
- How to create a table of contents for an Excel workbook to quickly navigate to the desired sheet
- Automatic creation of a book table of contents on a separate sheet with hyperlinks (PLEX add-on)