Tag Archives: bottom

Text Alignment Keyboard Shortcuts

We’re going to show you how to quickly use keyboard shortcuts to align text both vertically and horizontally within cells in Microsoft Excel (the screenshots used are in Excel 2010, but the relevant sections of the Ribbon and how keyboard shortcuts work with them are exactly the same as in Excel 2007).

[showmyads]

You may have noticed that if you press the Alt key (Alt stands for Alternate) lots of letters appear over the Ribbon (the standard toolbar at the top of Excel). Here’s what it looks like:

Excel Alt Ribbon Keyboard Shortcuts
What the Excel 2010 Ribbon looks like when you press the Alt key

Our text alignment shortcuts are in the Home tab of the Ribbon, so after pressing Alt we press H:

Excel 2010 Ribbon pressing Alt H
Excel Ribbon: Press Alt then H

Once you’ve pressed H you’ll see a whole new batch of letters appear above parts of the Home tab (if you weren’t on the Home tab to start with it will appear). In this example we’re going to Left Align, so you’ll now need to press AL:

Alt HAL to Left Align in Excel
Press Alt HAL to left align

And that’s it! You’ve learned to left align by pressing Alt HAL.

All the other text alignment shortcuts follow the same pattern – they start Alt HA and then the letter for where you want to align.

[showmyads]

I will leave you with a quick summary of all of the basic alignment keyboard shortcuts, may they serve you well:

Excel Align Text Left, Centre, Right
Keyboard Shortcuts to Align Text Left, Centre, Right

Excel Align Text Top, Middle, Bottom

Keyboard Shortcuts to Align Text Top, Middle, Bottom