ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you set footers to appear at end of document? (https://www.excelbanter.com/excel-discussion-misc-queries/167818-how-do-you-set-footers-appear-end-document.html)

Roxy[_2_]

How do you set footers to appear at end of document?
 
I am trying to place a statement at the end of every proposal I create in
Excel. When creating a footer in Excel it only allows it to be placed at the
end of every page. Is it possible for me to change this setting?

Dave Peterson

How do you set footers to appear at end of document?
 
Maybe you can use a macro that prints all the pages but the last without the
footer.

Then changes the footer and prints just the last page.

You could start with Ron de Bruin's code:
http://www.rondebruin.nl/print.htm#not

Roxy wrote:

I am trying to place a statement at the end of every proposal I create in
Excel. When creating a footer in Excel it only allows it to be placed at the
end of every page. Is it possible for me to change this setting?


--

Dave Peterson

Roxy

How do you set footers to appear at end of document?
 
Thank you so much for the tip. I messed with this for awhile today and was
beginning to get very frustrated!

"Dave Peterson" wrote:

Maybe you can use a macro that prints all the pages but the last without the
footer.

Then changes the footer and prints just the last page.

You could start with Ron de Bruin's code:
http://www.rondebruin.nl/print.htm#not

Roxy wrote:

I am trying to place a statement at the end of every proposal I create in
Excel. When creating a footer in Excel it only allows it to be placed at the
end of every page. Is it possible for me to change this setting?


--

Dave Peterson



All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com