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

Microsoft Excel 2003 - Printing Spreadsheets - Toggle Page Breaks View

If you are working on a large spreadsheet in Microsoft Excel 2003, it might prove beneficial at times to temporarily view how the spreadsheet will be paginated when printed. Then, after making any necessary changes so tables won't be split among pages, you can turn displayed page breaks off to make the document easier-to-read onscreen.

1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "View" tab.
3. Under "Window Options" check or uncheck "Page breaks" as desired.
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 - Printing Spreadsheets - Toggle Page Breaks View.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.