Managing large Excel workbooks with multiple worksheets can be challenging. When a file contains dozens of sheets, navigating through tabs at the bottom can become time-consuming. Fortunately, Excel 2013 provides ways to quickly view a list of all worksheets, making it easy to jump to any sheet without scrolling endlessly.
This guide shows you simple methods to view and navigate worksheets in Excel 2013.
Why You Might Need a Worksheet List
-
You have a large workbook with many tabs.
-
You want to quickly switch between sheets.
-
You need a visual overview of your workbook structure.
Having a list of worksheets saves time and improves productivity.
Method 1: Use the Sheet Tab Navigation Buttons
Excel 2013 has built-in navigation buttons to view and access all worksheets:
-
Open your Excel workbook.
-
Look at the bottom-left corner of the window, near the sheet tabs.
-
You’ll see four small arrow buttons:
-
First sheet:
|< -
Previous sheet:
< -
Next sheet:
> -
Last sheet:
>|
-
-
Right-click on any of these buttons.
A popup list of all worksheets will appear.
5. Click the worksheet name from the list to jump directly to it.
Tip: This method works well for workbooks with dozens of sheets, letting you find any sheet instantly.
Method 2: Use the Go To Dialog Box
Another quick way to navigate worksheets:
-
Press Ctrl + G or F5 to open the Go To dialog box.
-
In the Reference field, type the sheet name followed by an exclamation mark. For example:
-
Sheet5!A1
-
-
Press Enter to jump directly to that sheet.
This method is ideal if you know the sheet names and want to move quickly without scrolling.
Method 3: Use a Macro to List All Worksheets
If you want a complete list of sheets in a separate sheet:
-
Press Alt + F11 to open the VBA Editor.
-
Click Insert → Module.
-
Paste the following code:
-
Press F5 to run the macro.
-
A new sheet named SheetList will appear with all worksheet names listed.
This is perfect for large workbooks where scrolling is impractical.
Method 4: Use the Name Box for Quick Navigation
-
Locate the Name Box above column A.
-
Type a cell reference including the sheet name, like:
-
Sheet3!A1
-
-
Press Enter to go to that sheet immediately.
This is a faster alternative for jumping between known sheets without using macros.
Final Tips
-
Right-clicking the navigation arrows is the fastest way to see all worksheets in a list.
-
For workbooks with 20+ sheets, consider creating a table of contents sheet using Method 3.
-
Keep your sheet names short and descriptive to make navigation easier.
By using these methods, you can efficiently manage and navigate multiple worksheets in Excel 2013, saving time and reducing frustration.