Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 45
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert excel document to word document (not a picture) frendabrenda1 Excel Discussion (Misc queries) 2 October 6th 06 03:55 PM
How to create a formatted 'readable' document based on Excel document? [email protected] Excel Discussion (Misc queries) 0 June 23rd 06 06:09 PM
how do i rotate a document or print small document on envelope crystal New Users to Excel 2 March 23rd 06 03:52 PM
Changing a Word Document to a CSV Formated Document Team1 New Users to Excel 3 February 6th 06 11:29 PM
Connect document properties to headers and footers Jeroen Excel Discussion (Misc queries) 1 October 31st 05 09:19 AM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"