Function buttons or shortcuts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ctimmons - 22 May 2008 17:50 GMT

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?

Signature

ctimmons

Reply to this Message

ckane - 22 May 2008 19:17 GMT

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.

> 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?

Reply to this Message

Gord Dibben - 23 May 2008 01:45 GMT

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

>I am not sure about the superscript and subscript.
>
[quoted text clipped - 15 lines]
>> those functions on the toolbar, or else use a shortcut key to make the
>> process simpler?

Reply to this Message

Gord Dibben - 22 May 2008 19:26 GMT

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

>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?

Reply to this Message