Excel Bad Habit #19: Removing Indentation One Level at a Time Instead of All at Once
Some reports come stacked with several levels of indentation, which can help the user read and understand categories and line items.
The Problem: Removing Multiple Levels of Indentation
When you want to remove indentation, it doesn't work to highlight all of the levels and click the Decrease Indent button.
So some people get into the bad habit of going level by level and removing indentation using Decrease Indent. This can take too long, especially if it's a large report.
The Solution: Set Indent Level to Zero
Instead, remove all of the indentations simultaneously. Here's how.
Start by selecting the range of cells you want to change. Then use the right-click menu to select Format Cells. The keyboard shortcut for Format Cells is Ctrl + 1.
On the Alignment tab, change the Indent level to 0, and then hit OK.
Voilà! You've just removed all of the indentation in one stroke and kicked another Excel bad habit to the curb. Congratulations!
Questions? Leave a comment below! And be sure to let us know if this tip was helpful for you.
I found another shortcut that is quicker for me. I select the center alignment (which clears all the indent levels) and then immediately select the left (or right) alignment. Everything is in one alignment now.
Am I missing something? I’ve always just used the left align button to reset indentations.
or just click the align left button?