Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: default margins

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how do i set default margins for all my excel files / worksheets.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-20 04:53, archana ahuja wrote:
    how do i set default margins for all my excel files / worksheets.
    Does this help you?

    With ActiveSheet.PageSetup

    .LeftMargin = Application.InchesToPoints(0.78740157480315)
    .RightMargin = Application.InchesToPoints(0.78740157480315)
    .TopMargin = Application.InchesToPoints(0.984251968503937)
    .BottomMargin = Application.InchesToPoints(0.984251968503937)
    .HeaderMargin = Application.InchesToPoints(0.511811023622047)
    .FooterMargin = Application.InchesToPoints(0.511811023622047)

    End With

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can also set the desired margins in an empty workbook and save it as a template with the name Book.xlt or Sheet.xlt in the XLStart folder in your Microsoft Excel program folder. Microsoft Excel uses these templates to create new default workbooks or to insert new worksheets when you click Worksheet on the Insert menu.

    Marc

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    86
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks this was really easy. I saved all kinds of print settings. It was bugging me how to avoid setting the print settings all the time. The only part I couldn't get to work was saving the workbook in the XLStart folder. I have one of those folders, but it's in the Office folder, I don't have a separate Excel folder. I looked it up on the help menu and it gave the exact instructions you gave. I'm not sure why my folders aren't consistent. What I ended up doing was creating a shortcut on my desktop to the BOOK.XLT, so now I'll always use that shortcut rather than the Excel shortcut. It works and is just as easy.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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