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.

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
(E-Mail Removed)> 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.

Hi MLS,

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

HTH
Martin

"MLS at LPC" <MLS at (E-Mail Removed)> wrote in message
news:BE3D17F7-E277-4C79-97A4-(E-Mail Removed)...
>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.