See all How-To Articles

How to View List of Worksheet Tabs in Excel & Google Sheets

This tutorial demonstrates how to view a list of worksheet tabs in Excel and Google Sheets.

 

view list of worksheet tabs 3

 

View List of Worksheets

At the bottom of an Excel file, you can see tabs representing each sheet. When there’s a lot of sheets in a document, not all of the tabs can be displayed at once. In the following example, there are 20 worksheets, but only 7 of them are displayed.

 

view list of worksheet tabs 1

 

To see the whole list of worksheets, right-click the arrow to the left of the sheet tabs.

 

view list of worksheet tabs 2

 

All worksheet names are displayed in the pop-up list.

 

view list of worksheet tabs 3

 

To jump to a certain sheet, select the sheet’s name (e.g., Sheet5), and click OK.

 

view list of worksheet tabs 4

 

Cell A1 in Sheet5 is now selected.

View List of Worksheets in Google Sheets

In Google Sheets, you can see the list of worksheets by clicking on the All Sheets icon to the left of the tabs.

 

google sheets view list of worksheet tabs 1

 

If you scroll through the list, you can see all sheet names. As in Excel, clicking on a sheet’s name leads you to that sheet.