SOLVED
Home

Missing Excel 2013 worksheet tabs

Highlighted
Mike Hill
New Contributor

Missing Excel 2013 worksheet tabs

I have an Excel 2013 workbook with multiple sheets. I recently modified one of the sheets to split the window in order to keep column A and row 1 from scrolling. Now I noticed the worksheet tabs at the bottom for the other sheets is missing. There's a popup that says I need to Right-click in order to see the other worksheet tabs. If a different sheet is active I can see the tabs for the other sheets, but if the split window sheet is active there are no worksheet tabs. Is this the correct Excel behavior? Thanks.

7 Replies

Re: Missing Excel 2013 worksheet tabs

Very odd indeed, haven't seen that one before. Can you post a screen-shot perhaps?

Re: Missing Excel 2013 worksheet tabs

I've attached a series of screen shots. If the left pane of the split window is too narrow the worksheet tab names at the bottom collapse. If you hold the mouse over the worksheet tab arrows a popup is displayed (see ExcelTabs04.png).

Solution

Re: Missing Excel 2013 worksheet tabs

Hi Mike,

 

Yes, that's correct behaviour, there is simply not enough space to show the tabs. You may use right click, or click on 3 dots if they are visible, or temporary move split line to the right.

 

In general better to use Freeze panes if that's suitable in your case.

Re: Missing Excel 2013 worksheet tabs

Aha, now I understand. You cannot change this I'm afraid, only by moving the split further to the right.

Re: Missing Excel 2013 worksheet tabs

Thanks for the information. I tried using Freeze panes but wasn't able to freeze the first column and first row at the same time. There's also a Freeze Panes current selection option but I wasn't able to determine how the "current selection" is determined.

Re: Missing Excel 2013 worksheet tabs

Mike, stay on cell B2 and select first option from Freeze Panes drop-down menu - first column (A:A) and first row (1:1) will be frozen. That is "based on current selection".

Re: Missing Excel 2013 worksheet tabs

Thanks for clarifying.

Related Conversations
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777  in  Excel  on
43 Replies
Complex INDEX MATCH - Need assistance
Monica Bossert  in  Formulas and Functions  on
30 Replies
Excel filter issues
P DS  in  Excel  on
13 Replies