Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Indent Second Line in Excel Cell (5 Easy Ways)

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.

How to Indent Second Line in Excel Cell

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.

How to Indent Second Line in Excel Cell

  • 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.

How to Indent Second Line in Excel Cell

  • 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.

How to Indent Second Line in Excel Cell

  • 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.

How to Indent Second Line in Excel Cell

  • Next, drag it to left. And, you can see the sentences transformed from one line to two lines.

How to Indent Second Line in Excel Cell

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.

How to Indent Second Line in Excel Cell

  • Similarly, do this to the remaining rows also.

How to Indent Second Line in Excel Cell

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!

📌 Steps

  • First of all, select cells in the B5:B10 range and paste them into cell C5 like Method 1.

How to Indent Second Line in Excel Cell

  • 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.

How to Indent Second Line in Excel Cell

  • Instantly, we can see the new second line starts from the text string a.

How to Indent Second Line in Excel Cell

  • Similarly, apply the same steps to the remaining cells in Column C.

How to Indent Second Line in Excel Cell

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.

How to Indent Second Line in Excel Cell

  • Afterward, select cells in the C5:C10 range.
  • Then, move to the Home tab.
  • Later, tap on the Increase Indent icon 4 times.

How to Indent Second Line in Excel Cell

  • Presently, the texts in cells look like in the image below.

How to Indent Second Line in Excel Cell

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.

How to Indent Second Line in Excel Cell

  • Now, the text of these two cells gets moved to two spaces left.

How to Indent Second Line in Excel Cell

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.

Implementing Keyboard Shortcut

  • Secondly, select cells C5, C8, and C9.
  • After that, press the ALT + H key followed by the 6 key on your keyboard.

Implementing Keyboard Shortcut

  • Thus, the text of these cells gets moved right from the cell borders.

Implementing Keyboard Shortcut

  • Again, select cell C8 and apply the keyboard shortcut for decreasing the indent.
  • For doing this, press the ALT + H + 5 key.

Implementing Keyboard Shortcut


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.

Employing Format Cells Dialog Box

  • Suddenly, the Format Cells dialog box opens up.
  • Next, jump to the Alignment tab.
  • Then, set the Indent as 3.
  • Finally, click OK.

Employing Format Cells Dialog Box

  • At last, we can see the second line of text to indent to right in the cell.

Employing Format Cells Dialog Box


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.

Practice Section


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.


Related Articles

Shahriar

Shahriar

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc in Engineering from the Bangladesh University of Engineering & Technology. I am a Naval Architecture and Marine Engineering graduate with a great interest in research and development. I love reading books & traveling. Always try to gather knowledge from various sources and implement them effectively in my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo