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.

Excel File Icon 2021 xlsx Remove Indentation Formatted Income Statement.xlsx

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.

Search
Generic filters
Exact matches only

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

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

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly

Free Excel Training Webinar Modern Power Tools

>