Microsoft Excel 2010

Hide Worksheet Tabs, Scroll Bars if Not Needed

SUMMARY: If you're only using one worksheet in an Excel 2010 workbook, why display the worksheet tabs if you'll never use them? Also learn how to hide one or both scroll bars if not needed.

While some complicated Microsoft Excel 2010 workbooks may have dozens, if not more worksheets, you may sometimes create workbooks that only require one worksheet tab. In this case, why show the worksheet tabs if you don't need to use them? By hiding these tabs, and also the horizontal and / or vertical scroll bars, you can slightly increase the room onscreen used to display your workbook.

1. Open the workbook you wish to modify.

2. Select the "File" tab in the Ribbon.

3. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 2 and 3, press Alt + T, then the letter O.)

4. The "Excel Options" dialog box appears. Click "Advanced" in the left pane.

5. In the right pane, underneath "Display options for this workbook" (you may have to scroll down), make sure the desired workbook is selected in the pull-down.

6. Underneath, uncheck "Show sheet tabs".

7. If desired, hide the horizontal scroll bar to add some more room onscreen for your workbook - uncheck "Show horizontal scroll bar".

Hiding the sheet tabs and horizontal scroll bar for a particular Excel 2010 workbook

8. Uncheck "Show vertical scroll bar" to hide that as well, if desired.

9. Click "OK" on the bottom-right of the dialog box to close it.

Return to the Microsoft Excel 2010 page.

Thanks For Sharing!



Newest Tips

Cell Phone
[MODIFIED] Six Battery Conservation Tips
Google Search Engine
What is My IP Address?
Mozilla Firefox - Misc
Missing the Title Bar? Menu Bar?
Windows 8
Bring Back the Mouse Pointer Drop Shadow

Follow/Contact Us!


About MalekTips and the Author

The MalekTips website was created in 1998 by of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language.