Worksheet Tabs not Visible | MyExcelOnline

When opening a new Excel file, you might only be able to view the worksheet but the worksheet tabs are hidden. This can be concerning as you won’t be able to view all worksheets and work on them.

Download this workbook to practice this tutorial on how to Excel unhide all worksheets and follow along:

DOWNLOAD EXCEL WORKBOOK

 

Problem 1:

Ever encountered this situation where you open your workbook and said “Where are my worksheet tabs ??”.

A common issue faced while operating on Excel is that all the worksheet tabs, which are shown at the bottom left of the window, are not visible to you.

excel unhide all

This is a simple settings problem that can be easily undone.

Solution:

Just follow the steps below to learn how to display the missing worksheet tabs:

STEP 1: Go to Files

Worksheet Tabs not Visible | MyExcelOnline

STEP 2: Click on Options

Worksheet Tabs not Visible | MyExcelOnline

STEP 3: Click on Advanced

Worksheet Tabs not Visible | MyExcelOnline

STEP 4: Under the Display options for this workbook, check Show sheet tabs.

Worksheet Tabs not Visible | MyExcelOnline

Now your sheet tabs will be available! Now you can easily navigate through the entire workbook, and work on all sheets.

Worksheet Tabs not Visible | MyExcelOnline

This is what to do when worksheet tabs go missing and you are unable to switch between different tabs!

 

Problem 2:

It can also be that some of your worksheets might be hidden, hence you will not be able to see them in the worksheet’s tab.

Here, we actually have two worksheets, but one of them is hidden.

Worksheet Tabs not Visible | MyExcelOnline

To show the worksheet tabs:

STEP 1: Right-click on any visible tab and select Unhide.

Worksheet Tabs not Visible | MyExcelOnline

STEP 2: Select the tabs you want to unhide and press on OK.

Worksheet Tabs not Visible | MyExcelOnline

Now both the worksheets will be visible to you on the worksheet’s tab.

Worksheet Tabs not Visible | MyExcelOnline

 

Conclusion

It is now clear that the problem of not being able to view worksheets is a simple settings issue, and after following this tutorial, you can easily rectify it and Excel unhide all.

Now you can continue with smooth functioning on Excel!

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn