How to Repeat Row and Column Headings When You Print in Excel 2007
Adding a Standard Header or Footer in Excel 2007
How to Use Excel 2007’s Scale to Fit Printing Options

Printing Gridlines and Row and Column Headings in Excel 2007

In Excel 2007, you can print gridlines or row numbers and column letters on the page. Selecting these options results in a printout that closely resembles what you see on-screen. This feature is useful if you need to examine the cell references of printed data and then more easily make any necessary corrections in the worksheet.


Click the Page Layout tab in the Ribbon.

Notice the check boxes in the Sheet Options group.


Click the Print check box in the Gridlines column of the Sheet Options group.

Check this option to print the gridlines surrounding each cell in the worksheet. By default, these gridlines do not print.


Click the Print check box in the Headings column of the Sheet Options group.

When this option is selected, the column letters and row numbers in the worksheet frame will print along with your print selection.


Preview the worksheet before printing to see the effect of displaying gridlines and/or column and row headings.

Remember to deselect both Print check boxes to return them to their default settings, as necessary.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Adjusting Page Breaks in Excel 2007
Selecting a Printer in Excel 2007
Previewing Pages in Excel 2007 with Print Preview
Printing a Worksheet in Excel 2007
How to Print Formulas in an Excel 2007 Worksheet