Are there shortcut keys in Excel for Cell Alignment?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Thanks for the link, Dave! Kind of a bummer, but I guess I'll have to Build
My Own!

Appreciate it!
 
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.)
 
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
 
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 :)
 
You can use the following:

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

I've tried them!
 
Back
Top