How to Print the Top Row or Column on Every Page in Excel

One can set options to print the sheet's headings or titles on each page if they need to print a sheet that will have many printed pages. Excel normally is automated to provide headings for columns (A, B, C) and rows (1,2,3). You will have to type titles in your sheet that describes the content in rows and columns.

Printing rows and column headings

For Microsoft office 2011

1. Click on the sheet

2. On the file menu, click print

3. Click preview to see how your sheet will print before printing

Printing row titles on every page

1. Click on the sheet

2. Click 'Repeat Titles' on the layout tab underprint

3. Tap in the "columns" to repeat at the left box and then on the sheet.

4. Select the column that contains the row titles, then click ok

5. On the File menu, click print

Note

Click preview to see how your sheet will print before you print to expand or minimize the page set up dialog box; to see more of your sheet, click on the icon with an arrow next to the box you clicked.

Printing column titles on every page

1. Click on the sheet

2. Click 'Repeat titles ' on the layout tab underprint

3. Tap in the "Rows" to repeat at the top box under the print titles, then select the row that contains the "column titles" on the sheet

4. Click ok

5. Click on Print on the File Menu

Note

Click preview to see how your sheet will print before printing

For newer versions of Microsoft

Printing rows and column headings

1. Click on the sheet

2. Select the print check box under the Headings on the page layout tab in the sheet options group

3. Click Print on the File Menu

Printing rows or column titles on every page

1. Select the sheet

2. Click on the page set up on the layout tab under the page set up a group

3. Click Print on the File Menu

Printing rows or column titles on every page

1. Select the sheet

2. Click on print titles on the page layout tab under the page to set up a group

3. Click in Rows to repeat at the top of columns to repeat at the left under the print Titles, then select the column or row that contains the titles you want to repeat

4. Select ok

5. Click Print on the File Menu

Using the Name Box trick

Follow these steps:

1. Select the header row

2. Click on the Name box field

3. Enter the text 'Print_TiTles by typing

4. Hit the enter button.

"first row" will repeat on every page when you print the dataset

Note

If you want to repeat multiple header rows or columns, select those first, then name these as print _Titles. This trick works in that when you use the page to set up a "dialog box" to set up the rows and columns that should be repeated, Excel automatically creates a Named Range with the name 'Print_Titles.