Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
Subscribe for Free Excel tips & more!

Repeating The Row Headers On Each Page

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have a spreadsheet with several pages on it. I want to repeat the rows
headers that came on the first page on each page. How to do that?
Please help!!

View Answers     

Similar Excel Tutorials

Print Specific Rows or Columns on Each Page in Excel
How to repeat specific rows or columns on every printed page so that you know what each column or row means when y ...
Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Insert and Manage Page Breaks in Excel
How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and confusing but this tutori ...
Print Gridlines in Excel
I'll teach you how to show gridlines for Excel when you print your files. This is a neat little feature that will ...

Helpful Excel Macros

Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pag
Sort Data With Headers in Descending Order in Excel
- This Excel macro sorts data that has headers in descending order. This means that data is sorted Z to A and 10 to 1 - o
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Sort Data that Doesn't Have Headers in Descending Order in Excel
- Sort data in Excel that doesn't have headers using a macro. This Excel macro assumes that your data set does not have a
Sort Data With Headers in Ascending Order in Excel
- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it.

Similar Topics

I know that in Page setup I can "repeat rows at top", but is there a way to repeat different headers for different pages?

Page 1-2 is text,
Page 3-7 is data where I want the row header to repeat on each page.
Page 8-9 more text
Page 10-12 a different set of data with different row header information I want to repeat.

Can I have pages 3-7 with one repeating row header and 10-12 a different repeating row?

I like the repeating feature because the data is fluid and needs to adjust to different amounts of data. Today it might be pages 3-7, but tomorrow it might be pages 3-10 and everything reflows downward.

I have excel 2000.

Thanks in advance.

I am creating an annual report which includes the income statement, balance sheets, etc, and the notes to the accounts.

Basically, I need the first 2-3 pages with no headers or footers, I need the next page to have a certain header (lets say it is page 4). Page 5-7, will also have a unique header each page. And the rest of the pages will have the same header except for the last page.
Is there a way to assign headers and footers to different pages?

The data in the worksheet will change alot, and the amount of rows can increase or decrease in large numbers, so I need the headers to adjust by themselves. Any help would be gladly appreciated.

Hi all,

I know how use the print titles settings to replicate headers on every page. Is it possible to specify where to make this stop?

For example in a 10 page document...

I have the headers at the top of page 2, so i would want them to repeat on pages 3,4,5,6 & 7 but then to stop for pages 8,9 & 10.

Not sure if it is possible but thought I'd ask the question in hope

Many thanks,



Please do not tell me to use headers. I MUST use a function within a cell.

Why? ..because my customer has a complex header using the "repeat rows at top of page". These so-called header rows have formulas and functions and can not be re-created in the "Page Setup > Custom Header" field. They do not want the page number above their header, or at the bottom of the page. The want me to display the (page) and (pages) within the repeated rows.

Note: The same rows repeat at the top of every page, so the same cell that displays the page number info needs to keep track of how many times it has been displayed. I thought that maybe a global variable (counter) could be used.

Or, how about a custom Print function that continuously updates a global page number variable as it iterates through the pages using set print range - effectively printing one page at a time.

I know VBA, so solutions involving VBA are fine.

Thanks in advance,

I have a problem formatting my report in the way I would like to.

I want to repeat the top 10 rows and the first 4 columns of my report on
each page when I print it (therefore the text I want repeated makes an upside
down L shape)

I know that I need to do the following:

Rows to repeat: $1:$10
Columns to repeat: $A:$D

However, the report 'headings' in the first 10 rows include merged cells
(e.g I merge 6A - 6T). This causes a problem in the printed version of the
report, as any header text which is not 'alligned' with columns A-D will not
appear on any page other than the first page.

Only the text alligned with columns A-D is repeted on each page - the other
text that I want to see from the first 10 rows is not vissible

Is it possible to get round this without using the actual 'Headers' facility?

Thanks in advance

Hey guys,

I'm having a lot of trouble figuring this out. Any help is greatly appreciated!!

Basically, I want the top few rows on every page after the first page to be the same and not move, especially when I insert new rows above it.

This is for a purchase order type of form, so the first page will have customer and shipping information that I won't have to repeat on the other pages. However, what I do want to repeat at the top of each page after page 1 is the column headings for the order (i.e. quantity, product number, description, total cost, etc).

For each order I make (they are getting really, really long....20 pages or so) I add new items by inserting new rows, which moves the column heading on the next page down. I then have to go back and manually re-organize all the pages so each page has the column headings at the top of the page instead of having been pushed to the middle when I add new rows.

I hope this makes sense.....but I just want the column headings to freeze and stay put regardless of how many new rows I insert above it.

Freeze panes doesn't work because I don't want to just be able to scroll, I want each column heading physically present on each page. Headers WOULD work....except they only show up when printed (we are emphasizing a paperless environment).

