How to Show Grid Lines When Printing in Microsoft Excel

Written by dana schafer | 13/05/2017
How to Show Grid Lines When Printing in Microsoft Excel
Adjust layout settings to print grid lines in Excel. (white wall grid pattern image by Radu Razvan from

In Microsoft Excel 2007, grid lines are automatically displayed in worksheets; however, grid lines do not print automatically on a worksheet. If you want to print the grid lines on a worksheet, you have to change the Page Layout settings. In addition, people often confuse the cell borders in a worksheet with the grid lines in Excel. Grid lines are not the same as borders and cannot be customised in the same way that you would customise a border.

Open the worksheet or worksheets in Excel that you wish to print. You can do this by clicking on the

worksheet tab at the bottom of the screen. To select more than one worksheet, after you select the first worksheet, press Shift and then select the second or multiple worksheets.

Go to the "Page Layout" tab on your menu bar for Microsoft Excel 97-2003 or interface for Microsoft Excel 2007.

Select the "Sheet Options" group and click on the "Print" check box under "Gridlines."

Preview the grid lines to view how they will print by pressing the "Ctrl+F2" keys to open the Print Preview window. Remember that grid lines are only designed to print around inputted data in a worksheet. To print grid lines around empty cells you must change the print area.

Select the empty cells on the worksheet that you want to include with grid lines as well. Go to the "Page Layout" tab. In the "Page Setup" group, select "Print Area" and then click "Add to Print Area."

Go to the Microsoft Excel button for the 2007 version and click "Print." For Excel 97-2003, go to the menu and select "Print."

Go to "Page Setup" and "Sheet" tab. Make sure that the "Draft" quality box is not checked.

Download the latest driver for your printer from the manufacturer's website if the grid lines still are not printing. Sometimes a problem with the printer driver interferes with printing instructions.

Change and apply borders to the cells if you are having trouble with grid lines.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.