P
Pattie
I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.
with page numbers. Can this be done? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JMB
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).
&[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).
P
Pattie
That's what I needed. Thank you!
JMB said: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 said:I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.
J
JMB
You're welcome.
Pattie said:That's what I needed. Thank you!
JMB said: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 said:I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.
V
vandy
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.
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 said: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 said:I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.
J
JMB
If you have a separate sheet you want as the first page that is not included
in the print job, you can shift the page numbering like this
&[Page]+1 Of &[Pages]+1
in the print job, you can shift the page numbering like this
&[Page]+1 Of &[Pages]+1
vandy said: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 said: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 said:I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.