how to setup "To be continued"at each pg except the last one ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel spreed sheet, how to make setup- of "To be continued: words at the
bottom of each page except the very 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/headcols.htm#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
 
Back
Top