For OP

To print 1 of 1 you will have to print each worksheet as a separate print
job.


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 09:30:01 -0700, YESHWANT JOSHI
wrote:

in my opinion redefining the print area can solve your problem.
select the area of the workshet you want to take the print, click file-print
area-set print area.

if this helps, click yes below

"Té" wrote:

I have 4 worksheets in my workbook. When I go to print and choose the entire
workbook the print preview reads page 1 of 4 (referring to the whole book).
How can I set it up where it reads page 1 of 1 on each sheet, without
printing each sheet individually. So far sheets 2-4 it reads page 1 of 1
because they are separate sheets even though they're in a workbook together.