Print row and column headings on every printed page

By default, Excel does not 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.


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, and then click Print.


  • 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 File tab and then, click 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, 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.

  • To print specific data at the top or side of each printed page, such as the names of the months that appear across the first row or down the first column of a worksheet, see Repeat specific rows or columns on every printed page.

  • To add headers or footers to your printed worksheet, see Use headers and footers in worksheet printouts.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!