How to Justify Text in Cells on Excel - Adjust Text Spacing
To edit content on Word more professionally and beautifully, we often customize the left margin with the key combination Ctrl + L, the right margin with the key combination Ctrl + R, the 2-sided justification with Ctrl + J and the center with the key combination Ctrl + E. However, on Excel, there will only be left, right, and center alignment by cell. Therefore, if you want to align text on both sides on Excel like Word, there will be no key combination to use.
However, users can also use the function in Format Cells to align text 2 sides in Excel. The following article will guide readers on how to align text in cells in Excel.
Instructions for justifying text in Excel
Step 1:
In the cell with the text you want to align, if the text is too long and you want the text to automatically wrap to the next line, click Wrap Text , in the Alignment settings group.
How to Justify Text in Cells on Excel - Adjust Text Spacing Picture 1
The text in the cell will automatically wrap to the next line and will only be in one cell.
How to Justify Text in Cells on Excel - Adjust Text Spacing Picture 2
Step 2:
Right click on the cell and then right click and select Format Cells .
How to Justify Text in Cells on Excel - Adjust Text Spacing Picture 3
Step 3:
In the new interface that appears, the user clicks on Alignment . Then in the Horizontal section, select Justify to align the text on both sides and click OK below.
How to Justify Text in Cells on Excel - Adjust Text Spacing Picture 4
As a result, you will see the text is justified on both sides of the cell. When you click on the cell to add content, the text will still be automatically justified as you set before.
How to Justify Text in Cells on Excel - Adjust Text Spacing Picture 5
Through the Format Cells feature on Excel, we can align text in cells on Excel, edit text evenly on Excel. Before aligning, you need to put the content in a cell for easy adjustment.
Good luck!
You should read it
- How to align text in a cell in Excel
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- How to fix the SUM function doesn't add up in Excel
- Guidance on how to align Excel correctly
- How to keep Excel and Excel columns fixed?
- What is ### error in Excel? how to fix ### error in Excel
- How to display 0 in front of a number in Excel
- Instructions for searching and replacing in Excel tables
- MS Excel 2007 - Lesson 2: Customizing in Excel
- 3 ways down the line in Excel, line break, down row in 1 Excel cell
- Shortcut guide, abbreviated in Excel
May be interested
How to strikethrough text in Word, write strikethrough text in Word and Excel
Keyboard shortcuts in Excel 2007, 2013, 2016, 2010, 2003, 2019, 2021
How to draw a beautiful, professional mind map in Powerpoint
How to quickly and beautifully remove signature background in Word
How to master numerical data in Google Sheets with the AVERAGE function
How to make Excel spreadsheets smarter with drop-down lists