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).
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:
Our text alignment shortcuts are in the Home tab of the Ribbon, so after pressing Alt we press 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:
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.
I will leave you with a quick summary of all of the basic alignment keyboard shortcuts, may they serve you well: