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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Unique last page footer 1
Excel - Problem w/ printing more than one worksheet with same sett 0
Changing a Excel doc's layout 2
Continuing Headers 2
How to make a address label ? 1
Rotate Footer text? 0
printing with out data 2
using the =page! feature to transpose a row to column 0

Back
Top