View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Té is offline
external usenet poster
 
Posts: 75
Default Printing Sheets in a Workbook

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.