Shortcut for wrap text or vertical center in cell
 

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

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

Dennis

"webbuzzard" wrote:

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

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).
--
Earl Kiosterud
www.smokeylake.com

"webbuzzard" wrote in message
...
Is there a keyboard shortcut for wrap text? how about centering data
vertically in a cell?

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.

"webbuzzard" wrote:

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

Mike,

Ctrl-y is redo last undo, not repeat last action.
--
Earl Kiosterud
www.smokeylake.com

"Mike" wrote in message
...
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.

"webbuzzard" wrote:

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

On Mon, 18 Jul 2005 13:43:40 -0400, "Earl Kiosterud" wrote:
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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

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.
--
Earl Kiosterud
www.smokeylake.com

"Mangus Pyke" wrote in message
...
On Mon, 18 Jul 2005 13:43:40 -0400, "Earl Kiosterud" wrote:
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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner