How to apply horizontal centering in Excel
You can watch a video tutorial here.
Excel has several ways in which cells and their values can be formatted. Formatting is used to improve the appearance of the data on a worksheet and to make it look more presentable. One feature that is often used is the alignment options. By aligning data in a column or row, the data can be made to look neater. Here we will see how to center data horizontally in a cell. There are two ways of doing this:
- The Alignment option on the Home menu ribbon
- Format the cells
Option 1 – Use the Alignment option on the Home menu ribbon
Step 1 – Select the cells
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-1-–-How-to-apply-horizontal-centering-in-Excel-1024x747.png)
- Select the cells for which the data is to be centered
Step 2 – Center the data horizontally
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-2-–-How-to-apply-horizontal-centering-in-Excel-1024x697.png)
- Go to Home > Alignment
- Click on the Center button
- The values in the column will be centered horizontally
Optin 2 – Format the cells
Step 1 – Select the cells
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-1-–-How-to-apply-horizontal-centering-in-Excel-1024x747.png)
- Select the cells for which the data is to be centered
Step 2 – Open the Format Cells window
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-2-How-to-apply-horizontal-centering-in-Excel-915x1024.png)
- Right-click and select Format Cells from the context menu
OR
Go to Home > Number and click on the arrow to expand the menu
OR
Go to Home > Cells > Format > Format Cells
OR
Press Ctrl+1
Step 3 – Center the text
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-3-–-How-to-apply-horizontal-centering-in-Excel-1024x578.png)
- Go to the Alignment tab
- Under Text alignment > Horizontal select Center
- Press OK
Step 4 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-4-–-How-to-apply-horizontal-centering-in-Excel.png)
- The text is centered horizontally