HomeApplicationOffice information

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!

4 ★ | 1 Vote

You should read it

May be interested

  • How to Sort Cells Alphabetically in ExcelHow to Sort Cells Alphabetically in Excel
    excel is a powerful spreadsheet tool used to store and manage text or figures. alphabetical sorting is one of excel's useful features with the ability to help you sort, access and reference data quickly. to sort cells in excel alphabetically, simply double-click by highlighting the range of cells to sort, then click the 'az sort' or 'za sort' icon in the bar. standard tool. to sort cells alphabetically in excel using the advanced sort option, highlight the entire worksheet, click the 'sort' option from the 'data' menu. , then select the column and order you want to sort in the dialog box that appears.
  • How to Alphabetize Cells in ExcelHow to Alphabetize Cells in Excel
    excel is a powerful spreadsheet tool used to store and manage text and numbers, and alphabetizing is one of the many benefits of using excel since it allows you to quickly organize, access, and reference data. to alphabetize cells in excel...
  • 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.
  • How to indent the line in ExcelHow to indent the line in Excel
    when you enter data into a spreadsheet, excel automatically aligns with cells containing numbers to the right of the cell, and text input cells are automatically located to the left of the cell.
  • How to split cells, combine cells in ExcelHow to split cells, combine cells in Excel
    how to split cells, combine cells in excel. on excel spreadsheets, many times you need to split cells, merge cells to fit the data you need to enter. you can combine two or more cells together using excel's built-in functions or use visual basic to merge
  • Spacing lines in ExcelSpacing lines in Excel
    spacing lines in excel. in the process of editing excel file, sometimes the lines are not spaced as expected or the lines are not spaced evenly. so you want to evenly line the data in excel. the following article will guide fish
  • 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.
  • How to calculate and color blank cells in ExcelHow to calculate and color blank cells in Excel
    counting and coloring blank cells in excel will rely on excel functions and conditions to perform.
  • Instructions on how to fix Excel line spacing errorInstructions on how to fix Excel line spacing error
    excel line spacing error is the case tipsmake mentioned in the article. if you are having difficulty due to this situation, please quickly refer to it
  • Spacing, spacing words in WordSpacing, spacing words in Word
    spacing, spacing words in word. to quickly line up in word, select (highlight) the paragraph or the whole text.

Office information