page setup
 

I have many sheets on my workbook,when it works finished I need all sheets
set up to the same margins , orientation -landscape and scaling 85%normal
size AT ONCE.

Any help will be valuable!
Thanks in advance!

Mery

page setup
 

You can Group all the sheets together (right-click on a sheet tab),
and then you can set up the page properties on one (including headers/
footers etc), and they will all be the same.

Don't forget to Ungroup the sheets when you have finished this part.

Hope this helps.

Pete

On Apr 15, 7:36*pm, Mery wrote:
I have many sheets on my workbook,when it works finished I need all sheets
set up to the same margins , orientation -landscape and scaling 85%normal
size AT ONCE.

Any help will be valuable!
Thanks in advance!

Mery

page setup
 

Thank's "Pete_UK" you helped me!

Korisnik "Pete_UK" napisao je:

You can Group all the sheets together (right-click on a sheet tab),
and then you can set up the page properties on one (including headers/
footers etc), and they will all be the same.

Don't forget to Ungroup the sheets when you have finished this part.

Hope this helps.

Pete

On Apr 15, 7:36 pm, Mery wrote:
I have many sheets on my workbook,when it works finished I need all sheets
set up to the same margins , orientation -landscape and scaling 85%normal
size AT ONCE.

Any help will be valuable!
Thanks in advance!

Mery

page setup
 

You're welcome - thanks for feeding back.

Pete

On Apr 16, 6:22*am, Mery wrote:
Thank's "Pete_UK" you helped me!