Disappearing tabs

[Heather156]

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

[#2]

@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?

[#3 · Accepted solution]

@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.

[#4]

@djclements 

Thank you that worked.