Prev: How to combine data based on two fields..
Next: sorting
From: itrymybest on 4 May 2010 14:41
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
From: Bob I on 4 May 2010 14:50
Put the info in a Footer perhaps

itrymybest wrote:

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

From: Bob Umlas, Excel MVP on 4 May 2010 15:22
Could you not put the information in the footer?

"itrymybest" wrote:

> 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
From: itrymybest on 4 May 2010 16:37
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.

"Bob I" wrote:

> Put the info in a Footer perhaps
>
> itrymybest wrote:
>
> > 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.
>
> .
>
From: Gord Dibben on 5 May 2010 18:50
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

On Tue, 4 May 2010 13:37:01 -0700, itrymybest
<itrymybest(a)discussions.microsoft.com> wrote:

>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.
>
>"Bob I" wrote:
>
>> Put the info in a Footer perhaps
>>
>> itrymybest wrote:
>>
>> > 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.
>>
>> .
>>

 | 
Pages: 1
Prev: How to combine data based on two fields..
Next: sorting