Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dixielady
 
Posts: n/a
Default How do I get selected text within a cell to remain bold in excel?

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Hans Knudsen
 
Posts: n/a
Default How do I get selected text within a cell to remain bold in excel?

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 ...
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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
bgeier
 
Posts: n/a
Default How do I get selected text within a cell to remain bold in excel?


I have never seen this before, however, Hans seems to have hit the nail
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 then
tried to bold the some of the values (and a word in the text), and
Excel rejected the change.

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


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546117

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel solver should allow "equal to" value to be a selected cell. Brantlee Excel Worksheet Functions 1 May 19th 06 07:49 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. PboB Excel Discussion (Misc queries) 3 March 16th 05 06:17 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"