change page numbering 1st & last

[Guest]

I have a 4 page .xls worksheet. Since I will be adding a coversheet before
faxing the worksheet to others, I want to change the footer from Page 1 of 4
to page 2 of 5. I know how to use Page Setup to change the start number, but
need to know how to change the last page number.

 

[Gord Dibben]

See Ron de Bruin's site for code to prevent printing the footer on first page.

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 12:50:01 -0700, MLS at LPC <MLS at

 

[MartinW]

Hi MLS,

Try a custom footer like this
&[Page]+1 of &[Pages]+1

HTH
Martin