Default Margin Settings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChrisR - 17 Mar 2005 17:28 GMT

Does anyone know how to change the default margin settings in Excel (2000)
so that they are not 1"x1"x.75"x.75" ? Would like them to be .25" square by
default each time I open Excel.

Thought it would be in the Tools...Options somewhere, but no luck. Am I
missing something?

c-

Reply to this Message

Paul B - 17 Mar 2005 20:09 GMT

Chris,
Set up a workbook as you want it (margins, number of sheets, cell formats,
headers, footers, gridlines to print, etc). Now Save As, and change the file
type to "Excel Template (.xlt)" not (.xls).
Locate your XLStart folder, typically somewhere like "C:\Program
Files\Microsoft Office\Office\XLStart\", and save the file as book. Excel
will add the .xlt for you

Every time you open a new workbook from now on (you may have to restart
Excel first) this template will be used. To revert back to the original,
just delete this file.

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Does anyone know how to change the default margin settings in Excel (2000)
> so that they are not 1"x1"x.75"x.75" ? Would like them to be .25" square
[quoted text clipped - 5 lines]
>
> c-

Reply to this Message

ChrisR - 17 Mar 2005 21:22 GMT

Thanks Paul.

Also thought of another way while I was waiting for a response. I wrote a
quick marco to set the margins as desired and then put the code as part of
my auto-open macro. That way it happens automagically and I can also use
the macro to apply the margins to existing files with 1 click ease. Not
sure which way I will go, depends on if I want other options changed (like
sheet count, fonts, etc) that would be easier your way.

Thanks again for the quick response.

c-

> Chris,
> Set up a workbook as you want it (margins, number of sheets, cell formats,
[quoted text clipped - 16 lines]
> >
> > c-

Reply to this Message

Paul Cundle - 17 Mar 2005 22:55 GMT

I'm not sure, but I think if you add new sheets to a book then they will
adopt the original default margins, which probably isn't what you want. If
I'm right, it should work if you save the file again but only the current
worksheet, and call it "sheet.xlt". Book.xlt is used as the template for
each new book created, and Sheet.xlt is used as the template for each new
sheet added to a book.

Paul C,

Signature

> Chris,
> Set up a workbook as you want it (margins, number of sheets, cell
[quoted text clipped - 17 lines]
>>
>> c-

Reply to this Message