Excel and the lost sheet tabs

by Simon Hurst on 21.01.2010 05:42

Now you see them:

Now you don't:

This is an apparently simple problem, but I've seen it happen so often now that I thought it was worth covering, just in case it saves a few people from a minute or so of keyboard-pounding frustration.


If you have a workbook open in Excel and its window is not maximised , if you 'restore' the overall Excel window to a shorter window, the sheet tabs are no longer visible. There are a few other ways to achieve this as well. However it occurs, if your sheet tabs disappear, the first thing to try is to maximise the workbook window by double-clicking in the title bar or clicking the maximise button.

If the window doesn't have a title bar, then go to Window, Arrange, Vertical (Excel 2007:View ribbon, Window section, Arrange All, Vertical) - you should now be able to see the title bar to maximise the window and restore the sheet tabs to visibility.

Incidentally, there is also an Excel option to turn off the display of sheet tabs, so that's worth checking if the above doesn't work - Tools, Options, View, Windows options, Sheet tabs (Excel 2007: Office button, Excel options, Advanced, Display options for this workbook, Show sheet tabs)

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.