Print row and column headings on every printed page

By default, Excel doesn't print the column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) that you see on screen.

Row and column headings on workbook

The following procedure shows you how to print column and row headings on every page of the printed workbook.

How

Icon image

Click the worksheet that you want to print with row and column headings.

Tabs at the bottom of a worksheet

Icon image

On the Ribbon, click the Page Layout tab.

Page Layout tab on Ribbon

Icon image

In the Sheet Options group, under Headings, select the Print check box.

Print check box in the Sheet Options group

 Note   You can also click Button image, and then under Print, select the Row and column headings check box .

To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Tips

  • The Print check box affects only the active worksheet. If you want to print row and column headings for additional worksheets in your workbook, you must follow the steps above for each individual worksheet.
  • To preview the worksheet before printing, press CTRL+F2.
  • By default, Excel uses the A1 reference style, which refers to columns as letters and rows as numbers. If you see numbers instead of letters in the column headings, your workbook is using the alternative R1C1 reference style. To switch back to A1 reference style, click the Microsoft Office Button Button image, and then click Excel Options. Click Formulas, and then, under Working with formulas, clear the R1C1 reference style check box.

R1C1 reference style check box in Excel Options dialog box

  • You can't customize the numbers and letters in row and column headings. If your goal is to label columns or rows in your worksheet, just click a cell, type the text that you want to use, and then press TAB or ENTER to move to the next cell. For example, you might label monthly sales numbers by entering the month names in cell A1 through A12.

Labels above columns

You can use the fill feature in Excel to quickly generate labels, such as a series of months. For more information, see Fill data automatically in worksheet cells.

 
 
Applies to:
Excel 2007