page setup

  • Thread starter Thread starter Mery
  • Start date Start date
M

Mery

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
 
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
 
Back
Top