View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
YESHWANT JOSHI[_2_] YESHWANT JOSHI[_2_] is offline
external usenet poster
 
Posts: 42
Default Printing Sheets in a Workbook

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.