format all excel worksheets the same orientation, size

[Guest]

I am creating schedules and have the whole month in one document, each week
has its own tab. I want to have all the formatting the same.(i.e. all in
landscape with equal margins, print size 70%, showing gridlines) I know how
to do each of these tasks, but not on the Whole excel document for the whole
month.
When I open print preview, I have to change every single sheet and there
are LOTS of them. Can anyone help with this?

 

[Guest]

Select the first tab, hold down the shift key then click the last one. Then
go into Page Setup. Any changes you make will be made on all tabs.

 

[Guest]

Thank you very much. That is exactly what I wanted.
Lynn