Excel - rows to repeat at 'Bottom'

Asked By itrymybest on 04-May-10 02:41 PM
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/community/en-us/default.mspx?mid=66558ac3-1c3f-4d4c-a5f6-727577b7d2d1&dg=microsoft.public.excel.misc




Bob I replied to itrymybest on 04-May-10 02:50 PM
Put the info in a Footer perhaps
Bob Umlas, Excel MVP replied to itrymybest on 04-May-10 03:22 PM
Could you not put the information in the footer?
itrymybest replied to Bob I on 04-May-10 04:37 PM
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 replied to itrymybest on 04-May-10 06:18 PM
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.
james.coneXXX@comcast.netXXX  (remove xxx)
--
Jim Cone
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.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=66558ac3-1c3f-4d4c-a5f6-727577b7d2d1&dg=microsoft.public.excel.misc
Gord Dibben replied to itrymybest on 05-May-10 06:50 PM
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