Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link margin size and document size to all sheets
I have an Excel 2003 workbook that contains 10 sheets. I had to change the
margins and the scaling size. Is there an easy way to apply this to all 10 sheets or do I have to format each sheet separately? Thank you in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link margin size and document size to all sheets
if you select all of the sheets, hold down shift while clicking the sheet
tabs with the mouse, then do your print setting it should apply the print settings to all of the worksheets. When you are done just right click one of the sheet tabs and select UnGroup. -- Rui "laitkens" wrote in message ... I have an Excel 2003 workbook that contains 10 sheets. I had to change the margins and the scaling size. Is there an easy way to apply this to all 10 sheets or do I have to format each sheet separately? Thank you in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Margin doesn't fit paper size ?? | Excel Discussion (Misc queries) | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
How do I reduce the file size of an Excel document? | Excel Discussion (Misc queries) | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
How do I enlarge chart size in document? | Excel Discussion (Misc queries) |