How to Display Sheet Tabs in Excel 2010

Excel workbooks are actually collections of different spreadsheets that you can use to organize data within one file. But the sheet navigation at the bottom of the window takes up valuable screen real estate and, if you want that extra space to be able to view more cells at once, you might decide to hide those sheet tabs. If you have personally hidden the sheet tabs in Excel 2010, or if someone else uses your computer and they have hidden them, then it can be difficult to switch between sheets in a workbook. Fortunately it is a simple process to restore these sheet tabs to the bottom of your workbook screen so that you can effortlessly navigate between sheets.


Have you been considering a switch to Windows 8? Learn more about the different versions and pricing to decide if making that switch is in your best interest.


How to Unhide Sheet Tabs in Excel 2010

If unhiding your sheets is a temporary effect, then you will be happy to know that you can simply reverse the process outlined below to go back to hiding the sheets. But for the purpose of showing your worksheet tabs below your Excel spreadsheet, which is the default setting, you can simply follow this procedure.


Step 1: Launch Microsoft Excel 2010.

Step 2: Click the File tab at the top-left corner of the window, then click Options.

excel 2010 options menu


Step 3: Click the Advanced option in the column at the left side of the Excel Options window.

advanced tab of excel options menu


Step 4: Scroll to the Display options for this workbook section, then check the box to the left of Show sheet tabs.

how to display sheet tabs in excel 2010


Step 5: Click the OK button at the bottom of the window to apply the change.


We have a number of other helpful articles about Excel 2010 on this site. Check out this page to see some articles that might help you with a problem you are having, or might give you an idea about how to customize Excel in a way that you didn’t know was possible. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.