MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Header and Footer

Posted by Chris Jones on June 18, 2001 5:14 AM

Hey there,

I have a spreadsheet that has information from rows A to G that I would like to appear on every page. At the bottom I also have a certain number of rows that I want to have appear on each page.

When I try to create a header and footer it doesn't really allow me to use cells as the header and footer. Is it possible to do this?

Any help here would be greatly appreciated.

Posted by Dax on June 18, 2001 8:15 AM

Have a look at File,Page Setup, the Sheet tab and then Rows to repeat at top. However, you can't use this to print the same rows at the bottom although this would be possible with VBA.