Pinterest Pixel

Worksheet Tabs not Visible

When opening a new Excel file, you might only be able to view the worksheet but the... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Break Line on Worksheet

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 Worksheet-tabs.xlsx

 

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.

Worksheet Tabs not Visible

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

STEP 2: Click on Options

Top 20 Common Excel Problems Solved

STEP 3: Click on Advanced

Top 20 Common Excel Problems Solved

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

Top 20 Common Excel Problems Solved

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

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

To show the worksheet tabs:

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

Worksheet Tabs not Visible

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

Worksheet Tabs not Visible

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

Worksheet Tabs not Visible

 

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!

 

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

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!