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!
You should read it
- How to center the cell in the PowerPoint table
- Text - Text in CSS
- How to Center Text on Microsoft Word
- How to Center Text in Microsoft Word
- How to center the Text Box content in Word
- How to align text in a cell in Excel
- How to center the cell in the table on Word
- Instructions on how to count words in cells in Excel
- How to convert tables into text in Word
- How to create Text Box in Excel
- Guide font formatting, change stretch and create artistic text in Word
- Convert numbers to text in Excel