Forum Discussion
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.
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).
Aha, now I understand. You cannot change this I'm afraid, only by moving the split further to the right.
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.
I have this issue in that my tabs have literally all disappeared. I have 9 tabs in total in my xls. Luckily I am savvy enough to use / know shortcuts, so I can get around in my xls. But, for others to be able to use it I would like to get the tabs back into view.
Here a snapshot:
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.
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".
