text boxes and superscripts

[Guest]

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.

 

[Anne Troy]

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

 

[Guest]

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.)

 

[Anne Troy]

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

 

[Gord Dibben]

Anne

Niggly point.........the 2 in H20 would be in SUBscript if you follow
convention.


Gord Dibben Excel MVP