Anyone have any ideas? I don't really know how to use excel well and it takes so much time to reorganize each order....Just wondering if anyone has a better way of doing this!

Thanks! Greatly appreciate it!

Most everything I found when Searching was people confused about Freezing their panes and Repeating Rows while printing.

I have a document that I want the same rows to repeat on each page that is printed. These rows are 1:5. In Page Setup, Rows to Repeat At Top, I have entered: $1:$5.

I also have columns that I want to repeat at the left of each page. These are columns A:B. In Page Setup, Columns to Repeat At Left, I have entered: $A:$B

I notice that these specifications work fine for the first page (obviously) and the second page. But, when viewing the 3rd page in Print Preview, it does not appear correctly.

On page 3, Columns A and B correctly appear to the left. Rows 1 to 5 appear at the top, but rows 1 and 4 are cut off where they would overflow into Column C and beyond.

Row 1 has text that is entered only in Cell A1 but overflows into B1. There is nothing in B1, so this is fine (the text all shows). Row 4 has text in Cell A4 but A4 is merged all the way to G4. The other rows appear as normal on Page three.

What I'm not understanding is why Page 2 displays rows 1-4 properly but Pages 3 and beyond do not. I thought it might have something to do with the fact that text overflows from column A, but then it shouldn't work on Page 2, right? I then thought that perhaps it has something to do with specifying both rows and columns to repeat at the top, but would that make sense?

Any guidance would be greatly appreciated. If it appears I've missed something simple, please point it out--I'll look like a dolt, but that's not bad from time to time.


I have a spreadsheet which has numerous "header rows" and corresponding data for each header. I should clarify that I'm not talking about "view - header and footer". There are various rows in the spreadsheet which I'm referring to as the "header".
When the file prints I would like to ensure a header is at the top of each page and there are 30+ pages so manually adjusting the page breaks isn't feasible. I'm familiar with using "Rows to repeat at top" under page setup, but that won't do the trick because there are different headers throughout the sheet.

Any ideas?

I have a macro that formats the printout for a report. It basically sets the page size, headers, footers, pagebreaks and ROWs to repeat.

However, last page of the report is summary page and doesn't need the Title block repeated on top.

Is there a VBA code that would allow me to select "Not to repeat the ROWs on last sheet"?

Thanks for any help I can get.



I'll try to explain as best as I can (sorry for my english). Im working with one worksheet, which has many many rows (287) and columns (7). It gaves me approx. 35 pages. I need to print them all with their headers.

So far everything is ok, I put the titles and they repeat on each page BUT they move around the page. I want to stick the header to the same place on EVERY page so the report looks consistent and profesional. Sometimes it gets to the middle of the page and much white space on top of the title. Im supposing it has to deal with the Page Breaks, but when I go to that view, I cant really do anything, all I do is mess it up even more.

One thing I see, is that in Normal View (excel 2007), it shows two kind of lines at the end of the pages: one with very little bites of lines and the other one with bigger lines.

How do I do to make the header/titles stick to the very top on each page???

I'm using a macro to format information on a sheet which has variable number of columns and rows. I've also set the left 3 columns to repeat on each page as well as the top 6 rows which produces the output I need but my client also needs a logo on the top right corner of each page. I can place the logo on the first print area page but when printing multiple pages from one sheet (as many as 6 A4 pages) the logo only appears on the first page and none of the subsequent pages.

Any ideas how the logo can be incorporated in the repeating header area?

Many thanks for any responses.


Is there any way of repeating multiple sets of rows at the top of subsequent pages?

It's difficult to put into words so as an example, I want to repeat rows 1 & 2 on each subsequent page, so I go to page setup>rows to repeat at top and enter them there - no problem.

But, can I somehow also get Excel to repeat rows 10 & 11 as well as rows 1 & 2, but not with rows 3 - 9?

Any help greatly appreciated!


Hi, as I am sure you know, in Microsoft word you can make a page numbers on each page in the headers and footers, and you can leave out this count for the first page.

I need something similar... I want it to start counting from the third page, and insert page number in specific cells if possible. If not, I can use the footer, but I don't want it to count the first 2 pages.

Also, is there a way to insert the page number or number of pages in a cell... Kind of like the function available in the header and footer, but to use in a cell?


I am preparing a spreadsheet which when printed will have about 10 pages of data, then a single summary page.

I would like all of the data sheets to have the same text row at the top of the page, then the summary page to have different text.

Using "Rows to repeat row at top" in Page Setup will force the same text to appear on every page including the summary page. Is there something like MS Word Section Break?

I could use a different sheet for the summary so that the top row could be specified separately, but it would be much easier for the person using the spreadsheet to have it all on a single sheet.

(It is not practical to put in forced page breaks with individual page headings)

I have a very long spreadsheet and each page needs a different header. The headers are done, however, not all will show.
I understand this is complicated to understand... Many headers will be hidden so more or less there will not be any pages with few or no lines of data, and other sheets without a header. (not important if you didnt understand this bit)

