Free Microsoft Excel 2013 Quick Reference

Superscript & subscript

Hello

I would like to ask how I can use Superscript & subscript when I write math functions in excel. Is there some shortcut for this as i write the formula?

Thanks


Post your answer or comment

comments powered by Disqus
Using Excel 2004 for MAC OS X, I don't find a a toolbar button for
superscript and subscript under the Tools / Customize, like Excel for
Windows has?

Is there another way to get a "shortcut" to toggle the font to and from
super/subscript?

Thanks.

Using Excel 2004 for MAC OS X, I don't find a a toolbar button for
superscript and subscript under the Tools / Customize, like Excel for
Windows has?

Is there another way to get a "shortcut" to toggle the font to and from
super/subscript?

Thanks.

Hi,

I have a large worksheet of information that I'm using to mail merge data into a document. My problem is it contains both superscript and subscript and as the worksheet is linked to a series of other tables it loses its formatting for the mail merge.

I have a slight work around it but it it very labour intensive so need help.... Firstly I've put anything I want superscript within {} brackets and anything I want subscript in [] brackets. I then am copying thesheet into a separate one (paste values) and then running the macro below that I found on the internet on each cell.

My problem is this works but the macro only works on the current active cell. The mail merge table is around 200 by 400 so that makes the whole thing very time consuming and wondered how I could alter the code to to loop through the active cells.

Thanks for you help!

Sub Super_Sub()

Dim NumSub
Dim NumSuper
Dim SubL
Dim SubR
Dim SuperL
Dim SuperR
Dim CheckSub
Dim CounterSub
Dim CheckSuper
Dim CounterSuper
Dim Cell
'
CheckSub = True
CounterSub = 0
CheckSuper = True
CounterSuper = 0
Cell = ActiveCell
'
NumSub = Len(Cell) - Len(Application.WorksheetFunction.Substitute(Cell, "[", ""))
NumSuper = Len(Cell) - Len(Application.WorksheetFunction.Substitute(Cell, "{", ""))
'
If Len(Cell) = 0 Then Exit Sub
If IsError(Application.Find("[", ActiveCell, 1)) = False Then
Do
    Do While CounterSub <= 1000
        SubL = Application.Find("[", ActiveCell, 1)
        SubR = Application.Find("]", ActiveCell, 1)
        ActiveCell.Characters(SubL, 1).Delete
        ActiveCell.Characters(SubR - 1, 1).Delete
        ActiveCell.Characters(SubL, SubR - SubL - 1).Font.Subscript = True
        CounterSub = CounterSub + 1
        If CounterSub = NumSub Then
            CheckSub = False
            Exit Do
        End If
    Loop
Loop Until CheckSub = False
End If
'
'
If IsError(Application.Find("{", ActiveCell, 1)) = False Then
Do
    Do While CounterSuper <= 1000
        SuperL = Application.Find("{", ActiveCell, 1)
        SuperR = Application.Find("}", ActiveCell, 1)
        ActiveCell.Characters(SuperL, 1).Delete
        ActiveCell.Characters(SuperR - 1, 1).Delete
        ActiveCell.Characters(SuperL, SuperR - SuperL - 1).Font.superscript = True
        CounterSuper = CounterSuper + 1
        If CounterSuper = NumSuper Then
            CheckSuper = False
            Exit Do
        End If
    Loop
Loop Until CheckSuper = False
End If
'
End Sub


Greetings,

I have developed data entry forms and am now looking at proper labelling for data units. One unit of measure is cubic metre. In my form labels, I have had to resort to the caption (m^3) as I can not insert a superscript character in the caption.

Is it possible to use superscript characters in label captions?

I have tried (unsuccessfully) formatting the caption on initialisation using:

	VB:
	
 Me.Label.Caption 
    .Character(4,1).Font.Superscript = True 
End With 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


In the past I could add superscript/subscript buttons to the formatting
toolbar through the customize toolbar command. The button was available by
right clicking on toolbar, click customise, select command tab, select
formatting - the button was here with bol, underline etc...
Since installing Excel 2002 I cannot find the button under any heading on
the command tab. Does anyone know a way to add the button?

Also see Custom Formats | Convert a Numeric Value into English Words | Convert a Currency or Value into English Words

