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.



"lkirk1" wrote:

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?

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

"Office Helper" wrote:

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.



"lkirk1" wrote:

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?