Function buttons or shortcuts

[ctimmons]

I would like to be able to use superscripts and subscripts and also to allow
the text in a cell to wrap, but it is ponderous to go into the Format Cells
box, but I can't find how to put a button for those functions onto my toolbar
for ready access like many other functions. Does anyone know how to put
those functions on the toolbar, or else use a shortcut key to make the
process simpler?

 

[ckane]

I am not sure about the superscript and subscript.

The wrap text command can be put into the toolbar:

View Menu
toolbars
choose customize
click on commands at the top
scroll all the way down on the right hand box
click on wrap text and drag it to the toolbar

I did not see anything for the other 2.

 

[Gord Dibben]

Sub Wrap_Text()
With Selection
.WrapText = Not .WrapText
End With
End Sub

Assign to a button on your toolbar.

For the sub and superscripting download John Walkenbach's Supersub add-in.

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


Gord Dibben MS Excel MVP

 

[Gord Dibben]

ckane

Which version of Excel are you running?

I have never seen a Wrap Text icon in any version prior to 2007


Gord Dibben MS Excel MVP