Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to add superscript/italics to a very small portion of the words
in one single text cell, but not for the entire cell. How can i select the option to add formatting changes to one or two words from the text in the cell, without having to change it for everything in that cell? When I highlight the part of the cell I want to reformat, I won't have the option to enter into formatting. I have to select the entire cell before the option 'format cells' become available. Is there any way I could figure this out? Thanks for your help! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try it this way:
1. Highlight the portion of the cell you want to format. 2. Right click on the cell, choose Formal Cells... 3. Choose your formatting. 4. Click OK. The formatting you specify will apply only to the portion you've highlighted. Regards, Fred. "Nicole" wrote in message ... I would like to add superscript/italics to a very small portion of the words in one single text cell, but not for the entire cell. How can i select the option to add formatting changes to one or two words from the text in the cell, without having to change it for everything in that cell? When I highlight the part of the cell I want to reformat, I won't have the option to enter into formatting. I have to select the entire cell before the option 'format cells' become available. Is there any way I could figure this out? Thanks for your help! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the cell.
Click in the formula bar. Highlight the portion to change. FormatCells and do it then hit ENTER. Gord Dibben MS Excel MVP On Wed, 9 Jul 2008 06:57:01 -0700, Nicole wrote: I would like to add superscript/italics to a very small portion of the words in one single text cell, but not for the entire cell. How can i select the option to add formatting changes to one or two words from the text in the cell, without having to change it for everything in that cell? When I highlight the part of the cell I want to reformat, I won't have the option to enter into formatting. I have to select the entire cell before the option 'format cells' become available. Is there any way I could figure this out? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scrolling Partially Through a Cell | Excel Discussion (Misc queries) | |||
Is it possible to format a cell w/ 2 font sizes by formula? | Excel Worksheet Functions | |||
In Excel, how can i see all tabs in format cell - I only see font. | Excel Discussion (Misc queries) | |||
How to sent for cell: font size=7,text format in VBA | Excel Discussion (Misc queries) | |||
Partially protect a cell? | Excel Worksheet Functions |