Print row and column headings

By default, Microsoft 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

Here’s how you can print column and row headings.

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

  2. Click Page Layout.

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

    Print check box in the Sheet Options group

  4. Click File, and then click Print.

    Keyboard shortcut You can also press Ctrl+P.

  5. Click the Print button or adjust Settings before you click the Print button.

    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.

Tip:  You can’t customize the numbers and letters in row and column headings to create your own row or column headers. If your goal is to print specific row or column headers on every page, label your columns or rows with headers in your worksheet. To print the column or row headers on every page, see Repeat specific rows or columns on every printed page.

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!