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

Microsoft Excel 2007 - Toggle Gridlines on Screen or Printed Copy

By default in Microsoft Excel 2007, cell gridlines (borders) are shown onscreen to supposedly make worksheet editing easier. However, these are not shown on paper as Excel presumes that you will manually create tables and borders as necessary.

If you want to toggle onscreen gridlines for the current worksheet, do the following:

1. Click the "Page Layout" tab in the ribbon at the top of Excel 2007.

2. In the "Sheet Options" group, underneath "Gridlines", check or uncheck "View" and/or "Print" to toggle gridlines on the screen or on the hard copy.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Toggle Gridlines on Screen or Printed Copy.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.