Select one sheet
Right click on its sheet tab
Choose: Select all sheets
Use page set up as usual
Caveat: while at this mode ("Group") anything you do in one worksheet will
also reflect in others.
To ungroup: right click again on the sheet tab and then choose ungroup
sheet
"astrange" wrote in
message ...
I am sure there is an easy answer to this but I am not seeing it.
1. I have an .xls file with 30 worksheets in it.
2. Each worksheet is the same layout with different data linked in
from other spreadsheets.
3. Each worksheet is formatted to allow me to print out reports.
4. However, I recently made a change to the layout which requires a
change in my margin settings.
5. I started going through each worksheet and changing the margins one
by one. After about 5 times I was convinced I was being silly.
??? Is there a way to apply the same margins to every worksheet in an
xls file without changing each one individually.
Thanks,
Jason
--
astrange
------------------------------------------------------------------------
astrange's Profile:
http://www.excelforum.com/member.php...o&userid=32275
View this thread: http://www.excelforum.com/showthread...hreadid=566908