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?

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?