Forum Discussion
Mike Hill
Sep 30, 2017Copper 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 t...
- Oct 02, 2017
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.
SergeiBaklan
Oct 03, 2017Diamond Contributor
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".
Mike Hill
Oct 03, 2017Copper Contributor
Thanks for clarifying.