Continuous page numbers thoughout a workbook?

P

pagenumbers

Does anyone know if you can set up a workbook to print with continuous page numbers without going into each sheet and changing the beginning page number?
 
K

Kevin Stecyk

Page,

Edit | Page Setup | Headers and Footers.....create a header or footer.

Click the custom header or footer. It is much like MS Word.

HTH

Regards,
Kevin


pagenumbers said:
Does anyone know if you can set up a workbook to print with continuous
Click to expand...
page numbers without going into each sheet and changing the beginning page
number?
 
R

Ron de Bruin

Hi

Right click on a sheet tab and choose select all sheets
press the Print button
Right click on a sheet tab and choose ungroup


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




pagenumbers said:
Does anyone know if you can set up a workbook to print with continuous page numbers without going into each sheet and changing
Click to expand...
the beginning page number?
 
K

Kevin Stecyk

Page,

Use Ron's solution. My solution was for an individual sheet, not a
workbook. Ooops.

Regards,
Kevin
 
E

Earl Kiosterud

Page,

If you mean that you're printing multiple sheets, and want one set of
consecutive page numbers for the whole deal, make sure the "First page
number" is set to "Auto" in Page Setup - Page,

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

pagenumbers said:
Does anyone know if you can set up a workbook to print with continuous
Click to expand...
page numbers without going into each sheet and changing the beginning page
number?
 
Top