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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous page numbering when printing whole book 2
Printing Sheets in a Workbook 3
Update workbook pages- how? 2
Printing multiple sheets... 1
Numbering not working 4
Add page numbers to multiple worksheets without changing page setu 2
Duplex Printing of Workbook with multiple worksheets 2
workbook page numbering 1

Back
Top