ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Same Margins with Multiple Worksheets (2003) (https://www.excelbanter.com/setting-up-configuration-excel/242312-same-margins-multiple-worksheets-2003-a.html)

helen

Same Margins with Multiple Worksheets (2003)
 
I have a document with nine worksheets. I want the margins to be the same.
Is there a way to set this up without having to do so nine times?



Dave Peterson

Same Margins with Multiple Worksheets (2003)
 
For some settings, you can group the sheets you want the same and then do
File|page setup.

But not all settings can be modified this way.

And remember to ungroup the sheets when you're done!

You can group the sheets by selecting the first and ctrl-clicking on the tabs of
the subsequent sheets (or rightclick on any tab and choose "Select all sheets"
if that's what you need)

Helen wrote:

I have a document with nine worksheets. I want the margins to be the same.
Is there a way to set this up without having to do so nine times?


--

Dave Peterson


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com