Quickly Find a Worksheet in an Excel Workbook With Many Sheets

In a workbook with many sheets, you easily can select the sheet you want from a list of sheet names in your workbook. And you don't need VBA to do it.

94

In a workbook with many sheets, you easily can select the sheet you want from a list of sheet names in your workbook. And you don't need VBA to do it.I’m not opposed to using VBA. I think it’s great fun and it can be very useful. But in a business setting, if VBA need not be used, it needs not to be used.

Recently, for example, someone asked an Excel forum how to write a VBA macro that would list all the sheets in a workbook. This macro is needed, the Excel user said, because he has a lot of sheets in his workbook and he wants a quick way to find a specific sheet.

There’s an easier way to solve this problem.

Just right-click on the little arrows in the bottom-left corner of your workbook. You’ll see a list of up to 15 worksheets in your workbook. If your workbook contains more that 15 sheets, click on More Sheets at the bottom of the list. This brings up a dialog that lists all sheets in your workbook.

To activate any of the sheets in the list of 15, just click on the name. In the dialog, just double-click on the name, or select the name and then choose OK.