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

C

Chou

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

David McRitchie

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
 

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

Section and Page numbering 0
Two columns : Continuous two columns vs Parallel two Column 1
Grouping Names in Mail Merge 0
Margin from bottom edge of a page to the last line of the last paragraph 1
Style Gallery View 3
Excel --> Word 4
Footnote references on one page, footnote text on the next 5
How can the font and size of (all) citation numbers be altered? 1

Top