Print rows with column headers on top of every page
Select the worksheet that you want to print. On the Page Layout tab, in the Page Setup group, select Print Titles. Note: The Print Titles command will appear dimmed if you are working in …
Print headings or titles on every page in Excel for Mac
On the Page Layout tab, select Page Setup, then the Sheets tab. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the …
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.
Print the top row on every page - Microsoft Support
In a worksheet that will take more than one page to print, you can print column headers on each page so the column headings can be seen on each page. On the Page Layout tab, in the …
Print row and column headings - Microsoft Support
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. Follow these steps to print the column and row …
Headers and footers in a worksheet - Microsoft Support
Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. You can also use the Page Setup dialog box if you want to insert headers or footers for more …
Print a PivotTable - Microsoft Support
Page Layout view is useful for getting your data ready for printing. For example, you can use the rulers to measure the width and height of the data, change the page orientation, add or …
Repeat table header on subsequent pages - Microsoft Support
You can set up the table so that the table header row or rows appear on each page automatically. You can choose from two ways to set up your table so that its header row or rows repeat.
Page Setup - Microsoft Support
Print titles Select an option under Print titles to print the same columns or rows as titles on every page of a printed worksheet. Select Rows to repeat at top if you want specific rows as your …
Set or clear a print area on a worksheet - Microsoft Support
On the Page Layout tab, in the Page Setup group, click Print Area, and then click Add to Print Area. When you save your workbook, the print area is saved as well.