Formatting Palette

[Jeff]

Is it possible to customize the formatting palette?
Specifically, I am trying to put subscript and superscript
funcionality in the formatting palette, similar to what is
available in Word v.X for Mac.

 

[Gord Dibben]

Jeff

Super and Subscript Formatting is available under Format>Cells>Font.

For more precise Functionality, John Walkenbach has a downloadable add-in for
Super and Subscripting selected text.

http://www.j-walk.com/ss/excel/files/supersub.htm

Gord Dibben Excel MVP

 

[jeff]

Gord-

Thanks for the add-in suggestion. I looked at it and while
potentially useful, it is just a tedious as going to
Format>Cells>Font.
What I am wondering is if it is actually possible to put a
button for subscripts or superscripts in the Formatting
Palette Window(Toolbar)?? I didn't even see
"sub/superscripts" as an option in the customizing window.

Jeff

 

[Gord Dibben]

Jeff

You can record a macro whilst Super or Subscripting a cell or cells.

Sub Superscript()
'recorded
With Selection.Font
.Name = "Arial"
.Strikethrough = False
.Superscript = True
.Subscript = False
.OutlineFont = False
.Shadow = False
.ColorIndex = xlAutomatic
End With
End Sub

Assign to buttons on the Toolbar.

Note: your macros will not work in Edit mode so whole cell(s) only can be
done.

Gord