Forum Discussion
Heather156
Nov 21, 2023Copper Contributor
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.
- djclementsBronze 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.
- Heather156Copper Contributor
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?