Results 1 to 6 of 6
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Styles al la Word (XL XP)

    I use styles a lot in word - really love them, mainly the ability to change one of the styles and have it auto update all occurances of that style in the document. I've started to use styles in excel and have found that it doesn't work like it does in word.

    I've set up a whole bunch of cells with a BORDER style and now I want to change the color of these cell. I changed the color of the border style but it didn't update all the BORDER cells - am I missing something?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Styles al la Word (XL XP)

    Are you sure you have them all defined with that style?

    If you set the cell to a style and then explicitly change some of the formatting, it will not be "updated" when the style is changed. The other formatting will, but the ones that were manually changed after the style will remain.

    Steve

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

    Re: Styles al la Word (XL XP)

    As Steve indicates, modifying a style will not remove manual formatting. You can select a bunch of cells and select the style. Excel will ask if you want to update the style or apply it. Select the latter.

  4. #4
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Styles al la Word (XL XP)

    You were right - it seems that some other style related items on those cells were changes somewhere and they 'lost' their style link. I've reconnected that now and changing the styles does flow through to those cells.

    Thanks for the replies.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  5. #5
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Cherrybrook, New South Wales, Australia
    Posts
    116
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Styles al la Word (XL XP)

    Hi Ruff-Hi,
    Are you aware that you can have up to 6 styles applied to any given cell? - one each for Number, Font, Alignment, Border, Pattern and Protection.

    For example, in a budget spreadsheet I have I define several currency styles which use different decimal places, paid/estimates styles that use different fonts and urgent/non-urgent styles that use different background patterns.

    Regards,

  6. #6
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Styles al la Word (XL XP)

    I knew there were 6 different 'things' that styles could control but I didn't know I could load up with 6 styles (assuming that those styles only cover 1 unique 'thing') - good point.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

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