Forum Discussion

Limeyczar's avatar
Limeyczar
Copper Contributor
Aug 29, 2021
Solved

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.

  • Limeyczar 

    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.

     

2 Replies

  • Limeyczar 

    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.

     

Resources