Excel is great at manipulating and sharing data, but it sure doesn't shine when it comes to text formatting. However, simple changes like indenting text can really improve readability. In this short Excel tutorial, I will show you how to indent In Excel.
By default, Excel aligns text strings to the left of the cell and numbers to the right. If you don't like the look of your data, you can increase or decrease the indent. Follow these steps to indent data in cells:
You can use the same process to indent multiple cells at once.
Removing cell indentation is just as easy. Follow steps 1 to 3 described above, but use the Decrease Indent icon instead.
Keep in mind that text alignment determines how Excel indents:
An alternative option is to indent using the Format Cells dialog box.
Each indent moves the contents of the cell to the right by about three characters.
If you want to remove the indent, follow the steps described above and insert 0 (zero) in the Indent field.
As you might have seen, the indentation is applied to the entire cell. This means that if you have text that spans across multiple lines, you won't be able to indent only one line using this method.
The good news is that there is a workaround to indent individual lines within the same cell. It's not pretty, and the method can't be applied to multiple cells at once, but it gets the job done.
For this to work properly, you need to have your text stored properly on multiple lines.
To achieve this, select the cell that you want to edit and press F2 to get into the edit mode (or double click on the cell). Position the cursor where you want to insert a new line and press ALT + Enter.
Once your data is split the way you want it, position the cursor at the beginning of the line and press Spacebar until you are satisfied with the indentation. Move to the next row if needed and repeat. When you are done, press Enter to finish your changes.
And here is how the indentation process looks step by step.
If you need to adjust the indent, all you need to do is enter the cell edit mode again and add more spaces at the beginning of the lines.
If you prefer using your keyboard, you'll be happy to learn that two easy shortcuts allow you to increase indent and decrease indent quickly.
Keyboard shortcut to Increase Indent:+ +
Keyboard shortcut to Decrease Indent:+ +
To use these shortcuts, select the cells where you want to apply the indentation and press the keys in the order shown above. You need to press the keys in succession (i.e., one after the other), not simultaneously.
If you have additional questions about how to indent in Excel, please leave a comment below. I reply to every message, and I really want to help you become better.
The easiest way to learn Excel is by solving problems. This is why I have created a dedicated section with useful Excel formulas.