Workbook page numbering

trishtomorrow · May 20th, 2002, 08:49 AM

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.

sann0638 · May 20th, 2002, 08:55 AM

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

trishtomorrow · May 20th, 2002, 09:00 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 08:49 AM	#1
trishtomorrow New Member Join Date: May 2002 Posts: 18	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.

May 20th, 2002, 08:55 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	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

May 20th, 2002, 09:00 AM	#3
trishtomorrow New Member Join Date: May 2002 Posts: 18	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.