How to center numbers in EXCEL? Tutorial on number center setting in EXCEL

1. Open an EXCEL table

In order to test the function, we open an excel table and enter a few lines of numbers at will. You will find that all the numbers are left.

2. Select the center number

As shown in the following figure, select the text to be centered, right-click its cell, and click set cell format in the pop-up menu ].

3. Text method

After entering the cell format settings, we click the text method in the following figure. Here there is a horizontal alignment, and the other is vertical alignment ]. Click horizontal alignment ].

4. Center selection

When we click horizontal alignment, you will see an arrow in the drop-down menu, and then click it to see many alignment methods. Here we just need to click center ].

5. The settings are complete.

Now, click "OK" and you will find that the number is in the center. You can set this for other options.