Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i superscript part of a cell in MS Excel?
When I use the superscript option after selecting just a portion of the cell,
the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. |
#2
|
|||
|
|||
Did you hit enter have you applied the format change?
And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson |
#3
|
|||
|
|||
I hit enter and it went to being "non-superscript," even though it appears as
superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson |
#4
|
|||
|
|||
What's in the cell?
What character in that string are you trying to make a superscript? What font are you using (for all the string or for that character)? What version of excel are you using? I've never had any trouble with plain old text (but that doesn't help you). allan wrote: I hit enter and it went to being "non-superscript," even though it appears as superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Thanks, againl, for your advice. I have written "Land (1)" in the cell since
I can't superscript. I would like to have something like Landa, with the "a" super script. I've tried it as part of a string and seperately, with no success. I'm using MS Excel 2003, and I'm not sure why I'm having these problems. I know I've done superscript using (format, cells, font, effects) in an earlier version of Excel I have at home. It doesn't seem to work with numbers, symbols, or letters on my particular system at work, which should be a far better system than I have at home. I'm just using plain, old, regular Arial font- nothing fancy. It's a very standard document/sheet. Again, the superscript does appear while in "edit" mode (double click, F2), but it disappears once I disengage that (enter, tab, green check). It does remember, however, that it's there because it's still superscripted each time I return to edit mode on that particular cell. I've resorted to using the (X) in the meantime. I did download and use the add-in you recommended, but it did the same thing (superscripted only in edit mode). Thanks for your help. It may just be the system I'm on, though I'm not exactly sure why. "Dave Peterson" wrote: What's in the cell? What character in that string are you trying to make a superscript? What font are you using (for all the string or for that character)? What version of excel are you using? I've never had any trouble with plain old text (but that doesn't help you). allan wrote: I hit enter and it went to being "non-superscript," even though it appears as superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Dave, sorry about all the trouble. I was using data that someone else had
sent to me and I was modifying into financial statements. I'm not sure exactly what formatting they had applied to the affected cells, but I did (edit, clear, format) and I was able to do superscripts again. Thanks so much for your help! "Dave Peterson" wrote: What's in the cell? What character in that string are you trying to make a superscript? What font are you using (for all the string or for that character)? What version of excel are you using? I've never had any trouble with plain old text (but that doesn't help you). allan wrote: I hit enter and it went to being "non-superscript," even though it appears as superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Thanks for posting back.
If you find out what they did, post back (I don't have a guess). allan wrote: Dave, sorry about all the trouble. I was using data that someone else had sent to me and I was modifying into financial statements. I'm not sure exactly what formatting they had applied to the affected cells, but I did (edit, clear, format) and I was able to do superscripts again. Thanks so much for your help! "Dave Peterson" wrote: What's in the cell? What character in that string are you trying to make a superscript? What font are you using (for all the string or for that character)? What version of excel are you using? I've never had any trouble with plain old text (but that doesn't help you). allan wrote: I hit enter and it went to being "non-superscript," even though it appears as superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
|
|||
|
|||
I don't have good enough a connection with the spreadsheet's source to find
out what they did, but I wasn't able to identify anything on my own (i.e., it wasn't a special font or anything). Sorry. "Dave Peterson" wrote: Thanks for posting back. If you find out what they did, post back (I don't have a guess). allan wrote: Dave, sorry about all the trouble. I was using data that someone else had sent to me and I was modifying into financial statements. I'm not sure exactly what formatting they had applied to the affected cells, but I did (edit, clear, format) and I was able to do superscripts again. Thanks so much for your help! "Dave Peterson" wrote: What's in the cell? What character in that string are you trying to make a superscript? What font are you using (for all the string or for that character)? What version of excel are you using? I've never had any trouble with plain old text (but that doesn't help you). allan wrote: I hit enter and it went to being "non-superscript," even though it appears as superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
|
|||
|
|||
No problem. I just chalk it up to magic. (a very big category!)
allan wrote: I don't have good enough a connection with the spreadsheet's source to find out what they did, but I wasn't able to identify anything on my own (i.e., it wasn't a special font or anything). Sorry. "Dave Peterson" wrote: Thanks for posting back. If you find out what they did, post back (I don't have a guess). allan wrote: Dave, sorry about all the trouble. I was using data that someone else had sent to me and I was modifying into financial statements. I'm not sure exactly what formatting they had applied to the affected cells, but I did (edit, clear, format) and I was able to do superscripts again. Thanks so much for your help! "Dave Peterson" wrote: What's in the cell? What character in that string are you trying to make a superscript? What font are you using (for all the string or for that character)? What version of excel are you using? I've never had any trouble with plain old text (but that doesn't help you). allan wrote: I hit enter and it went to being "non-superscript," even though it appears as superscript in the edit mode. I am trying to do this with text. The format cells window show it as being formatted with a square or circle, rather than the checkmark when I look at the particular cell. Thank you for the advice. "Dave Peterson" wrote: Did you hit enter have you applied the format change? And you can't do this kind of formatting to formulas or real numbers. It has to be text. If you do this a lot... John Walkenbach has a helpful addin that you may like: http://j-walk.com/ss/excel/files/supersub.htm allan wrote: When I use the superscript option after selecting just a portion of the cell, the superscript appears during edit mode only. How do I get it so it appears as superscript on the spreadsheet or when printing? Again, I'm only trying to superscript part of a cell's contents, not the entire cell. -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i superscript part of a cell in MS Excel? | Excel Discussion (Misc queries) | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |