ICAEW.com works better with JavaScript enabled.
Exclusive

Excel and the lost sheet tabs

Author: Simon Hurst

Published: 21 Jan 2020

Exclusive content
Access to our exclusive resources is for specific groups of students, subscribers and members.

Update: from the 2013 version Excel uses a Single Document Interface (SDI) so this should not be a problem for Excel 2013 and later.

Now you see them:

Illustration 1

Now you don't:

Illustration 2

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.

Illustration 3

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)

Excel community

This article is brought to you by the Excel Community where you can find additional 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.

Excel polaroid
Topics
Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250