Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we set page margins for the entire workbook?
using excel 2003. I have multiple sheets. I want to set the page margins - is
there a way that I can set the page margins for the entire workbook, so that while printing I don't have to set the margin for each sheet individually? thanks1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we set page margins for the entire workbook?
Lots of print settings can be set if you group the worksheets first.
Select the first worksheet tab. Then ctrl-click on subsequent worksheet tabs. Then do your page setup stuff. This may change more than you want, so test the results. And after you're done, ungroup the worksheets. Rightclick on one of the selected worksheet tabs and select "ungroup sheets". Otherwise, you could be making changes to each of the grouped worksheets for things you don't want! employer wrote: using excel 2003. I have multiple sheets. I want to set the page margins - is there a way that I can set the page margins for the entire workbook, so that while printing I don't have to set the margin for each sheet individually? thanks1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different Margins for 2nd page? | Excel Discussion (Misc queries) | |||
How to apply page number continous for entire workbook | Excel Discussion (Misc queries) | |||
Page Margins | Excel Discussion (Misc queries) | |||
Page Margins | Excel Discussion (Misc queries) | |||
Copy page format into an entire workbook | Excel Worksheet Functions |