How do I get selected text within a cell to remain bold in excel?

Discussion in 'Microsoft Excel Misc' started by Guest, May 27, 2006.

  1. Guest

    Guest Guest

    In excel 2003, when I highlight only a few words of text within a cell and
    select bold, the text reverts back to plain. The entire cell reverts back to
    whatever formatting was used first. I didn't have this problem previously
    and can't figure out how to get only the selected text to stay bold. This
    happens in most, but not all cells. A few cells allow me to highlight only
    selected text.
     
    Guest, May 27, 2006
    #1
    1. Advertisements

  2. Guest

    Hans Knudsen Guest

    What kind of format do you use in the cell?
    If I use for example the format _(@_) or the Accounting format then I can't bold individual characters, but using the General format
    I have no problems.

    Regards
    Hans


    "dixielady" <> skrev i en meddelelse news:...
    > In excel 2003, when I highlight only a few words of text within a cell and
    > select bold, the text reverts back to plain. The entire cell reverts back to
    > whatever formatting was used first. I didn't have this problem previously
    > and can't figure out how to get only the selected text to stay bold. This
    > happens in most, but not all cells. A few cells allow me to highlight only
    > selected text.
     
    Hans Knudsen, May 27, 2006
    #2
  3. Guest

    bgeier Guest

    I have never seen this before, however, Hans seems to have hit the nai
    on the head.

    I formatted column "E" to "Accounting" and column "F" to general
    I entered some dollar amounts and text data into Column "E", I the
    tried to bold the some of the values (and a word in the text), an
    Excel rejected the change.

    Then I copied copied column "E" to column "F" and retried th
    experiment with the same results (Excel rejected the changes)
    Next I changed the format to "General" and the values/text I ha
    changed to bold (that did not change with "Accounting") and changed t
    bold

    --
    bgeie
    -----------------------------------------------------------------------
    bgeier's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1282
    View this thread: http://www.excelforum.com/showthread.php?threadid=54611
     
    bgeier, May 27, 2006
    #3

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. bkincaid

    Join bold and non-bold text in one cell

    bkincaid, Mar 20, 2006, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    476
    Ron Rosenfeld
    Mar 21, 2006
  2. Guest
    Replies:
    0
    Views:
    158
    Guest
    Aug 21, 2006
  3. dberger16

    Font/Color/Bold/Italic Remain Same

    dberger16, Jan 21, 2009, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    159
    dberger16
    Jan 21, 2009
  4. Lerner

    Alphabetically list of names BOLD and NOT bold

    Lerner, Feb 28, 2009, in forum: Microsoft Excel Misc
    Replies:
    13
    Views:
    293
    francis
    Mar 1, 2009
  5. Scarlett50
    Replies:
    2
    Views:
    715
    Scarlett50
    Mar 26, 2010
Loading...

Share This Page