ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Change Margin Defaults (https://www.excelbanter.com/setting-up-configuration-excel/5085-change-margin-defaults.html)

Amanda

Change Margin Defaults
 
Is it possible in later versions of Excel to change the Margin defaults?
Instead of 1 inch...I want to change to .5 inch.

Please advise.....thanks for your help!

Dave Peterson

So you could create a workbook that has the settings you want. Then save
this workbook as a template for all new workbooks.

If that's what you want to do:
Start a new workbook.
change the margins
(and modify it to your heart's content)

Also, modify anything else you want as a standard--header/footers, page
orientation, number of worksheets in that workbook???

Now save it as a template in your XLStart folder as book.xlt

Then when you click on that New icon, the new workbook will inherit all those
settings.

Amanda wrote:

Is it possible in later versions of Excel to change the Margin defaults?
Instead of 1 inch...I want to change to .5 inch.

Please advise.....thanks for your help!


--

Dave Peterson


All times are GMT +1. The time now is 05:31 AM.

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