Md. Abdur Rahim Rasel
Sometimes, you might remove an indent in Excel to show the text or number as eye-catching. Removing the indent in Excel is an easy task. This is a time-saving task also. In this article, we’ll learn four quick and suitable ways to remove indent in Excel effectively with appropriate illustrations.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
4 Suitable Ways to Remove Indent in Excel
Let’s say, we have a dataset that contains information about the Bank statement for July. The Transaction Date, Transaction type, Debit Balance, Credit Balance, and Running Balance are given in Columns B, C, D, E, and F respectively. We might eliminate indent in Excel using the Keyboard Shortcuts, Left Alignment command, Decrease Indent command, and Custom command. Here’s an overview of the dataset for today’s task.
1. Apply Keyboard Shortcuts to Remove Indent
We will use the keyboard shortcuts to remove indent in Excel. From our dataset, we can easily remove the indent. This is the easiest and most time-saving way. Let’s follow the instructions below to remove the indent!
Steps:
- First of all, select cells C5 to C11. Further, press Alt + H +5 one after another on your keyboard.
- As a result, you will be able to remove the indent which has been given in the below screenshot.
2. Use Left Alignment Command to Remove Indent
In this section, we will apply the Left Alignment command to remove the indent in Excel. From our dataset, we can easily remove the indent using the Left Alignment command. Let’s follow the instructions below to remove the indent!
Steps:
- First, select cells C5 to C11. After that, from your Home ribbon, go to,
Home → Alignment → Left Alignment
- As a result, you will be able to remove the indent which has been given in the below screenshot.
Read More: How to Change Indent in Excel (5 Efficient Methods)
3. Apply Decrease Indent Command to Remove Indent
Now, we will apply the Decrease Indent command to remove the indent in Excel. From our dataset, we can easily remove the indent using the Decrease Indent command. This is a time-saving task also. Let’s follow the instructions below to remove the indent!
Steps:
- First, select cells C5 to C11. Hence, from your Home ribbon, go to,
Home → Alignment → Decrease Indent
- Finally, you will be able to remove the indent which has been given in the below screenshot.
4. Perform Custom Command to Remove Indent
Further, we will perform the Custom command to eliminate the indent in Excel. We can easily do that from our dataset. Let’s follow the instructions below to remove the indent!
Steps:
- First, select cells C5 to C11. Hence, press Ctrl + 1 on your keyboard.
- As a result, a Format Cells dialog box will appear in front of you. From the Format Cells dialog box, firstly, select the Alignment Secondly, select Left (Indent) from the Horizontal drop-down list.
- Further, type 0 in the Indent typing box.
- At last, press OK.
- After completing the above process, you will be able to remove the indent which has been given in the below screenshot.
Things to Remember
👉 You can also increase the indent using the keyboard shortcuts. The keyboard shortcuts are Alt + H + 6.
👉 #N/A! error arises when the formula or a function in the formula fails to find the referenced data.
👉 #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.
Conclusion
I hope all of the suitable steps mentioned above to remove indent will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries. You also can visit our website ExcelDemy to learn more Excel-related content.
Related Articles
- How to Insert Tab in Excel Cell (4 Easy Ways)
- Find and Replace Tab Character in Excel (2 Suitable Ways)
- How to Indent Second Line in Excel Cell (5 Easy Ways)
- Indent Twice the Data in Excel (4 Easy Ways)
- How to Tab to Certain Cells in Excel (2 Easy Ways)
- Indent Bullet Points of a Cell in Excel (3 Effective Ways)
