This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Visual Tweaks - Remove Scroll Bars to See More of the Spreadsheet Onscreen

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Visual Tweaks - Remove Scroll Bars to See More of the Spreadsheet Onscreen.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.