Help with Print Formatiing

[RONT]

I have a workbook that contains a sheet for each day of the year. Each morning a report is generated and emailed to a group list with the corresponding days spreadsheet. Is there a way to format the enitre workbook so that each daily sheet will print "fit to 1 page"

 

[cherria]

Select all the tabs (right click on one worksheet tab) and click select all.

Then go to file->page setup and select fit to 1 page

click okay, right click a tab again and select ungroup

 

[RONT]

Thanks for help. Sometimes I out think myself!!