How to List All Worksheets in One Workbook in Microsoft Excel 2003, 2007 and 2010?

There must be a collection of worksheets in the workbook, for many projects involving excel require you to work a number of worksheets in a workbook. Are you feeling effort-consuming to manage thoes worksheets with different sheet names? The best way to manage those worksheets is to list them in sorted order for convenient use. In this case, I recommend you Kutools for Excel.

It is much easier to list worksheets in excel with Kutools for Excel installed, if you are using a number of worksheets in one workbook. Kutools for Excel just provides a workbook/worksheet list called Excel Explorer, which better list the worksheets in excel vertically into one group at the left panel side. The below instruction shows you how to list worksheets in excel workbook.

Open one workbook;
Navigate to Kutools tab;
Click Excel Explorer in the Home group, see it below:

Kutools-explorer

There appears an Excel Explorer window at the left panel side below the ribbon. The open workbooks are listed in the Workbooks group, while the worksheets in the Worksheets group at the bottom. Select any one from the Workbooks group, its worksheets will be automatically displayed below by the sheet name.

If the list sheet names are not clear for you, the font size of those worksheet name can be increased or decreased by clicking the “A” or “A”. Users can easily browse the excel data in one workbook by clicking the sheet names from the list worksheets group.

See it below:

worksheets-list

But if you have not Kutools for Excel, when open a workbook, you can view the worksheets list at the bottom of the excel window. If handling multiple sheets, I am afraid that the bar will become narrow, and you have to use the left and right arrow key to find them.

See it below:

worksheets-list-at-bottom