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".
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.
The MalekTips website was created in 1998 by Andrew Malek 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.