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

How to Remove Indent in Excel (4 Easy Methods)

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.

remove indent in excel


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.

Apply Keyboard Shortcuts to Remove Indent in Excel

  • As a result, you will be able to remove the indent which has been given in the below screenshot.

Apply Keyboard Shortcuts to Remove Indent in Excel


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.

Perform Custom Command to Remove Indent in Excel

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

Perform Custom Command to Remove Indent in Excel

  • After completing the above process, you will be able to remove the indent which has been given in the below screenshot.

Perform Custom Command to Remove Indent in Excel


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

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo