By default, Excel aligns numbers and dates to the right and text values to the left in a cell.
In many situations, I prefer aligning the content of the cells to the center (especially with numeric datasets). It makes my data look cleaner.
Aligning cell contents in Excel can easily be done using simple shortcuts.
In this tutorial, I will give you the shortcut to center align in Excel.
Shortcut to Center Align in Excel
Below is the shortcut to Center Align in Excel:
ALT + H + A + C
How to Use the Keyboard Shortcut to Center Align in Excel
Below are the steps to use the above keyboard shortcut to align cell values to the center:
- Select the cells for which you want to center align the content
- Use the keyboard shortcut ALT + H + A + C (press these keys one after the other as if you’re typing). Below is the screenshot where the values in column B have been center aligned
Important Things to Know About Center Align in Excel:
- The above shortcut to center align in Excel works as a toggle, which means that in case the text is not aligned to the center, using the above shortcut would align it to the center. And in case it is already aligned to the center, using the above shortcut would remove the center alignment.
Alternate Ways to Center Align in Excel:
I realize this is a longer shortcut, and many people may not want to remember this in case they do not need to align their content often.
Thankfully, you can access the alignment option with a single click in the ribbon.
Below are the steps to center align on Excel using the option in the ribbon:
- Select the cells for each you want to apply the center line format
- Click the Home tab
- In the Alignment group, click on the Center option.
Advance Excel Tip: If you want to get access to center align option with one click, you can add it to the Quick Access Toolbar
Other Excel shortcuts you may also like:
- Excel Keyboard Shortcuts
- Merge or Unmerge Cells in Excel (Shortcut)
- Delete Cell in Excel (Shortcut)
- Fill Color in Excel (Shortcut)
- Wrap Text in Excel (Shortcut)
- Subscript in Excel
- Superscript in Excel
- Insert Line Break in Excel (Shortcut)
Other Excel Tutorials You May Also Like: