rows to repeat at 'Bottom'

I

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
 
I

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.
 
J

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat rows on bottom when printing in Excel 4
INSERT 3 ROWS WHEN DATA OF COLUM CHANGED 2
Multiple Insert Copied Cells routine 2
Being able to Undo after Saving 1
please, add the feature that allows us to attach file with our thr 3
Useful Additions 1
Email a single Excel worksheet instead of the whole workbook. 2
distinct count summarize Data for pivoit table 1

Top