Shortcut for wrap text or vertical center in cell

[Guest]

Is there a keyboard shortcut for wrap text? how about centering data
vertically in a cell?

 

[Guest]

Have you considered assigning a short macro to the KB combination of i.e.
<Ctrl>+<Shift>+W?

Dennis

 

[Earl Kiosterud]

Buzz,

Looking in Help for formatting shorcuts yielded nothing. You can roll your
own, using the underlines. For wrap text, it's a bit long. Alt-o, e, a,
Alt-w, Enter. For vertical centering, Alt-o, e, a, Alt-V, c, Enter.

Or you could record a macro as you do this once (store it in personal
workbook if you want if available across all workbooks). You have to remove
all the code not related to vertical centering, or whatever task is at hand,
as the recorder generates code for everthing in the dialog you were in. Now
you can assign that to a keyboard shortcut, a toolbar button, or a menu
item.

I've recorded some for you:

Sub WrapText()
With Selection
.MergeCells = True
End With
End Sub

Sub VerticalCenter()
With Selection
.VerticalAlignment = xlCenter
End With
End Sub

Paste this into a module of personal.xls in the VBE (Alt-F11 to get to it).
Then assign them to a keyboard shortcut (Tools - Macro - Macros).

 

[Guest]

Select columns and rows you want wrapped text the right click and choose
format cells. Keep clicking wrap text until you get a dark checkmark.

If you rarely need to wrap text then select a cell that you want to wrap
text. Right click, format cells, wrap text. Move to the next cell and do a
control y which is redo last action.

 

[Earl Kiosterud]

Mike,

Ctrl-y is redo last undo, not repeat last action.

 

[Mangus Pyke]

Ctrl-y is redo last undo, not repeat last action.

It functions as both.

If you format a column, and do not Undo it, pressing Ctrl-Y on another
column will repeat the format.

MP-

 

[Earl Kiosterud]

Mangus,

So it does. It tried to get it to do that, but didn't have the hang of it.
It appears if there's anything in the redo queue, Ctrl-y redoes that. If
not, it repeats the last action. I think! Thanks.