One of the most important things to do in Excel is to keep numbers as numbers and text as text. Sadly, many end up mixing the 2 and find it hard or impossible to do further downstream calculations on their numbers as they have either formatted the cell as Text or mixed text and numbers in the same cells. See Excel Best Practice for more common mistakes.

Using Excel's Custom Formats we eliminate the need to format numeric cells as Text and mix text and numbers in the same cell. For example, suppose you need to show Meters2 in certain cells. This is quite easy to do with a custom number format.

Select any empty cell and go Insert>Symbol and insert the symbol required. Superscript 2 in this example.

Now, with the cell containing the symbol selected, click in the Formula Bar, highlight the symbol and copy (Ctrl+c)

Now select the range that should show Meters2 after their entered numbers and go Format>Cells - Custom.

Use either General "Meters˛";-General "Meters˛" or 0.00 "Meters˛";-0.00 "Meters˛" or another variation by pasting in the symbol (Ctrl+v).

Note the use of - in second format segment. Excel see a cells format as having four Sections. These are, from left to right Positive numbers, Negative Numbers, Zero Values and Text Values. Each of these Sections are separated by a semi colon (;). If you create a custom number format you do not have to specify all four sections. By this I mean, if you included only two sections, the first section would be used for both positive numbers and zero values, while the second section would be used for negative numbers. If you only used one section, all number types would use that one format. Text is only affected by custom formats when we use all four sections, the text would use the last section.

I'm trying to adapt some code (credit to Erik Van Geit from the Mr. Excel boards) to work automatically for all rows in a document. The purpose of the code is to concatenate all cells in the first column preserving the original formatting of each cell in the destination cell. What I'd like to have it do, is work for each row beyond the first one and use "/" as a delimiter.

I've attached a cut-down version of my document (the original is 200 colums x 16000 rows) to give an example.


	VB:
	
 
 
Sub test() 
    Call concatenate_cells_formats(Range("A1"), Range("B1:GI1")) 
End Sub 
 
Sub concatenate_cells_formats(Cell As Range, source As Range) 
     
    Dim c As Range 
    Dim i As Integer 
     
    i = 1 
     
    With Cell 
        .Value = vbNullString 
        .ClearFormats 
         
        For Each c In source 
            .Value = .Value & " " & Trim(c) 
        Next c 
         
        .Value = Trim(.Value) 
         
        For Each c In source 
            With .Characters(Start:=i, Length:=Len(Trim(c))).Font 
                .Name = c.Font.Name 
                .FontStyle = c.Font.FontStyle 
                .Size = c.Font.Size 
                .Strikethrough = c.Font.Strikethrough 
                .Superscript = c.Font.Superscript 
                .Subscript = c.Font.Subscript 
                .OutlineFont = c.Font.OutlineFont 
                .Shadow = c.Font.Shadow 
                .Underline = c.Font.Underline 
                .ColorIndex = c.Font.ColorIndex 
            End With 
            .Characters(Start:=i + Len(c), Length:=1).Font.Size = 1 
            i = i + Len(Trim(c)) + 1 
        Next c 
         
    End With 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I wish to use symbols (mainly Greek letters) and superscripts, subscripts in user forms, however they do not appear correctly. For example, "delta" shows as a capital D. Anyone know how to make this work?

Thanks

I'd simply LOVE to enter " H2SO4 AT 1000 " Into a cell in Excel 2000.
How can it be done, short of copy/paste from Word?

TIA

Ron

I use alpha characters in excel to represent an items status as Red, Yellow,
or Green. In the format cell font window under effects, you list three
options such as Superscript, subscript, and strike through. You should add
Upper Case to for alpha character entry to UPPER CASE. Others may like a
check box to force Proper Case.

It would be nice to see this as a office 2003 patch/update.

Regards,

Joe Koss

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

I am using Excel 97 SR-2 on Windows 98. I have to do a lot of subscripting and superscripting in my Excel work. Is there a way to add a superscript and subscript shortcut to the toolbar in the same manner as in Word?

How do you make superscripts and subscripts in Excel?

I'd like to be able to add a button for superscript and subscript formatting
to the toolbar easily in Excel, like can be done in Word and Powerpoint.
Maybe there is a way built into Excel that I haven't found yet, and I assume
it can be done with Macros, but I am not familiar with them.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

How do I add subscript/superscript font to the Excel toolbar??

I would like to make some custom formats with text that has superscript such
as the 3 in m3/d or subscript as the 2 H20. There doesn't seem to be any
formating available in the formating system.

