Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing margins (Excel 2000)

    I need all margins of every new spreadsheet to always be .5. I don't ever want to change the margins. How can I lock this in. If this was Word I would just go into the normal template. What do I do in Excel?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: changing margins (Excel 2000)

    Create a workbook with one worksheet and set the margins the way you want. Also adjust other settings, if you like (page header and footer, etc.)

    Save this workbook as an Excel template named Book.xlt in your XLSTART folder. Also save it as an Excel template named Sheet.xlt in the same XLSTART folder. These names are required - it won't work if you give them different names.

    The exact location of XLSTART depends on your Windows version. It may be inside a hidden folder, so you must show hidden files and folders in Windows Explorer in order to find it.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing margins (Excel 2000)

    Excellent, thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •