How to align text between cells in Word and Excel

To center alignment for a paragraph, you only need to select Center in the Home tab . However, if the top alignment is used for a cell in a data table, Excel spreadsheet, you will not be able to adjust the alignment content in the middle position. compared to the cell in the spreadsheet. The following article shows how to center cells in Word and Excel.

Align text in a cell in Word

For example, for the data table below, the data is not in the middle of the cell:

How to align text between cells in Word and Excel Picture 1

Where the choice of alignment between the Center, the text is not in the middle position versus box.

How to align text between cells in Word and Excel Picture 2

To center alignment do the following:

- Select the table content to align -> Layout -> Alignment -> Align Center:

How to align text between cells in Word and Excel Picture 3

- The results of the data content in each table cell are centered:

How to align text between cells in Word and Excel Picture 4

- In addition to the above, you can do the following: Select Center alignment for the data table -> select the data table that needs alignment -> right-click and select Table Properties:

How to align text between cells in Word and Excel Picture 5

- A dialog box appears -> select the Cell tab -> Center -> click OK:

How to align text between cells in Word and Excel Picture 6

- Aligned data table results:

How to align text between cells in Word and Excel Picture 7

Center text in Excel.

- Select the content in the cell to be centered -> on the Home tab -> Alignment -> Middle Align (to select the content of text evenly spaced above and below the cell):

How to align text between cells in Word and Excel Picture 8

- Next select Center (center alignment):

How to align text between cells in Word and Excel Picture 9

- The result after choosing two types of alignment results:

How to align text between cells in Word and Excel Picture 10

- In addition, to center the cell you right-click the content to be centered -> Format Cell:

How to align text between cells in Word and Excel Picture 11

- The dialog box appears, select the Alignment tab in the section:

+ Horizotal : select Center (content in the middle compared to the horizontal, equal to the left and right margins).

+ Vertical: Select Center (content in the middle compared to vertical ie equidistant from the top and bottom).

After making your selection click OK:

How to align text between cells in Word and Excel Picture 12

- Get results:

How to align text between cells in Word and Excel Picture 13

Above is a detailed guide on how to center cells in Word and Excel. In this article used on Word, Excel 2013 with other versions of MS you do the same. Good luck!