By default, the text alignment is set to left whenever you enter some text and press ENTER key. It’s okay if you don’t want to keep your text left aligned, that’s what we are going to discuss today. How to indent second line in Excel cell? Do you know anything about it?
Indentation basically holds the right to manage alignment issues of any text. The indent option is present in the alignment menu of Excel because it is responsible for the alignment setting. Other than Excel, you will find the indentation feature in MS Word as well. Anyhow, let’s see how you can cover this topic with the help of multiple approaches.
How to Indent Second Line in Excel Cell?
When a sheet consists of some text-type data, indentation is the one thing you can use to make it readable. Suppose, your text in a cell does not have enough space because it is too long, that’s where indenting appears and helps in sorting the problem.
Below you can see a list of lengthy sentences and we will try to indent them in the second line so that they can be fitted easily.
Indent Second Line in Excel Cell with Wrap Text Option:
First of all, we will simply use the wrap text option. Let’s see how you can use it:
- First, create an Output column in the C4:C10 cell range.
- Now, select cells in the B5:B10 range.
- Press CTRL + C to copy all of them.
- Select cell C5 and paste them.
- Press CTRL + V to paste them.
- Now, select cells in the C5:C10 range.
- Open the Home tab and select the Wrap Text option from the Alignment menu.
- Put the cursor at the end of the Column C heading. A double-faced arrow will appear on the right side.
- Drag it to the left side and you will notice the sentences shifted from one line to two lines.
- Put the cursor at the line between rows 5 and 6. Double-click here.
- You will notice the row height of Row 5 gets adjusted with the text line.
- Repeat the same procedure with other rows as well.
Indent Second Line in Excel Cell with Keyboard Shortcut:
Sometimes, users don’t want to follow steps that include cursor pointing. Therefore, keyboard shortcuts get importance more than other approaches. So, let’s see how you can indent second line in Excel cell with a keyboard shortcut.
Select cells in the B5:B10 range and paste them into cell C5. To paste these cells, press CTRL + V.
Select cell C5.
Now, double-click on it and place the cursor before text a.
Press ALT + ENTER key.
You will notice the new second line starts from the text string a.
Now, repeat the same steps for all the other cells in Column C.
Indent Second Line in Excel Cell with Ribbon Options:
The above keyboard shortcut is super effective. However, if someone wants to try another quick method to indent the second line, let’s see how ribbon options can help.
Below are simple steps to follow:
- Select cells that needed to apply the indentation.
- Open the Home tab.
- Click on the indent icons from the Alignment menu.
Note that the indentation is applied to all the content in the cell. Therefore, if a cell has more than one line, all of them would be indented.
Do you know that by using these options for indentation, Excel indents are equal to three space characters?
To Wrap Up:
In this post, you have briefly learned how to indent second line in Excel cell. Other than the keyboard shortcut method, you have a complete step-by-step procedure of other approaches as well. All the above-mentioned methods are super fast and helpful. You can try any of them without any hesitation.
