ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   I want to change margin default to zero for all new documents. (https://www.excelbanter.com/setting-up-configuration-excel/116983-i-want-change-margin-default-zero-all-new-documents.html)

Miki Merritt

I want to change margin default to zero for all new documents.
 
I want to have all margins set to zero as the default. Is there a way to
change the default for this? I manually have to do it each for each new
document.

Thanks

David McRitchie

I want to change margin default to zero for all new documents.
 
Hi Miki,
You want to change the sheet1, Sheet2, and Sheet3 in your BOOK.xlt
template, and sheet in your SHEET.xlt template.

The Book template is used when adding new workbooks, the Sheet
tempate is used when adding a new sheet.

Templates, book.xlt, sheet.xlt, and beyond
http://www.mvps.org/dmcritchie/excel/template.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Miki Merritt" <Miki wrote in message ...
I want to have all margins set to zero as the default. Is there a way to
change the default for this? I manually have to do it each for each new
document.

Thanks





All times are GMT +1. The time now is 08:23 PM.

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