Are there shortcut keys in Excel for Cell Alignment?

[Guest]

I'm heavy on the keyboard shortcuts, and I hate having to switch over to the
mouse to align the text inside my cells? Does anyone know if there are
shortcut keys for alignment in Excel? I couldn't find them in the MS Office
help, neither on-line or in Excel.

Thanks!

 

[Guest]

Thanks for the link, Dave! Kind of a bummer, but I guess I'll have to Build
My Own!

Appreciate it!

 

[Dave Peterson]

If you toggle a setting, you can use special characters when you enter the text.

Tools|Options|transition tab|check Transition navigation keys

^asdf (will center asdf in the cell)
"asdf (will right justify asdf in the cell)

I'd uncheck that setting when I was done with the data entry. It changes the
behavior of other keys. (Try Home and ctrl-Home, for example.)

 

[Red.MnM]

You can use Ctrl+1 which will take you to the "Format Cells" box and then
Ctrl+PgDown will take you to the "Alignment" tab and then you can just tab
thru to the different alignment positions.
Red.MnM

 

[Iqbal]

Press Alt and then press Ctrl+tab twice, and then use the right arrow key to
move along.

 

[5n1pErX]

There does not appear to be any specific shortcut. But if you can create a macro and shortcut to the macro.

Here is the script to do it:
Sub centerText()
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
End Sub

To install this macro press Alt+F11 and paste it into the code window. You can then close the window. It will save automatically.

No go to View > Macros > View Macros

You should see centerText available.

Select centerText and then click options, then assign a shortcut key and click ok

Centre text short-cut key created

 

[Polet]

You can use the following:

Align Left: Alt + H + AL
Align Center: Alt + H + AC
Align Right: Alt+ H + AR

I've tried them!