| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
text boxes and superscripts
What is the difference between using a superscript and putting something in a
text box? Is there any reason to do one vs the other? Thanks. |
|
#2
|
|||
|
|||
|
Hi, Curious. I don't even see them as being related. If you want to write
water as H2O, then you superscript the 2 to make it rise and be smaller than the other two characters. You put something in a textbox because there's no other way to place it where you need it due to other constraints like margins or orientation of text. There's many other reasons, of course, but I'm not sure what they mean to you. I'm not sure what prompts your question. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "curious" wrote in message ... What is the difference between using a superscript and putting something in a text box? Is there any reason to do one vs the other? Thanks. |
|
#3
|
|||
|
|||
|
"curious" wrote: What is the difference between using a superscript and putting something in a text box? Is there any reason to do one vs the other? Thanks. I have a series of number in the upper left of a row of excel cells. I wanted to use the fill function for the rest of the cell but not the number, and was trying to figure out if I put the numbers in as a superscript or in a text box if this would work (i.e if the number would be protected from changing.) |
|
#4
|
|||
|
|||
|
A textbox or superscript has nothing to do with what you want. If you want
to copy, for instance, 22 55 66 99 down so that they repeat every 4 cells, then the easiest method is to put the first values in (in this case a1, a2, a3, and a4), and then use formulas to repeat them. In a5 put =a1, in a6 put =a2, and so on. When you're done select all the cells that contain the formulas, and copy them. Then, without moving your cursor, hit Edit-Paste Special, Values, OK. That gets rid of the underlying formulas. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "curious" wrote in message ... "curious" wrote: What is the difference between using a superscript and putting something in a text box? Is there any reason to do one vs the other? Thanks. I have a series of number in the upper left of a row of excel cells. I wanted to use the fill function for the rest of the cell but not the number, and was trying to figure out if I put the numbers in as a superscript or in a text box if this would work (i.e if the number would be protected from changing.) |
|
#5
|
|||
|
|||
|
Anne
Niggly point.........the 2 in H20 would be in SUBscript if you follow convention. Gord Dibben Excel MVP On Sun, 3 Jul 2005 17:29:29 -0400, "Anne Troy" wrote: Hi, Curious. I don't even see them as being related. If you want to write water as H2O, then you superscript the 2 to make it rise and be smaller than the other two characters. You put something in a textbox because there's no other way to place it where you need it due to other constraints like margins or orientation of text. There's many other reasons, of course, but I'm not sure what they mean to you. I'm not sure what prompts your question. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "curious" wrote in message ... What is the difference between using a superscript and putting something in a text box? Is there any reason to do one vs the other? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
