View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Are you related to Amanda?

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.

=====
If you create another file named sheet.xlt (in the same XLStart location), then
every new worksheet added will inherit the settings from this template.

I set up book.xlt the way I wanted it (one sheet only) and then used windows
explorer to copy it to sheet.xlt. Then they would be identical. (Seemed like
less work, too.)

krinneyd wrote:

I cannot seem to find where to change the default margin settings for Excel -
I can go in and change them everytime on the page setup but I do not want to
have to manually change the margins everytime. Please help!


--

Dave Peterson