Shahriar
Need to learn how to indent the second line in a cell of Excel? If you use a certain style or include a paragraph in an Excel cell, you might want to indent the content. If you are looking for such unique kinds of tricks, you’ve come to the right place. For this purpose, we will take you through five easy and convenient methods for indenting the second line in an Excel cell.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice yourself.
5 Ways to Indent Second Line in Excel Cell
If your worksheet contains text, introducing indents could make it much easier to read. If your text in a certain cell is too long to display itself, then indenting it to a new line is the best alternative.
Here, we have a List of Sentences. It includes some six Sentences. They are quite long text strings.
Now, we’ll indent them to a new second line to get them fit in a short cell.
Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.
1. Using Wrap Text Option to Indent Second Line in Excel Cell
In our first method, we’ll use the Wrap Text option. It’s simple & easy. Let’s explore the method step by step.
📌 Steps
- At the very beginning, create an Output column in cells in the C4:C10 range.
- Secondly, select cells in the B5:B10 range.
- Then, copy them by pressing CTRL + C on the keyboard.
- After that, select cell C5 and paste them by pressing CTRL + V.
- In this instance, select cells in the C5:C10 range.
- Afterward, go to the Home tab.
- Later, select the Wrap Text option on the Alignment group.
- Now, place the cursor at the end of the heading of Column C. You can see a double-faced arrow sign while getting it to the right place.
- Next, drag it to left. And, you can see the sentences transformed from one line to two lines.
Note: They look like the above because of the lack of space. It will be fine if we increase the Row Height.
- Then, place the cursor at the straight line between rows 5 and 6.
- At this moment, double-click here.
- Suddenly, you can see the row height of Row 5 gets adjusted with the text string.
- Similarly, do this to the remaining rows also.
Read More: How to Insert Tab in Excel Cell (4 Easy Ways)
2. Applying Keyboard Shortcut to Indent Second Line in Excel Cell
If the first method feels boring to you and you’re in the mood to try something different, then the second method is for you. Here, we’ll show a keyboard shortcut to indent the second line. So, without further delay, let’s dive in!
- First of all, select cells in the B5:B10 range and paste them into cell C5 like Method 1.
- At first, select cell C5.
- Then, double-click on the cell and place the cursor before text string a.
- Lastly, press the ALT+ENTER key.
- Instantly, we can see the new second line starts from the text string a.
- Similarly, apply the same steps to the remaining cells in Column C.
Read More: How to Tab to Certain Cells in Excel (2 Easy Ways)
3. Utilizing Indent Option on Ribbon
If the above method is too much work, then the following method is for you. Here, we’ll utilize the Increase Indent and Decrease indent icons on the ribbon. Let’s see the process in detail.
📌 Steps
- Firstly, wrap the text following the steps of Method 1.
- Afterward, select cells in the C5:C10 range.
- Then, move to the Home tab.
- Later, tap on the Increase Indent icon 4 times.
- Presently, the texts in cells look like in the image below.
Note: There are 4 blank spaces before the texts as we tap the icon four times.
- Again, select cells C6 and C8.
- Then, proceed to the Home tab.
- Lastly, tap on the Decrease Indent icon twice.
- Now, the text of these two cells gets moved to two spaces left.
Read More: How to Change Indent in Excel (5 Efficient Methods)
4. Implementing Indent Option Shortcut
Wouldn’t it be great if only there were keyboard shortcuts to do the same task as Method 3? Well, you’re in luck because they exist. Allow me to demonstrate the process below.
📌 Steps
- Primarily, wrap the text following the steps of Method 2.
- Secondly, select cells C5, C8, and C9.
- After that, press the ALT + H key followed by the 6 key on your keyboard.
- Thus, the text of these cells gets moved right from the cell borders.
- Again, select cell C8 and apply the keyboard shortcut for decreasing the indent.
- For doing this, press the ALT + H + 5 key.
5. Employing Format Cells Dialog Box
As with Excel, there are multiple ways of doing the same task. So, we’ll explore another method to indent the second line in an Excel cell. To do this using the following method, you may follow the below steps.
📌 Steps
- At first, select cells in the C5:C10 range.
- Then, press CTRL + 1 on your keyboard.
- Suddenly, the Format Cells dialog box opens up.
- Next, jump to the Alignment tab.
- Then, set the Indent as 3.
- Finally, click OK.
- At last, we can see the second line of text to indent to right in the cell.
Practice Section
For doing practice by yourself we have provided a Practice section like below in each sheet on the right side. Please do it by yourself.
Conclusion
This article provides easy and brief solutions to indenting the second line in an Excel cell. Don’t forget to download the Practice file. Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website ExcelDemy to explore more.
