Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy page layout and margin from sheet to sheet
Hi,
I was hoping someone could help... I have 7 sheets in my workbook, all showing similar data in landscape. The page setup at first was as default. On the first sheet I have reduced the margins around the edge to make the information spread across larger on the page. I want this to apply to sheets 2-5, but not 6 and 7. Any ideas that will save me going to each sheet and amending margins and "Centre on page" options?? Many thanks. Rajen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy page layout and margin from sheet to sheet
When you 'group' worksheets, a change in Page Setup on the active sheet
affects all the grouped sheets. To group sheets press Ctrl or Shift as you click on their tabs. -- Jim "RajenRajput1" wrote in message ... | Hi, | | I was hoping someone could help... | | I have 7 sheets in my workbook, all showing similar data in landscape. | | The page setup at first was as default. | | On the first sheet I have reduced the margins around the edge to make the | information spread across larger on the page. | | I want this to apply to sheets 2-5, but not 6 and 7. | | Any ideas that will save me going to each sheet and amending margins and | "Centre on page" options?? | | Many thanks. | | Rajen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No "Sheet" tab exists on Page Layout. Need to print gridlines.??? | Excel Worksheet Functions | |||
In EXCEL copy sheet layout to another sheet | Excel Discussion (Misc queries) | |||
How do I copy Page Setups from one Sheet to Another sheet? | Excel Worksheet Functions | |||
Copy Page Setup from Sheet to Sheet? | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |