Remove Indentation on Multiple Cells at Different Levels

Bottom Line: Learn two quick ways to remove the indentation on multiple cells when the indentation is set at different levels.  

Skill Level: Beginner

Watch the Tutorial

Watch on YouTube & Subscribe to our Channel

Download the Excel File

Follow along using the same file I use in the video.

Removing Indentation from Multiple Cells

Sometimes the formatting of a sheet has indentation on multiple levels, such as with this example of an income statement.

Multiple Level Indentation

Removing all of the indentations can be a time-consuming task. If you select all of the cells that contain indentation (at multiple levels) and press the Decrease Indent button, nothing happens. The indentation is NOT removed.

Fortunately, there are ways to quickly remove the indentation at multiple levels all at one time. Let's take a look at two techniques.

1. Change Alignment to General

The first way to take care of this issue is to change the alignment of the cells to the General setting.

Start by selecting all of the cells that you want to remove the indentation for. Then click the Left Align button to change the alignment to General.

Left Align Button

The indentation will be removed. The values in the cells will use the General Alignment, which differs based on the data type of the cell. Text will be aligned to the left. Numbers and dates aligned to the right.

Indentation is removed

Note: If the Left Align button is not already enabled, or you have different alignment settings for each cell, then you will have to press the Left Align button twice to change the alignment to General.

2. Remove Indenation but Keep Alignment Settings

There may be cases where you have cells in your selection that you don't want to clear the alignment for. Perhaps you have some merged cells, or text that is center-aligned, or some that are right-aligned, such as in this example.

Right aligned cell

If that's the case, you can use this second technique. Start by selecting the range of cells that you want to work with. The selection can include cells that are not indented and have other alignment settings applied.

Then right-click and choose Format Cells. The keyboard shortcut for this is Ctrl + 1.

Right click format cells

When the Format Cells window opens, go to the Alignment tab and set the Indent field to 0.

Indent Setting on alignment Tab of Format Cells Window

As you can see below, the result is that the alignment remains the same, but the indentation goes away.

indentation removed right aligned cells unchanged

Conclusion

Pretty easy, huh? I hope these techniques help save you time over having to clear indentation one by one. If you have any questions or suggestions, I invite you to leave a comment below.

1 comment

Your email address will not be published. Required fields are marked *

  • If the text in the cell is set to the currency or comma format, that wouldn’t that also be a reason that the text in all the cells are not in complete alignment?
    Meaning, even after doing what you suggested, of going onto the alignment and setting it to 0, (which, btw, is a great tip…I never thought of it), if the cell is set to comma or currency, I don’t believe it will fix the issue, which can be extremely frustrating.

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter