Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Visual Tweaks

Remove Scroll Bars to See More of the Spreadsheet Onscreen

Summary: Stop scrolling through Microsoft Excel 2003 spreadsheets with the mouse; use the keyboard instead and save screen real estate for the spreadsheet.

If you need to see more spreadsheet data onscreen, you can disable the scroll bars from appearing. Note that this does not prevent you from moving through a large spreadsheet; you can still do so using the cursor and Page Up/Page Down keys. If you don't use the mouse often when performing data entry in spreadsheets, you may find this method of navigation easier to use anyway.

1. Click "Tools" - "Options".

2. When the "Options" multi-tabbed dialog box appears, click the "View" tab.

3. Underneath "Window options", uncheck "Horizontal scroll bar" and "Vertical scroll bar". Note that unless you also uncheck "Sheet tabs", unchecking "Horizontal scroll bar" will not show any more of the spreadsheet onscreen, as space must be reserved to display the sheet navigation tabs.

4. Click "OK" to close the dialog box.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Visual Tweaks page.

Print this tip.

- Subscribe!

Search the Site: