View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vandy
 
Posts: n/a
Default How do I continuously number pages for the entire workbook?

Hi,

I used this option and found what i was looking for but I still have a
problem. I am trying to select all my 3 worksheets and numbering the first on
as 2. I want my first page to start from 2 everything is fine till it reaches
the last page were it becomes 10 of 9 can anyone help me with this.
thanks in advance.


"JMB" wrote:

Put a custom footer in that looks like this:

&[Page] Of &[Pages]

then right click on one of your worksheet tabs, select "select all sheets"
and print (or print preview to verify this is what you want, without wasting
paper).



"Pattie" wrote:

I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.