Hi Michelle,
You can group the sheets then any change you make to the active sheet will be done
to all of the sheets in the grouping. That applies to entry into cells as well as page setup.

To group some sheets, Ctrl+Click on additional sheet tabs.
To group ALL sheets, Right click on a sheet tab, Select all sheets.
You might notice the text added to your title bar [Group]
and now you are aware of it , you should be very carefult..

do your file, page setup, General Tab, change the paper size.

Now for the most IMPORTANT part. Ungroup your sheets.
-- right click on a sheet tab, Ungroup Sheets.

Failure to ungroup sheets will result in major damage to your Excel workbook, as any
change made to one sheet in the group will be made to all grouped sheets.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Michelle - BR" <Michelle - wrote in message
...
How do I set Excel pages to automatically reduce documants to print on letter
size paper. Page set up allows me to do it for individual worksheets, but I
need to have it done for all worksheets.