HomeApplicationOffice information

How to align text in a cell in Excel

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 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 2

Step 2:

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

How 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 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 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

You should read it

May be interested

  • How to use Focus Cell to highlight Excel dataHow to use Focus Cell to highlight Excel data
    excel focus cell feature is one of the useful features, highlighting the row and column of the active cell, helping you keep track of your location in the spreadsheet for easier reading across rows and columns.
  • How to use notes in Microsoft ExcelHow to use notes in Microsoft Excel
    comments in microsoft excel are simple text messages associated with individual cells. they are often used to add context to the cell's contents, explaining a few small details about the cell.
  • How to extract numbers or text from ExcelHow to extract numbers or text from Excel
    microsoft excel is great for working with both numbers and text, but if you use both in the same cell, you may have some difficulties. fortunately, you can extract numbers or text from cells to work with your data more efficiently.
  • Types of data hiding in Excel - Part 2: How to hide cells, overflow textTypes of data hiding in Excel - Part 2: How to hide cells, overflow text
    continuing the 'extremely useful guide to all types of data hiding in excel'. tipsmake would like to introduce to you part 2: how to hide cells, overflow text ...
  • Complete tutorial of Excel 2016 (Part 5): Basics of cells and rangesComplete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
    whenever you work with excel, you will need to enter information - or content - into the cells . cells are the basic building blocks of a spreadsheet. you will need to learn the basics of cells and cell contents to calculate, analyze, and organize data in excel.
  • Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016
    if you have read the article about microsoft word, you must have grasped some basic knowledge about text alignment. let's refer to the article on formatting spreadsheet data in excel 2016 in this article!
  • How to align printed pages in ExcelHow to align printed pages in Excel
    excel is an office application that supports quite well in printing, and you can see the print results immediately on the computer screen you are using, in the following article, tipsmake will guide you how to align. page editing in excel, invite you to follow along.
  • How to Justify Text in Cells on Excel - Adjust Text SpacingHow to Justify Text in Cells on Excel - Adjust Text Spacing
    just like in word, users can align text in excel cells, making the spacing between letters more even.
  • How to Truncate Text in ExcelHow to Truncate Text in Excel
    this wikihow teaches you how to shorten the appearance of data in microsoft excel. to do this, your full, unshortened data will need to be entered into excel first. open microsoft excel. if you have an existing document with your data...
  • Format Excel 2007 spreadsheetFormat Excel 2007 spreadsheet
    sometimes you want to split data in one cell into two or more cells. you can do this easily by using the convert text to columns wizard.

Office information