By default, numbers are aligned to the right, and text values are aligned to the left in Excel.
In some cases, you may have a need to add a little bit of indent to the cell (so there is some space between the cell content and the cell border/grid.
There are multiple ways you can indent the content of the cell in Excel. you can use a simple keyboard shortcut or use the indentation option in the Ribbon (which allows you to indent with a single click).
In this tutorial, I will show you a couple of simple ways you can use to add indent in Excel.
Keyboard Shortcut to Indent Cells in Excel (Increase/Decrease Indent)
Let’s first have a look at the keyboard shortcut you can use to indent cell contents in Excel.
Keyboard shortcut to add indent to the left (increase indent):
ALT + H + 6
Keyboard shortcut to add indent to the right (decrease indent):
ALT + H + 5
You need to press these keys in succession, one after the other.
Important Things to Know about Indenting in Excel
- As you increase the indent of a number, it moves quickly to the left side of the cell. If you decrease the indent, it will move another step to the left side of the cell. As you increase the indent, the number will gradually move to the right side.
- If the cell’s number formatting is accounting, the currency sign will shift to the right (towards the number) when the indent is increased. When the currency sign and the number are sufficiently close to one another, increasing the indent will shift both the currency sign and the number to the right side.
- We cannot utilize the Excel indent shortcut to increase or reduce the indent of individual lines within the same cell.
Using the Indent Option in the Ribbon
You can also use the option in the Rxcel ribbon to quickly increase or decrease indent in Excel.
Below are the steps to do this:
- Select the cells for which you want to change the indent
- Click the Home tab
- In the Alignment group, click on the ‘Increase Indent’ or ‘Decrease Indent’ icon to apply the changes
When you click on the increase indent icon in the ribbon, it would add one indent unit to the cell content (which is approximately 3.5 millimeters of space on the left).
Similarly, if you click on the decrease indent icon, it will shift the cell content by approximately 3.5 millimeters to the right.
If you press any of these icons twice, it will add the indentation twice. You can continue to press these icons to add multiple units of indents to the same cell.
Using Format Cells Option to Apply Indent
Another way to indent cells in Excel is by using the Format Cells dialog box.
The benefit of using this method is that it allows you to specify the level of indent you want to add to the cell.
Below are the steps to add an indent in Excel using the ‘Format Cells’ dialog box:
- Select the cells in which you want to add the indent
- Click the Home tab
- In the Alignment group, click on the dialog box launcher (the small arrow icon at the bottom right part of the group)
- In the Formats Cells dialog box, make sure the Alignment tab is selected
- In the Horizontal drop-down, select Left (Indent)
- In the Indent field, enter the number of indents you want to apply (or use the spin button to increase or decrease the value)
- Click OK
The above steps would add the specified number of indents from the cells
Using Cell Styles to Apply Indent to Selected Cells
Another smart way to apply indent to cells in Excel is by creating a new cell style.
This method would be more suited if you have a few other formats that you also want to apply to these cells.
So instead of doing these manually one by one, you can create a cell style containing all the formats that need to be applied, and then apply all these formats with a single click.
Below are the steps to create a cell style that can indent the content of the cell as well:
- Click the Home tab
- In the Styles group, click on the Cell Styles icon
- In the options that show up, click on ‘New Cell Style’
- In the Style dialog box, enter a name for this style. Although this is optional, it’s better to name it for ease of use
- Click on the Format button
- In the Format Cells dialog box, click the Alignment tab (if it’s not activated already)
- Specify the Horizontal Indent alignment and value
- Click OK
- Click OK
The above steps would create a new cell style, and it would be available when you click on the cell styles icon (under the custom options).
As I mentioned, while this may not be the fastest way to indent cells in Excel, it is quite useful if you want to apply multiple formatting to the cells.
For example, if you want to change the number format to accounting or comma style, increase or decrease the decimal values, add a border and apply indent, then instead of doing this one by one, you can create a cell style and apply all these to the cell with a single click.
Note that the style that you create in one workbook, would only stay in that workbook. You won’t have access to it in any other workbook that you open on your system. However, you have an option to ‘Merge Styles’, where you can easily merge the styles of your current workbook with some other workbook on your system, and get the styles from that workbook.
Indent vs Adding Spaces
When you apply indent to a cell in Excel, it adds some space between the left border of the cell and the content of the cell.
Note that adding an indent to a cell is not equal to adding space characters on the left of the cell content.
When you add space characters before the cell content, you are changing the cell content by adding new characters to it.
Adding an indent to the cell is just like adding a little bit of padding so that the text shifts a little bit to the right. Doing this would not change the content of the cell.
In this tutorial, I showed you some easy ways to quickly add or remove indent from cells in Excel. The easiest way to do this would be by using a keyboard shortcut or using the icons in the ribbon.
And in case you need to apply multiple types of formatting to the cells, you can also try using the cell styles option, where you only need to specify the formatting once, and then it can be applied easily with a single click.
I hope you found this tutorial useful.
Other Excel shortcut articles you may also like:
- Excel Keyboard Shortcuts
- Apply Percentage Format (Shortcut)
- Merge or Unmerge Cells in Excel (Shortcut)
Other Excel tutorials you may also like:
- How to Remove Gridlines in Excel
- How to Remove Dotted Lines in Excel
- How to Add Bullet Points in Excel (7 Easy Ways)
- How to Press Enter in Excel and Stay in the Same Cell?
- How to Auto Format Formulas in Excel (3 Easy Ways)
- How to Clear Filter in Excel? Shortcut!
- Excel Shortcuts Not Working – Possible Reasons + How to Fix?