| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| start page numbering from page 2 in excel | Excel Discussion (Misc queries) | |||
| Change page numbering | Excel Discussion (Misc queries) | |||
| page numbering | Excel Discussion (Misc queries) | |||
| Format page numbering to be Page 1 of X | Excel Discussion (Misc queries) | |||
| Page Numbering | Charts and Charting in Excel | |||
Linear Mode
