Friday, February 1, 2019

Print row and column headings

Print row and column headings

By default, Excel doesn't print the column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) that appear along the borders of the sheet.

Row and column headings on workbook

Follow these steps to print the column and row headings for a worksheet:

Icon image

Click the worksheet. If you want to do this for multiple worksheets, you can group them.

Excel worksheet tabs shown at the bottom of the Excel pane

Icon image

On the Ribbon, click the Page Layout tab.

Page Layout tab on the Ribbon

Icon image

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

Page Layout > Sheet Options > Print Headings

Note: You can also click the small expansion icon 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

  • 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, go to File > Options > Formulas, and then, under Working with formulas, uncheck the R1C1 reference style check box.

    If you're using Excel 2007, click the Microsoft Office Button Office button image and then click Excel Options > Formulas.

    File > Options > Formulas > Working with formulas > R1C1 reference style

  • 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 to move to the next cell. For example, you might label monthly sales numbers by entering the month names in cell A1 through L1.

    Using a row for table headings, like January, February, March, etc.
     

    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. You can also set your data up as an Excel table, which can automatically set the first row as a header row.

  • 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 of a worksheet—see Repeat row or columns on every printed page.

  • To add headers or footers to your printed worksheet, see Headers and footers in worksheets.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

No comments:

Post a Comment