Continuous page numbers thoughout a workbook?

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

Guest

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?
 
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?
 
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?
 
Page,

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

Regards,
Kevin
 
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?
 
Back
Top