Printing different worksheets on different pages

M

ModelerGirl

I am trying to set my print area to include multiple worksheets, but I'
like to put the contents of each worksheet on a separate page. When
try to do this manually in the Page setup dialog, (putting a comm
after the area in the first sheet), Excel won't let me go to the secon
sheet. I know this is a basic question, but searches on here haven'
yielded any answers.

Please help
 
D

Don Guillett

If I understand you, you must print each worksheet separately and set up the
print area for it UNLESS the print area is the same for all. Perhaps you
should copy/paste your efforts for comments.
 
C

clane

To set the print range on each sheet just go to

view - page break preview and drag the lines around to change the prin
range on each sheet

cheer
 
Top