How to Print Gridlines and Row and Column Headings in Excel 2010
In Excel 2010, you can print gridlines or row numbers and column letters on the page. Printing gridlines and row and column headings 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.
2Click 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.
3Click the Print check box in the Headings column of the Sheet Options group.
When this option is selected, the column letters and row numbers will print along with your data.