Indent from the ribbon menu
By default, when you enter text in a cell, Excel aligns it to the left. When you enter a number, Excel aligns it to the right.
Aside from that, any data you enter in a cell, whether text or number, sticks too close to the cell border.
And if you don’t like the contents to be too close to the cell border, the best option you can do is indentation. You can indent text to the left or to the right in a cell 😊
The most obvious method how to indent in Excel is by using the indent buttons in the Alignment group of the Excel ribbon menu.
Let’s do it 👇
- Select the cell you want to indent.
- Click the Home Tab.
- In the Alignment group, click the Increase Indent icon as you like, depending on how you want the content to be newly aligned.
The Increase Indent icon moves your content farther away from the cell border, from left to right.
One indent is equivalent to three spaces. The more you click the button, the more indentation applies.
- To decrease the indent already present in a cell, click on the Decrease Indent icon.
The Decrease Indent button moves your content closer to the cell border.
Indentation is mainly used for text. If you use it for numbers, it may be a little confusing. Only that it’s not.
Numbers align to the right by default. But when you apply indent, it follows the same process as you indent text.
Let’s apply indent to a number.
As you observed, it moved farther away from the right. This alignment is the same as when you applied indent to text 😀
If you want to move your content closer to the cell border, just click the decrease indent icon.
If there are multiple lines in the selected cells, all the lines will be indented together as indentation is applied to the entire cell.