Forum Discussion

Heather156's avatar
Heather156
Copper Contributor
Nov 21, 2023
Solved

Disappearing tabs

One of the spreadsheets I use regularly has lost all its tabs.  I have followed the instructions in the help menu of Excel but nothing has worked

 

 

  • Heather156 It appears as though the horizontal scroll bar at the bottom has been expanded too far to the left, to the point that the sheet tabs have been hidden from view. Just click on the three vertical dots (located in the bottom left-hand corner of your screen, beside the horizontal scroll bar) and drag to the right until you are satisfied with the sheet tab visibility to scroll bar size ratio.

  • djclements's avatar
    djclements
    Bronze Contributor

    Heather156 It appears as though the horizontal scroll bar at the bottom has been expanded too far to the left, to the point that the sheet tabs have been hidden from view. Just click on the three vertical dots (located in the bottom left-hand corner of your screen, beside the horizontal scroll bar) and drag to the right until you are satisfied with the sheet tab visibility to scroll bar size ratio.

  • Heather156 

    This doesn't work?

    File > Options > Advanced > section 'Display options for this workbook' > Tick check box 'Show sheet tabs' > click OK.

     

    Is the workbook a macro-enabled workbook?

Resources