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.
|