If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets.

Bạn đang xem: How to use column headings in excel

Select the worksheet that you want khổng lồ print.

On the Page Layout tab, in the Page Setup group, clichồng Print Titles.


Note: The Print Titles commvà will appear dimmed if you are working in cell editing mode, if a chart is selected on the same worksheet, or if you vị not have a printer installed.

On the Sheet tab, under Print titles, vày one or both of the following:

In the Rows to repeat at top box, type the reference of the rows that contain the column labels.

In the Columns to lớn repeat at left box, type the reference of the columns that contain the row labels.

For example, if you want to lớn print column labels at the top of every printed page, you could type $1:$1 in the Rows to lớn repeat at top box.

Xem thêm: Cách Bật Tính Năng Kết Đôi Trên Zalo, Lập Gia Đình Trên Zalo

Tip: You can also cliông chồng the Collapse Dialog button at the right over of the Rows to lớn repeat at top & Columns to repeat at left boxes, & then select the title rows or columns that you want lớn repeat in the worksheet. After you finish selecting the title rows or columns, cliông chồng the Collapse Dialog button again to return lớn the dialog box.

Note: If you have sầu more than one worksheet selected, the Rows khổng lồ repeat at topColumns lớn repeat at left boxes are not available in the Page Setup dialog box. To cancel a selection of multiple worksheets, click any unselected worksheet. If no unselected sheet is visible, right-clichồng the tab of a selected sheet, & then cliông xã Ungroup Sheets.

Next Steps

Once you have finished setting up your worksheet to include row and column headings or labels (also named print titles) on every page, you can go ahead & print your worksheet.

This feature is not available in Excel for the web.

If you have the Excel desktop application, you can use the mở cửa in Excel button lớn open the workbook and print rows with column headers.

Need more help?

You can always ask an expert in the Excel Tech Community or get in the Answers community.



Thank you! Any more feedback? (The more you tell us the more we can help.) Can you help us improve? (The more you tell us the more we can help.)