Shortest method to navigate
to a worksheet
Your workbook is huge. It has dozens
of sheets. After working in a certain sheet you need to return to the Master
sheet/Index sheet or whatever name you call it.
You could, of course, add a hyperlink
to the master sheet from each and every sheet but that, of course, isn't practical.
On the other hand, the
"classical" method (as shown in the next two pictures) is also a cumbersome and time-consuming
two-phase process.
Old method 1: right-click the navigation icon < to display the worksheets' list
Old method 2: scroll through the list. When you reach the sheet press OK
So what's the best solution?
Creating a named range and using it with one click 😊
1. Press CTRL+F3
to go to the Name Manager
CTRL+F3: Opening the Name Manager
2. Press Alt+N
(or simply click the New… button) to define a new name
3. In the New
Name pane that opens, click: O (for
One) in the name. Of course, you can choose any name. I chose the shortest 'cause
I'm lazy 😊
4.
In the Refers to type: =INDEX!$A$1
(or: Sheet1!$A$1
or whatever the name of your master sheet is) and press: OK
Defining the shortcut to the INDEX worksheet
Now, from any worksheet, in order to navigate
to the INDEX sheet, just:
1. CTRL+G (or F5) to open the go to pane
2. Type: O
3. Press: OK
Fastest navigation to the target sheet
If you're nimble enough, you can do it
in less than 200 milliseconds !!!!
Do you have a faster way?
אין תגובות:
הוסף רשומת תגובה