Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2006

Tip: Looking for answers? Try searching our database.

Is it possible to highlight text?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Boe - 06 Feb 2006 08:33 GMT
I'd like to highlight just some of the text in a cell - not the entire
thing.

Thanks
Pete_UK - 06 Feb 2006 08:44 GMT
Select the cell and in the edit bar you can then select (highlight)
some of the text with the mouse and format how you wish, eg bold,
different colour, different background colour, different font/font size
etc.

Hope this helps.

Pete
Don Guillett - 06 Feb 2006 14:19 GMT
This will NOT work in a formula. Works only if all text.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Select the cell and in the edit bar you can then select (highlight)
> some of the text with the mouse and format how you wish, eg bold,
[quoted text clipped - 4 lines]
>
> Pete
Boe - 06 Feb 2006 15:45 GMT
Thanks

> This will NOT work in a formula. Works only if all text.
>
[quoted text clipped - 6 lines]
>>
>> Pete
Boe - 06 Feb 2006 15:44 GMT
Thank you

> Select the cell and in the edit bar you can then select (highlight)
> some of the text with the mouse and format how you wish, eg bold,
[quoted text clipped - 4 lines]
>
> Pete
Boe - 06 Feb 2006 15:48 GMT
I know that it may be smacking me in the face but I don't see an option for
highlight - I am running Excel 2003 - I do see the cell fill and bold and
underline but nothing for text highlight.
> I'd like to highlight just some of the text in a cell - not the entire
> thing.
>
> Thanks
Pete_UK - 06 Feb 2006 16:37 GMT
You can click anywhere in the edit bar and the cursor will be placed at
that point. Then you can hold the mouse button down while moving the
cursor, or you can hold <SHIFT> down while pressing the <arrow> keys
(more precise). Once you have higlighted the text you want in this way,
just click on the formatting features you wish (colour, bold etc).

Hope this helps.

Pete
Boe - 06 Feb 2006 17:11 GMT
Ahh - I see why my question is not clear.  I want to format text as
HIGHLIGHTED - like the markers you used in college to bring attention to a
particular sentence or term.

> You can click anywhere in the edit bar and the cursor will be placed at
> that point. Then you can hold the mouse button down while moving the
[quoted text clipped - 5 lines]
>
> Pete
Pete_UK - 06 Feb 2006 17:20 GMT
Well, you want something like a pale yellow or pale green background
colour. Select your portion of the text as described above, then select
the background colour you want for this part of the text. You might
want to set the foreground as bold to stand out more.

Pete
Boe - 09 Feb 2006 07:39 GMT
How do I select the background color for that portion of the text?

> Well, you want something like a pale yellow or pale green background
> colour. Select your portion of the text as described above, then select
> the background colour you want for this part of the text. You might
> want to set the foreground as bold to stand out more.
>
> Pete
Pete_UK - 09 Feb 2006 11:35 GMT
I've just tried to do it and discovered that Excel will not allow you
to change the background colour for a portion of the text - sorry for
misleading you. You can, however, change foreground colour and
bold/italic/underline effects etc, so you will have to emphasise your
partial text this way.

Hope this helps.

Pete
Boe - 10 Feb 2006 01:56 GMT
At least I know why I was having such a hard time figuring out how to do it.

> I've just tried to do it and discovered that Excel will not allow you
> to change the background colour for a portion of the text - sorry for
[quoted text clipped - 5 lines]
>
> Pete
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.