You have a unanimous opinion, including mine, that utilizing the page footer is the way to go.
Your only alternative, that I know of, is the commercial add-in "Special Print" that I make available on a 3 week free
It consists of 3 utilities including one called "Rows to Repeat at Bottom".
It makes a copy of the worksheet, adds the repeating rows, and you print from the copy.
It can take a while to build, a minute or so, on spreadsheets with several thousand rows.
Just email and ask for it, if you want to give it a try.
No obligation, no registration.
I do ask that you use your real name and indicate your geographic location.
james.coneXXX@comcast.netXXX (remove xxx)
Portland, Oregon USA
Currently, MS Excel has the option to repeat certain rows at the top of the
document. It would be lovely, very lovely actually, if the option to choose
rows to repeat at the bottom were an option. To date, 90% of our documents
need this 'title' information to be at the bottom of the page.
Any help with this would be much appreciated.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.