How to repeat some rows and columns at every page?

[khardu]

Hello there.

I have my sheet set up horizontally, containing data from A1 to BR46 (almost 7 pages). I have some data in A1:H3 that I want to repeat at every page's top. I also have a column that I want on every page. I tried "Rows to repeat at top" and "Column to repeat at left". The Column appears on every page, but Rows appear only on first page. Is there any way to fix it?


Thank you.

 

[Andrew Poulsom]

If you set 'Rows to repeat at top' to $1:$3 they will appear on every page. You can do it by pointing with your mouse in the RefEdit control on the Sheet tab of the Page Setup dialog. On your worksheet you will need to repeat what's in A1:H3 at each vertical page break. Excel only prints what's in the repeating rows above each page.

 

[khardu]

Thank you Andrew Poulsom!!