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.

image

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.

image



Meet the Author

Ravi Shankar

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

12 comments… add one

  • John Chambers Jan 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 Mar 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 Mar 7, 2012, 7:51 pm

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

    Thanks Ravi,

  • John Mar 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 Jun 20, 2012, 2:18 am

    This doesn’t work for MAC. Any help?

  • Jerome Porter Oct 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 Nov 26, 2012, 11:06 pm

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

  • Fionn Rogan Dec 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 Dec 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 Aug 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 Oct 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.