The first thing I do with a new installation of Excel is always to add
superscript and subscript buttons to the toolbar. Usually it goes something
like this: Formatting Toolbar >> Add or Remove Buttons >> Format >>
Superscript. I just got Small Business Edition 2003 for my new laptop, and
those buttons do not seem to be available!! Am I doing something wrong, or
has MS discontinued the only buttons I actually use?! Please help!

When in the cell pressing CTRL + S worked for me getting a superscript within
the cell. I haven't figured out the subscript.

"Mike B" wrote:

> I'm using Excel 2003 and I can not find the buttons for the subscripts and
> superscripts. This is very annoying as I do a lot of equations for calculus
> and physics.
>
> I know for a fact that there used to be Subscript and superscript buttons in
> previous versions of excel. Why can I not add them to the toolbars anymore?
> I am getting really sick and tired of going to format cells, then clicking on
> subscript/superscript. Please tell me there is a button for this feature...

MS word has capability to customize toolbars with shortcut buttons for
"superscript" and "subscript". This feature has never been added to Excel
for some reason. It would be really helpful for those of us in chemistry and
math related fields for writing out chemicals like CO2 and formulas like A =
pi*r^2.

Currently the only way it can done is through format cells menu item which
becomes tedious after 2 or 3 uses. Can this feature be added in soon???
With a service pack update even?

I do alot of chemistry school workin excel and each time i want to add a
subscript or superscript i have to use the format menu which is very tedious.
I also need to type alot of math formulas in excel that are not for
calculation but simply to show the steps i arrived at to perform the actual
calculation.

Is it possible to add a subscript & superscript icon to
the tool bars? I cannot find it under the "Customize"
menu.

HELP


"Jon Peltier" wrote:

> Kathryn -
>
> We all admire your resourcefulness. Thanks for sharing your approach
> with the group.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Kathryn wrote:
>
> > Thanks, Jon - although I still can't get the y axis label to cooperate and
> > allow me to format characters individually, I've added text to an inserted
> > rectangle and then rotated the text. And I'm using a text box instead of the
> > legend to let me format those entries.
> >
> > Kathryn
> >
> > "Jon Peltier" wrote:
> >
> >
> >>Kathryn -
> >>
> >>You can mix font formats in the chart title, axis titles, data labels,
> >>and text boxes. Click once to select the item, and a second time to
> >>insert the cursor and select the characters to format. (Data labels
> >>require three single clicks.) Then use the formatting buttons on the
> >>command bar, or use the format menu (or the shortcut CTRL+1) to open the
> >>Format dialog.
> >>
> >>Axis tick labels cannot be formatted individually like this. You can
> >>format an entire legend entry different from the others (two single
> >>clicks, then format), but you cannot access characters within an entry.
> >>
> >>- Jon
> >>-------
> >>Jon Peltier, Microsoft Excel MVP
> >>Peltier Technical Services
> >>Tutorials and Custom Solutions
> >>http://PeltierTech.com/
> >>_______
> >>
> >>
> >>Kathryn wrote:
> >>
> >>>Is there any way to use multiple font styles in Excel chart labels (titles of
> >>>data series, axes, etc.)? I must format graphs of results and have to use
> >>>variables in Symbol font, italics, superscript, and subscript, etc.
> >>
> >>
>
>

We all know there are built-in shortcut keys for Font.underline
[CTRL+u], .italic [CTRL+i], .bold [CTRL+b]and corresponding toolbar
buttons in Excel.
They are toggling shortcut keys which even work during typing/editing
in a cell, which is very convenient.
I've been struggling to make such shortcut keys for superscript and
subscript, without success.
Would anyone kindly tell me how?
I am currently trying to learn EXCEL 2000 VBA and ACCESS 2000 VBA.

MS word has capability to customize toolbars with shortcut buttons for
"superscript" and "subscript". This feature has never been added to Excel
for some reason. It would be really helpful for those of us in chemistry and
math related fields for writing out chemicals like CO2 and formulas like A =
pi*r^2.

Currently the only way it can done is through format cells menu item which
becomes tedious after 2 or 3 uses. Can this feature be added in soon???
With a service pack update even?

I am trying to customize my toolbars, and I can't seem to find the
superscript or subscript command. Is there a way to make the superscript and
subscript commands into a button in Excel?


No luck finding an answer? You could always try Google.