So... I need a page break to be applied above/below a specific cell if a condition is met. Currenty, if a cell in a specific column is equal to 1, I need a page break above it.
However, if needed, I can make it below, and change the value to anything else.

Any ideas?

Hi there

I have a spreadsheet that has 3 pages long when it is printed out. It has a title block at the top, and has "page number" information in it.

I would like the title block to be shown on every page of the spreadsheet in the print out, and what I have done is to go to "page layout" ribin, then "print titles", and select the title block area under the "rows to repeat at top" function. However, the problem is the page number information doesn't update, such that its got page 1 on all the pages when it is printed out.

Ideally, page 1 would have "page 1" in the title block, page 2 would have "page 2" in the title block, and page 3 would have "page 3" in the title block.

Can someone help me on this? Please don't tell me to use header and footer as it is not ideal for this project. It would be good if it can be done without VBA code.

Thank you

I am using Excel 2003 and we have a worksheet document that uses about 4 rows as repeating title rows for each page of the entire document. A printed worksheet document usually will have from 1 sheet or page to 10 sheets or pages.
Note: For this conversation sheet and page means the same thing.
As you might guess we want the repeating title rows for each sheet to indicate Page 1 of 5, Page 2 of 5, etc.
I guess it would be kind of like having a page number format in a cell that happens to be in one of the repeating title rows?

Note: I am just an average user of Excel so I know nothing about scripts or special programming, so your help in understanding how to do this would be greatly appreciated!

I've got a spreadsheet with headers in column A and in rows 9 and 10. The headers in column A start in row 11 and are sizes (i.e XS, S, M, etc..). The headers in row 9 start in column B and are names (ie. First, Second, Third). The headers in Row 10 can be either Net Sales or On Hand Units. There are then values starting in B11 to L19.

The headers in column A do not repeat but the headers in row's 9 and 10 can repeat. What I need to do is create a function for a report page that will total all of the values that match to a particular header in column A, the header in row 9 and the header in row 10. So for example I would want to get the total for any instance when the header in column A is M, the header for row 9 is Second, the header for row 9 is Net Sales.

I've attached a sample of what my data dump would look like as well as the separate reporting worksheet where I want the totals to appear. Thanks in advance for any help

I have a multipage table, like 100+ pages. Why not do it in Excel? Better widow/orphan control and because Excel is lousy at inserting/deleting rows in between rows that have some merged cells and because Excel is crap at putting good headers in (honestly, I understand having the header split into three parts by default, but what if I want a page spanning header?).

So, I copied the table headers into the page header, but now there's a space between the top table and the rest of the page. I want to remove that space, to make it look like the header is actually part of the tables on each page. Or, move the page up so that each page "overlaps" the blank white empty bottom part of the header.

Is there some sort of Word CSS element that I can use to set a negative padding element for the header or something?

I have a footer which places the page numbers on each page. I know that you can change the page number that excel starts with but what if I want the first page to not show the page number at all and start with the second page? Is there a way to do this?

I have 32 page breaks, on page one are the product names listed by rows, each
page break represents a different day in the month. How can I set page setup
to merge page one on with other pages I would like to print (say page one and
page 15 on the same page)?

Is there a way a header can correspond to a data? For example, if the 1st row is A, then the header is A. If the following row is different data, let's say B, the page breaks and the header should B. If rows have the same data which cover 2 pages, let's say the data is C, then the header should be C for both pages.

Here is the table supporting my example:

A (header)
A (data)
<---page breaks here because the next row has different data
B (header)
B (data)
B (data)
<---page breaks here because the next row has different data
C (header)
C (data)
C (data)
C (data)
C (data)
C (data)
<---page breaks here because the previous page that has data C is full and it continues in the following page
C (header)
C (data)
C (data)

If this cannot be done using headers in excel, my alternative solution is to have the 1st row of a page become a header then the second row and so forth will be the data. A loop may do but I am not sure how.

Your help on this is appreciated.

I have a rather large excel document. I've set the print area on one tab and have added a page break as I want columns C-Z on one page and columns AA-AN on a second page.

The page break works fine, but the page number at the bottom of the pages is the same. Instead of printing C-Z on page 7 and AA-AN on page 8, it labels both pages as page 7. Is there a way to fix this?

Is it possible to repeat what would be multiple pages in excel. Basically I have some fields where I tab through and complete some questions. It takes up exactly two pages when I print out the info from excel. Is it possible to make those two pages repeat, similar to a repeating page in word?


I am trying to do some formatting of my excel spreadsheet. I am trying to create where the only column and row headers are for the page I want. On thehe remainder of the sheet the column and row headers are hidden

I would also like the remainder of the sheet to be greyed out. Also when I scroll down it only scrolls the page I want and not continuous.

Unfortunately I am unable to attach anything to show, so I hope this makes sense.

Any help would be greatly appreciate