| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are the "page setup" layout settings overwritten by page preview adjustments ? | Excel Discussion (Misc queries) | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
| Page Setup | Setting up and Configuration of Excel | |||
| Page Setup | Excel Discussion (Misc queries) | |||
![Mery[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
