Print Gridlines and Headings in Excel

Print the gridlines and headings to make a spreadsheet easier to read

Print Gridlines and Headings in Excel 2007
Print Gridlines and Headings in Excel. © Ted French

Printing gridlines and row and column headings often makes it easier to read data in your spreadsheet. However, these features are not automatically enabled in Excel. This article shows you how to enable both features in Excel 2007. It was not possible to print gridlines in versions of Excel before 2007.

How to Print Gridlines and Headings in Excel

  1. Open a worksheet that contains data or add data to the first four or five columns and rows of a blank worksheet.
  1. Click on the Page Layout tab.
  2. Check the Print box under Gridlines on the ribbon in order to activate the feature.
  3. Check the Print box under Headings in order to activate this feature as well.
  4. Click on the print preview button on the Quick Access Toolbar to preview your worksheet before printing it.
  5. The gridlines appear as dotted lines outlining the cells containing data in print preview.
  6. The row numbers and column letters for those cells containing data are present along the top and left sides of the worksheet in print preview.
  7. Print the worksheet by pressing Ctrl+P to open the Print dialog box. Click OK.

In Excel 2007, the main purpose of gridlines is to distinguish cell boundaries, although they also give the user a visual cue that helps align shapes and objects.