I want to change margin default to zero for all new documents.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Miki Merritt - 01 Nov 2006 02:43 GMT

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

Reply to this Message

David McRitchie - 01 Nov 2006 11:57 GMT

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

> 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

Reply to this Message