How to Center Horizontally and Vertically in Excel

Center Horizontally
1. Click the cell or cells in which you want to center data horizontally.
2. Click the 'Home' tab.
3. Click the 'Center' button located in the 'Alignment' group. The Center button centers the text horizontally in the selected cell.
Center Vertically
4. Click the cell or cells in which you want to center data vertically.
5. Click the 'Home' tab.
6. Click the 'Middle Align' button located in the 'Alignment' group. The Middle Align button centers the text vertically, between the top and bottom of the cell.