rows to repeat at 'Bottom'

[itrymybest]

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.

http://www.microsoft.com/office/com...6-727577b7d2d1&dg=microsoft.public.excel.misc

 

[Bob I]

Put the info in a Footer perhaps

 

[Bob Umlas, Excel MVP]

Could you not put the information in the footer?

 

[itrymybest]

I tried placing the information in the footer; there is a lot of information
and the footer has limitations on formatting capabilities.

Should the person repeating information across the top rows just use the
header instead? Ultimately, the same reason one would put information in the
top rows to repeat across multiple pages is the same reason I would like the
option to place this information at the bottom of the page. It is
essentially a titleblock, and takes up the lower 1.5" of the sheet.

If the option to repeat rows across the bottom is unacceptable, the ability
to place a group of cells inside the footer would be nice as well.

 

[Jim Cone]

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
trial basis.
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.
(e-mail address removed) (remove xxx)
--
Jim Cone
Portland, Oregon USA



"itrymybest" <[email protected]>
wrote in message 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.

http://www.microsoft.com/office/com...6-727577b7d2d1&dg=microsoft.public.excel.misc

 

[Gord Dibben]

Take a picture of the cells using the Camera Tool.

Copy that picture and paste into MS Paint.

Save as a *.jpg

Add that graphic to your footer.


Gord Dibben MS Excel MVP