Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
Chou
 
Posts: n/a
Default how to setup "To be continued"at each pg except the last one ?

In Excel spreed sheet, how to make setup- of "To be continued: words at the
bottom of each page except the very last one?
  #2   Report Post  
Posted to microsoft.public.excel.setup
David McRitchie
 
Posts: n/a
Default how to setup "To be continued"at each pg except the last one ?

Hi Chou,

You would have to start the printer again to print the last page without the footer.
In other words it can be done, but it is not very practical, and you would have
to do it with a macro.
Customizing the title/footer for each page by restarting the printer, so page
headings can show content pertaining to the page as printed within a worksheet.
. http://www.mvps.org/dmcritchie/excel...m#changeheader


Most people would be satisfied, I think, with Page 3 of 7
in your footer as Page # of ## using the symbols in the footer.
or if you type in Page &[Page] of &[Pages]I

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chou" wrote in message ...
In Excel spreed sheet, how to make setup- of "To be continued: words at the
bottom of each page except the very last one?



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
Excel 2003 - PAGE SETUP - FIT TO WIDTH does not work BisBatt Excel Discussion (Misc queries) 1 February 1st 06 07:00 PM
Excel; how do I print titles in 'Setup' when option greyed out? MLB Excel Worksheet Functions 0 December 28th 05 03:22 PM
In excel how do I copy page setup format from one wsht to another richardT@gale Excel Discussion (Misc queries) 1 October 3rd 05 04:16 AM
can you set the "Page Setup" margins etc. differently for each pag Tony Excel Worksheet Functions 4 February 2nd 05 01:15 PM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 03:22 PM.

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

About Us

"It's about Microsoft Excel"