Workbook page numbering

trishtomorrow

New Member
Joined
May 19, 2002
Messages
21
I have mulitple worksheets in a workbook and I want the page numbering in each worksheet to number continuously from the last sheet. Also, I want the first sheet to start numbering at 265 and would like to include leading zero characters (if possible and easy). I have played with the new page number option, grouping the worksheets when I set options, to no avail.

Suggestions? Thanks in advance.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Hi,
if you put
&[Page]+265
as the footer, then when you group all the sheets and do a print preview this should show it.

Mike
 
Upvote 0
Got stuck in the fact that preview does not show accurate page numbers...didn't want to waste the paper and finally did just to check...could have had preview feature reflect this and wouldn't have posted...sorry.
 
Upvote 0

Forum statistics

Threads
1,214,653
Messages
6,120,750
Members
448,989
Latest member
mariah3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top