Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Worksheet format (2000 SR-0)

    Is there any way to set up default format/settings for new worksheets created within spreadsheets?

    I don't like Gridlines, so I've put a blank worksheet which doesn't show Gridlines in the XLstart folder, so that new spreadsheets are without Gridlines by default. However, new worksheets created within a new spreadsheet DON'T have the Gridlines turned off. Is there any way of doing this, please

    Is there a general principle for setting particular default formats for new worksheets?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Default Worksheet format (2000 SR-0)

    Yep, see this thread starting at Legare's <!post=Post 89660,89660>Post 89660<!/post>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Worksheet format (2000 SR-0)

    Thanks!

  4. #4
    Star Lounger
    Join Date
    Apr 2001
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Worksheet format (2000 SR-0)

    Stupid question, maybe, but: apart from WOPR, and I guess the Office Resource kit, etc - where does one find out about this kind of functionality which half the time seems so buried or unpublished by Microsoft?

    Half the time it seems manuals are just reprints of screen shots which I don't need to look in a book for - I can look at the screen! and they DON'T give you this kind of detail

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Worksheet format (2000 SR-0)

    I learnt things like that by reading (many!) posts and answering them later on <g> at:

    http://go.CompuServe.com/MSOfficeForum?Loc=US

    and the MS newsgroups of course.

    Later on I found this forum, which is quite good too.

    Of course you could buy a book on XL....
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Default Worksheet format (2000 SR-0)

    In XL97 Help, "workbooks, defaults" gets you to "Customize the defaults for a workbook or worksheet by using a template". I find that most of what I need is in Help, -PROVIDED- I know what to look for, and sometimes knowing what to search for is the challenge!
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Star Lounger
    Join Date
    Apr 2001
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks [no msg body]

    <P ID="nt"><font size=-1>(No Text)</font>

Posting Permissions

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