Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Disappearing tabs

Copper Contributor

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_0-1700552079915.png

 

3 Replies

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

best response confirmed by Hans Vogelaar (MVP)
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.

@djclements 

 

Thank you that worked.

 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
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.

View solution in original post