4 Fixes When Excel Worksheet Tabs Are Not Showing

Maria is a Content Writer with a keen interest in Technology and Productivity Tools. Her articles can be found on sites such as Onlinetivity and Delesign. Outside of work, you can find her mini-blogging about her life on social media.

Afam has been a content writer with Guiding Tech Media since August 2023. However, his experience in tech writing dates back to 2018, when he worked as a freelance writer for Make Tech Easier. Over the years, he has grown a reputation for publishing quality guides, reviews, tips, and explainer articles. His work is featured on top websites, including Technical Ustad, Windows Report, and Next of Windows. He has training as a Microsoft Certified Professional and has covered more Microsoft-related guides on these platforms.

Basic Fix:

Fix 1: Enable Show Sheet Tabs

In the Advanced Settings for Excel, adjust the display options for your workbook. One of the changes you can make to your display options is ensuring the sheet tabs show. Here’s how to update your Excel advanced settings.

Step 1:On the Excel Ribbon, click theFiletab.

Step 2:Click theMoreoption on the left to launch the Excel Options window.

Step 3:Click theAdvancedtile from the prompt.

Step 4:Go to theAdvancedtab.

Step 5:Tick the box forShow sheet tabsunder the Display options for this workbook section.

Fix 2: Reduce the Width of the Scrollbar on the Excel Window

The scrollbar width on your Excel worksheet can also affect your sheet tabs and prevent them from showing. Here’s how to reduce the scrollbar of your Excel window.

Step 1:Move yourcursorto the bottom and position it where your scrollbar starts from.

Step 2:Place yourcursorat the start of the scrollbar or beside the three dots at the head of the scrollbar. Your cursor should turn to a double-headed arrow.

Step 3:Click and drag thescrollbarto the right to reduce its width and reveal the other hidden tabs.

Fix 3: Unhide Hidden Worksheets

If your worksheet tabs still do not show after trying the above fixes, they may be hidden or deleted. Here’s how to check and unhide hidden worksheets in Excel.

Step 1:Move yourcursorto the bottom of the Excel workbook and place it on the name of a visible worksheet tab.

Step 2:Right-click the tab and selectUnhideto reveal the hidden sheets in the workbook.

Step 3:Select thesheetsyou want to unhide and clickOK.

Fix 4: Arrange the Window View of the Excel Workbooks

If you have multiple Excel workbooks open, arrange their view to keep showing all worksheet tabs. Here’s how to do so:

Step 1:On the Excel Ribbon, click on theViewtab.

Step 2:In the Window group, clickArrange All.

Step 3:On the Arrange Window dialog box, selectTiled.

Step 4:ClickOKto save your change. This will rearrange all open workbooks on the PC window, ensuring the tabs are visible.

You may followour other guideto fix this problem if changes are not saved.

Was this helpful?

Last updated on 29 August, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

8 Best Free AI Graphic Design Tools You Can Use on Your Web Browser

How to Use Beauty Filter in Zoom Meetings

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.