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

How to Indent Twice the Data in Excel (4 Easy Ways)

Microsoft Excel excels at arranging and manipulating data, however, formatting text is also an essential aspect of data analysis. Now, what if you need to indent specific text in Excel? With this question in mind, this article shows 4 simple ways how to indent the data twice in Excel with appropriate illustrations.


Download Practice Workbook

You can download the practice workbook from the link below.


Why Indenting the Data Twice in Excel Is Necessary?

In writing, indentation refers to an empty space at the start of a line or paragraph which indicates the beginning of a new paragraph. In fact, indentation makes it easier to read and understand long documents. By default, Excel aligns all the texts to the right while it aligns the numbers to the left.
Now, you can add extra spacing using the SPACEBAR but this is time-consuming and you may forget how many spaces to use for the indentation. So instead, you can utilize Excel’s features to save time and effort while achieving uniform indentation in your document.


4 Ways to Indent the Data Twice in Excel

Let’s consider the List of Clientele dataset shown in the B4:D14 cells. Here, we have the Company Names, their Addresses, and the City they are located in. Now, we want to indent the text in columns B and C. Therefore, without further delay let’s see each method individually.

Dataset 1

Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.


Method-1: Utilizing Keyboard Shortcut to Indent Data Twice

Wouldn’t it be great if only there was a keyboard shortcut to indent data twice in Excel? Well, you’re in luck! Because our first method describes just that. So, follow these simple steps.

📌 Steps:

  • At the very beginning, select the B5:C14 range of cells and hit the ALT key on your keyboard.

Using Keyboard Shortcut

  • Secondly, press the H + 6 keys simultaneously.

Now, this indents the text once.

Using Keyboard Shortcut

Lastly, repeat the same process to indent the text twice as shown in the image below.

How to Indent the Data Twice in Excel Using Keyboard Shortcut

Read More: How to Insert Tab in Excel Cell (4 Easy Ways)


Method-2: Using Indent Option to Indent Data Twice

In addition to shortcuts, Excel offers the indent option directly in the Home Ribbon. Now, allow me to demonstrate the process in the steps below.

📌 Steps:

  • To begin with, select the B5:C14 range of cells >> in the Alignment section, and click the Increase Indent button twice.

How to Indent the Data Twice in Excel Using Indent Option

Finally, after completing the above step, the result should look like the picture shown below.

How to Indent the Data Twice in Excel Using Indent Option

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


Method-3: Indenting Data Twice with Alignment Settings Feature

Another way to indent the data twice is to use the Alignment Settings feature in Excel. The advantage of this method is that it allows you to set the indent according to your preference. It’s simple and easy, so, just follow along.

📌 Steps:

  • Initially, select the B5:C14 range of cells >> click the Alignment Settings arrow as shown in the screenshot below.

Using Alignment Settings Feature

This opens the Format Cells dialog box.

  • Next, choose the Alignment tab >> then, enter the amount of Indent, in this case, we chose 2 >> click the OK button.

How to Indent the Data Twice in Excel Using Alignment Settings Feature

📄 Note: Also, you can open the Format Cells option by pressing CTRL + 1 if you want.

Eventually, your output should look like the image given below.

How to Indent the Data Twice in Excel Using Alignment Settings Feature

Read More: How to Change Indent in Excel (5 Efficient Methods)


Method-4: Indenting Data Twice in a Single Cell

Now, I know what you’re thinking. How to indent text inside a cell? Don’t worry, just yet! Since our following method provides the answer to your question. Therefore, let’s go through the steps.

📌 Steps:

  • Firstly, double-click to select the cell you want to indent, for example, we’ve chosen the B5 cell.
  • Next, move the cursor in front of the word Industries and press the ALT + ENTER keys.

Using ALT and ENTER Keys

This moves the Industries text to the next line.

  • Following this, press the SPACEBAR in order to indent according to your preference. In this case, you need to press the key 6 times.

How to Indent the Data Twice in Excel Using ALT and ENTER Keys

  • In a similar fashion, repeat the same procedure for the C5 cell.

How to Indent the Data Twice in Excel Using ALT and ENTER Keys

Subsequently, after completing the steps, the result should look like the picture shown below.

How to Indent the Data Twice in Excel Using ALT and ENTER Keys

Read More: How to Tab to Certain Cells in Excel (2 Easy Ways)


Removing Indents in Excel

If you’re wondering how to remove indents in Excel, then I have some good news for you. So, let’s see it in action.

📌 Steps:

  • Firstly, select the B5:C14 range of cells >> go to the Alignment section >> click the Decrease Indent button twice.

📄 Note: You can also use the keyboard shortcut by pressing the ALT key and then pressing the H + 5 keys together on your keyboard.

Remove Indent

Lastly, the output should look like the screenshot shown below.

How to Remove Indent in Excel


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section


Conclusion

This article provides the answers on how to indent the data twice in Excel using quick and easy ways. Make sure to download the practice files. Hope you found it helpful. Please inform us in the comment section about your experience. We, the ExcelDemy team, are happy to answer your queries. Keep learning and keep growing!


Related Articles

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo