- You should ensure sheets are configured to show before trying other complex solutions.
- You can reduce the scrollbar’s width to ensure that some of the tabs are not truncated.
- Unhiding your worksheets can also be a perfect solution.
Basic Fix:
- Resize Excel window: When you notice that the tabs of your Excel workbook are not visible, first confirm that other opened programs do not block the tabs. You should also consider whether your computer screen resolution is higher than the workbook’s. You should click the maximize button.
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 the File tab.
Step 2: Click the More option on the left to launch the Excel Options window.
Step 3: Click the Advanced tile from the prompt.
Step 4: Go to the Advanced tab.
Step 5: Tick the box for Show sheet tabs under 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 your cursor to the bottom and position it where your scrollbar starts from.
Step 2: Place your cursor at 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 the scrollbar to 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 your cursor to the bottom of the Excel workbook and place it on the name of a visible worksheet tab.
Step 2: Right-click the tab and select Unhide to reveal the hidden sheets in the workbook.
Step 3: Select the sheets you want to unhide and click OK .
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 the View tab.
Step 2: In the Window group, click Arrange All .
Step 3: On the Arrange Window dialog box, select Tiled .
Step 4: Click OK to save your change. This will rearrange all open workbooks on the PC window, ensuring the tabs are visible.
You may follow our other guide to fix this problem if changes are not saved.
