ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I format part of a text cell, but not the whole thing? (https://www.excelbanter.com/excel-discussion-misc-queries/193659-how-do-i-format-part-text-cell-but-not-whole-thing.html)

Nicole

How do I format part of a text cell, but not the whole thing?
 
I want to either italic or underline, or superscript part of the textbox, but
not the whole thing. How do I do this?

For example, I want "this is: an example" to have italics on 'this is' but
not on 'an example'. Left clicking does not have format cells as an option
when I have selected part of the text in the cell. However, it is an option
if I have simply selected the entire cell.

Also, is there a way to do a hard return within a single cell of text for
excel? This question would be less useful for me than the first.

Thanks so much in advance!

RagDyeR

How do I format part of a text cell, but not the whole thing?
 
Select the cell, then, *In The Formula Bar*, select the portion you want to
format.

Then right click in that selection, and choose "Format Cells",
And "do your thing".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nicole" wrote in message
...
I want to either italic or underline, or superscript part of the textbox,
but
not the whole thing. How do I do this?

For example, I want "this is: an example" to have italics on 'this is' but
not on 'an example'. Left clicking does not have format cells as an option
when I have selected part of the text in the cell. However, it is an
option
if I have simply selected the entire cell.

Also, is there a way to do a hard return within a single cell of text for
excel? This question would be less useful for me than the first.

Thanks so much in advance!




Mike Rogers[_2_]

How do I format part of a text cell, but not the whole thing?
 
Nicole

And to add a Hard Return within a cellm, while holding "alt" touch "enter"

Mike Rogers

"Nicole" wrote:

I want to either italic or underline, or superscript part of the textbox, but
not the whole thing. How do I do this?

For example, I want "this is: an example" to have italics on 'this is' but
not on 'an example'. Left clicking does not have format cells as an option
when I have selected part of the text in the cell. However, it is an option
if I have simply selected the entire cell.

Also, is there a way to do a hard return within a single cell of text for
excel? This question would be less useful for me than the first.

Thanks so much in advance!



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com