Forum Discussion
Limeyczar
Aug 29, 2021Copper Contributor
Office 365 Excel worksheet not displaying sheet tabs.
This happens when I open an old excel 2010 worksheet. I have opened other 2010 worksheet with no problem.
- Aug 29, 2021
This is because the window has been split vertically.
On the View tab of the ribbon, click the Split button to turn it off. The sheet tabs will reappear.
If you want to see the first three columns even of you scroll to the right, select column D, then click Freeze Panes > Freeze Panes on the View tab of the ribbon. this won't affect the visibility of the sheet tabs.
HansVogelaar
Aug 29, 2021MVP
This is because the window has been split vertically.
On the View tab of the ribbon, click the Split button to turn it off. The sheet tabs will reappear.
If you want to see the first three columns even of you scroll to the right, select column D, then click Freeze Panes > Freeze Panes on the View tab of the ribbon. this won't affect the visibility of the sheet tabs.
- LimeyczarAug 31, 2021Copper Contributor