change page numbering 1st & last
 

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.

change page numbering 1st & last
 

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
wrote:

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.

change page numbering 1st & last
 

Hi MLS,

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

HTH
Martin

"MLS at LPC" <MLS at wrote in message
...
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.