Ways to find the specified worksheet in Excel 2007

We usually get used to designing a large number of tables in the same Excel document. The Sheet tab bar displays up to five or six worksheet names at a time, that is, it cannot be sorted and the lookup feature is not supported. It's not easy to find a worksheet by name directly in the tab bar, but turning the page is enough for your eyes. Here are two ways to easily find a specific worksheet in Excel 2007.

Using a worksheet list

In Excel there is a list of names that provide all the worksheets, and you can easily find and switch to the specified worksheet in the list.

1. Display list

On the left side of the worksheet tab bar, there are four buttons that scroll and page, and right click here pops up a list that displays the names of all the worksheets in the current document. The list can display up to 15 worksheets at the same time, if the worksheet is within 15 you can find it directly on the list, which should be easier than flipping the tab bar?

When you have more than 15 worksheets, the other worksheets option appears at the bottom of the list. Select other sheets to open the Active document window (figure), which lists all the sheet names in the list of Windows. To find the name of the worksheet you want to view, double-click the item name with the left mouse button to switch directly to the worksheet.

2. Quick positioning

When you have a very large number of worksheets you may have trouble finding a worksheet directly in the list in the Active document window, and you can quickly navigate by pressing the keys on your keyboard. For example, press the H key of the keyboard to select the worksheet that begins with the first H, and then press H to select the worksheet starting with the second H, and so on. So you can quickly select the worksheet you're looking for by simply knowing the beginning of the worksheet name, and then clicking OK to switch to the worksheet. For all Chinese worksheet names, just call the Chinese input method to enter the Chinese words, such as February, and also select the sheet name that starts with February.

Note: For more accurate positioning, you should try to avoid adding the same text to the worksheet name as you want to name the worksheet. Of course, it would be more convenient to add the first letter of the corresponding keyword to the name of the worksheet before it is named.

With the lookup feature

Excel finds not only lists all eligible find content, displays the name of the worksheet in which it is located, but also switches directly to the corresponding cell by clicking the selection. With this we can easily customize a worksheet directory window that can be displayed all the time.

1. Set the mark

Click to select the First Sheet tab, and then hold down the SHIFT key and click the Last sheet tab to select all the worksheets at the same time. Then right click on the first row label select Insert to insert a row before the first row, and enter a A1 in the form that is not likely to be entered in the table (e.g. percent%) as a token. Return confirmation and then right click on the first row of the row label select "Hide" to hide the first line.

2. Find Directory

Click Find and select on the far right of the Start tab, and select Find in the Drop-down list. Click the Options button in the Find and Replace dialog box to display more options, and then click the Range Drop-down button to select Workbook. Then enter a percent of the lookup content and click the Find All button to find it.

This allows all cells in the current workbook to be a percent-percent display in the lookup window as a list, as well as the name of the worksheet in which it appears. Because only one cell per worksheet is percent percent, this shows the table of contents for all worksheets. Click any item in the list to switch directly to the appropriate worksheet.

Here we can click the "Sheet" button in the list title to let the displayed sheet name in ascending order, which makes it easier to find.