Page Numbering Management

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Example: If you have a 6 page spreadsheet
Is there a way to change the order of page numbering. For instance, pages 1 to 4 will be numbered 1 to 4 (that's the easy part). Problem is: Pages 5 and 6 will have to be numbered 1 and 2
Is that possible, changing the order of page numbering?
 
Ben

Excel has a setting in page setup. (file>page setup>page>first page number),
set this with a number, eg 5 and it will start with a page number of 5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Ben said:
Example: If you have a 6 page spreadsheet.
Is there a way to change the order of page numbering. For instance, pages
Click to expand...
1 to 4 will be numbered 1 to 4 (that's the easy part). Problem is: Pages 5
and 6 will have to be numbered 1 and 2.
 
Nick,

Thanks for your reply, but it doesn't solve my problem.

That's good if you want the first page to start as a number other then 1.

But in my case, I need page 5 to start as number 1.

Regards
Ben W

----- Nick Hodge wrote: -----

Ben

Excel has a setting in page setup. (file>page setup>page>first page number),
set this with a number, eg 5 and it will start with a page number of 5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Ben said:
Example: If you have a 6 page spreadsheet.
Is there a way to change the order of page numbering. For instance, pages
Click to expand...
1 to 4 will be numbered 1 to 4 (that's the easy part). Problem is: Pages 5
and 6 will have to be numbered 1 and 2.
 
You could print in 2 steps and use Nick's suggestion *after* you've printed
the first 4 pages.
When you go to print pages 5 and 6, change page 5 to page 1 and 6 will
automatically follow as page 2.

HTH,

RD
 
Back
Top