How to hide the Sheet tabs in Excel 2010

In Excel 2010, the Sheet tabs displayed in a Workbook can be hidden using the Advanced options.


Click the File menu and then the Options link. In Excel Options window, select the Advanced the tab and scroll down to the Display options for this workbook  section. To hide the Sheets tabs in Workbook, un tick the checkbox labelled as Show sheet tabs. Click the OK button to save the changes.


In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 12 Comments
  • John Chambers January 19, 2012, 5:57 pm

    My sheet tabs at the bottom have disappeared. I checked MENU_OPTIONS_ ADVANCED and the “show sheet tab” is checked..
    There are no sheet tabs?

  • jay gilbert March 6, 2012, 7:41 pm

    I also lost my sheet tabs, and doing the above also doesn’t work for me. when I send the worksheet to another computer, they are there. how can I get them to show – the sheet tab is checked.

  • Dushyant Dave March 7, 2012, 7:51 pm

    Very helpful information. I was having hard time to find “Show Worksheet Tab” option.

    Thanks Ravi,

  • John March 28, 2012, 6:35 am

    I lost my sheet tabs. I found my “show sheet tabs” was checked. I unchecked it and they came back, but disappeared again. Now they won’t come back. Occassionally they will appear then disappear.
    Does MS have a fix for this?

  • Jack May 15, 2012, 8:55 pm

    Has anyone found out ‘how’ to make the sheet tabs REAPPEAR? Please help!

  • Kerry Hecht June 20, 2012, 2:18 am

    This doesn’t work for MAC. Any help?

  • Jerome Porter October 12, 2012, 1:40 am

    My sheet tabs and sliders for one of my Office 2010 workbooks were visible on October 10. When I opened the same workbook on October 11 the tabs and sliders were not visible. Inspection of the advanced options showed the options to SHOW the tabs and sliders were still checked.

    Does MS have a fix for this ? Does Ravi have a fix for this ?

  • Judith B November 26, 2012, 11:06 pm

    My problem is the same as Jerome Porter’s. HELP

  • Fionn Rogan December 5, 2012, 11:06 pm

    I also have the problem where sheet tabs don’t reappear regardless of whether the “Show sheet tabs” box is ticked or not.

    Can anyone in Microsoft bother to check this forum and help us with a fix?

    My (imperfect) workaround is to select Full Screen view and the sheet tabs are then visible.

  • Bonnie Huth December 30, 2012, 4:13 am

    I caot find how to change the name on the sheet tab. I added additional and want to give them a name

  • Ted Reeves August 3, 2013, 7:28 am

    your spreadsheet is not maximized.
    The same thing happened to one of my staff who thought I was nuts. The spreads sheet is set up to split screen, maximizing will fix the issure

  • Andy October 28, 2013, 9:31 pm

    Ted Reeves, you’re awesome. I was dealing with the same issue, and your super easy fix resolved it for me. All I needed was to maximize the worksheet. Well, that is somewhat embarrassing. Thanks again!

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.