If you have a fairly large number of worksheets in your workbook, how do you quickly select a worksheet after you open the workbook?
For example, in the following workbook, there are 11 worksheets, and the table names use numbers.
In other words, if you have dozens of or even more than 100 worksheets, how can you quickly select the form you want to open from among the many table names?
The method is as follows, there are two methods.
I. General Benefit method
Look at the picture below, the part of the red circle, called the Name box.
Enter the name of the table in the Name box, and then type the exclamation point into the A1 cell, and then press ENTER to quickly select it. The input in the Name box, formatted as:
Table name! Cell Address
For example, sheet99! A1
This method, which is a fast and versatile method, is applicable in any case. The key point is that you must remember the name of the table.
Ii. the method of expedient choice
If you don't have a lot of tables, you can use this method.
Pay attention to the part of the red line of the map, as long as the right mouse click that part, will pop up the list of the names of all tables, and then you can use the mouse to find and select the name of the table you want to select.