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.
The following procedure shows you how to print column and row headings on every page of the printed workbook.
How
 |
Click the worksheet that you want to print with row and column headings.
|
 |
On the Ribbon, click the Page Layout tab.
|
 |
In the Sheet Options group, under Headings, select the Print check box.
Note You can also click  , and then under Print, select the Row and column headings check box .
To print the worksheet, press CTRL+P, and then click Print.
|
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 File tab and then, click Options. Click Formulas, and then, under Working with formulas, clear the R1C1 reference style check 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.
You can use the fill feature in Excel to quickly generate labels, such as a series of months.
