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.
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.
Indent Twice the Data in Excel: 4 Easy Ways
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.
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.
- At the very beginning, select the B5:C14 range of cells and hit the ALT key on your keyboard.
- Press the H + 6 keys simultaneously.
Now, this indents the text once.
Repeat the same process to indent the text twice as shown in the image below.
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.
- To begin with, select the B5:C14 range of cells >> in the Alignment section, and click the Increase Indent button twice.
Finally, after completing the above step, the result should look like the picture shown below.
Read More: How to Indent Second Line in Excel Cell
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.
- Initially, select the B5:C14 range of cells >> click the Alignment Settings arrow as shown in the screenshot below.
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.
📄 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.
Read More: How to Change Indent in Excel
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.
- First, 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.
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.
- In a similar fashion, repeat the same procedure for the C5 cell.
Subsequently, after completing the steps, the result should look like the picture shown below.
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.
- First, 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.
The output should look like the screenshot shown below.
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.
Download Practice Workbook
You can download the practice workbook from the link below.
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.