How to align text in a cell in Excel

Just like on Word, users can align text in Excel cells, making the distance between the letters more evenly.

To edit the content on Word more professionally, we often customize the left alignment with the Ctrl + L key combination, align right with the Ctrl + R key combination, align both sides with Ctrl + J and the base middle with Ctrl + E key. However, Excel will only have left, right, middle of the cell. So if you want to align 2 words above Excel as Word will have no key combination to use.

However, users can also use the function in Format Cells to align the 2 words inside Excel. The following article will guide you how to evenly align the text in the box on Excel.

  1. How to center the cell in the table on Word
  2. Guidance on how to align Excel correctly
  3. MS Excel - Lesson 4: Working with lines, columns, sheets

Instructions are aligned in Excel

Step 1:

In the cell with the text content to be even if the text is too long and you want the text to automatically wrap Wrap Text , in the group set Alignment.

  1. 3 ways down the line in Excel

How to align text in a cell in Excel Picture 1How to align text in a cell in Excel Picture 1

The result of the text in the cell will automatically flow down and in only 1 cell.

How to align text in a cell in Excel Picture 2How to align text in a cell in Excel Picture 2

Step 2:

Right-click the cell and right-click and choose Format Cells .

How to align text in a cell in Excel Picture 3How to align text in a cell in Excel Picture 3

Step 3:

In the new interface, users will click on Alignment . Then at the Horizontal section select Justify to align the letters on both sides and click OK below.

How to align text in a cell in Excel Picture 4How to align text in a cell in Excel Picture 4

As a result, you will see that the text is aligned 2 inside the cell. When you click on the box to add content, the text will still be automatically aligned by you set up earlier.

How to align text in a cell in Excel Picture 5How to align text in a cell in Excel Picture 5

Through Format Cells feature in Excel, we can evenly align the text in Excel cells, edit the word evenly on Excel. Before aligning, you need to put the content in 1 box for easy adjustment.

See more:

  1. Summary of expensive shortcuts in Microsoft Excel
  2. These are the most basic functions in Excel that you need to understand
  3. MS Excel - Lesson 11: Format spreadsheet

I wish you all success!

4 ★ | 4 Vote