Software

Ask something
Discussion Locked

Use template for header/footer?

0 helpful
2 replies

by kcliff

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have running data in a worksheet of which each 12 rows needs to print on a separate page. Each printed page needs to have the same rows printing at the top and bottom of the printed pages (similar to a header/footer but there's too much info for a footer). In addition, I need the page number to print within the repeating rows at the top (not in a header because it can't be at the very top of the page). Can this be done using a template or is there a formula that can be inserted in a cell that will display the page number?

2 replies

by jdgretz

Wow - so what was second prize?

The repeating rows at the top of each page is easy - go to File|Page Setup|Sheet
Select "Rows to repeat at top" and you're there.

Next, page numbers withing cells - see the following link for an answer to that one without using VBA

http://www.dicks-blog.com/archives/2004/12/22/page-of-pages-in-a-cell/

Finally, I don't know of any method of getting rows to repeat at the bottom of a page - you may be able to do this programatically using VBA, but I'm not sure.
jdg

by kcliff

Getting the rows to repeat at the top wasn't the problem. It was getting BOTH the top and bottom to print. It would have been easy using repeat rows at the top and a footer but there was too much info for a footer.

I'll use the suggestion for getting the page number to print within a cell and see if I can then create a macro to do what I need.

This discussion is closed to new replies.