How to repeat row and column headers on every page of Excel spreadsheets

Printing large datasets in Excel is very common. Are you also printing your business data regularly? If yes, you also might be facing the same challenges. When you scroll up and down, you can easily see your row and column headers because the rows and columns are frozen. But as soon as you print the data, you can see the header only on the first page. And eventually, you run to the front page to check what type of data is present in each row or column. The tiresome tradition of turning the printouts back and forth will be entertained no more!

In this tutorial, we will cover the permanent solution to repeat the row numbers and column letters on every page of Excel Spreadsheets.

1. How to repeat Excel header rows on every printout
2. Print a header column on every Excel page
3. Get row number and column letters on every printout

Let's get started!

How to repeat Excel header rows on every printout

Many times your Excel data contains a large dataset, and you need to print it to show them to higher authorities. All you notice in the print preview section is that only the first Excel page contains the titles at the top. Don't worry! We can fix this for you.

Following the below steps and modifying the Page Setup settings, you can easily repeat the row header at the top of every Excel page:

1. Open the worksheet you want to freeze the row.
2. Go to the PAGE LAYOUT tab from the Excel ribbon tab.
   
3. From the Page Setup group, click on the Print Titles option.
   
4. The Page Titles window will appear. Go to the Sheet tab of the Page Setup dialog box.
   
5. Click on the Top arrow icon that you will find towards the right of the Rows to repeat at top option.
   
6. You will notice that the Page Setup window is minimized, and you will return to the original worksheet you selected.
7. At this point, the mouse cursor will change it shape to the black arrow. This feature allows the user to select an entire row with one click. You can select multiple rows as well.
8. The next step is to select the row titles that you want to repeat (or print) on every page. In our case, we have selected the first row.
   

Note: If you want to select multiple rows, click on the first row, simultaneously hold the cursor, and drag it to the last row. Remember, you can only select contiguous rows.

1. To return to the Titles window, press the enter button or you can click on the arrow button. In the right field box, you will see the selected row range is displayed.
   

Note: However, to avaoid so few steps (6-9), you can directly enter the Excel range in the range box. While entering the reference, you should always remember to use absolute referencing with the dollar sign ($). For example, if we want to display the first row on every document, the reference range should be formatted as $1:$1.

1. Once done, cross-check the changes in the Print Preview pane. You will have the final outcome where the top row is fixed for every page.

Refer to the below screenshot.

That's it! Some simple steps and you can print the column titles on every page. Time Saving right!

Print a header column on every Excel page

When you have too many columns in your worksheet, you might be required to fix the header column on the left to increase the readability of your worksheet. Since the worksheet is too wide, you must print the column headers on every page.

Following the below steps if you want to repeat the column titles at the left of every Excel page:

1. Open the Excel sheet you want to print.
2. Go to the PAGE LAYOUT tab from the Excel ribbon tab.
   
3. From the Page Setup group, click on the Print Titles option.
   
4. The Page Titles window will appear. Go to the Sheet tab of the Page Setup dialog box.
   
5. Click on the Top arrow icon that you will find towards the right of the Columns to repeat-at left option.
   
6. It will take you to the same worksheet that you opened earlier. Select the column (or multiple columns) you want to freeze on every printed paper. In our case we can selected column A.
   
7. To get back to the Titles window, press the enter button. Or you can also click on the arrow button again to get back. In the left field box, you will see the selected range is displayed.
   Refer to the below image.
   
8. You will find the Print Preview button at the end of the Page Setup dialog box. Click on it to look at your final document before printing. Here you will find that the first row is fixed for every page.
   
9. Click on OK to lock the changes.

Now you don't have to turn the pages back and forth to find what the values in each row mean. Follow a few steps and make your life easy!

Print row numbers and column letters

In Excel, the columns are represented by letters (A, B, C, D), whereas the rows are represented by numbers (1,2,3,4). By default, Excel only prints the row or column headers on the first printed page and skips the column letters and row numbers. But if you desire to repeat the alphabet and numbers on every page of your printouts, follow the below steps:

1. Open the Excel worksheet for which you want to freeze both the you want to freeze both the row numbers and the column letters.
2. Go to the PAGE LAYOUT tab from the Excel ribbon tab.
   
3. From the Page Setup group, Click on the PRINT option present under the Headings.
   

NOTE: You can also select the letters and alphabets option from the Page Setup window opened; click on the Print option below the Row and column headings box in the Print section.

1. Once done, cross-check the changes in the Print Preview pane. Go to File-> Print. Or you can press the shortcut key Ctrl+F2 to open the preview pane.
   
2. As a result, you will notice that the row and column headings are visible on every printed page.

Refer to the following image.

Hope the above view meet your expectations? :)

Including row and column headers in your printouts enhances readability and facilitates a better understanding of printed data. Using the Print Titles can immensely simplify your Excel experience, as having row and column titles on each page prevent you from getting lost in the printouts. So what are you waiting for? Try it today and reap the benefits!