Excel2007 to find the specified worksheet two methods easily

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.