How to Indent in Excel (3 Easy Ways + Shortcut)

Indenting text in Excel increases the readability of lists and assists with breaking large amounts of data into sections, making it easier for you to decipher. Excel provides a few methods for indenting text.

Let’s delve into the Excel world of indenting text!

Using the Tools in the Alignment Group to Indent in Excel

1. Highlight the cell(s) that you want to indent.

2. Click the Increase Indent button in the Alignment Group.

3. The list of apples is indented in the cell.

Using the Format Cells Dialog Box to Indent in Excel

1. Select the cell(s) that you want to indent.

2. Click the Dialog Box Launcher in the Alignment Group.

3. The Format Cells Dialog Box appears.

4. The Format Cells Dialog Box has many options for indenting text, including Left, Right, or Distributed, and you control the amount of indentation by increasing the Indent options, which go up to a maximum of 250.

5. The following example shows the three types of indentation as well as one group of cells with no indent applied.

You can then copy the formatting of these cells to not do it again manually after pasting.

Using Keyboard Shortcuts to Indent in Excel

1. Select the cells that you want indented.

2. Press ALT + H + 6 on the keyboard, one key after the other to indent the text by one space. You can repeatedly use this shortcut if you choose to indent your text more than one space.

Multiple Lines of Text to Indent in Excel

Note: The following steps might not work correctly if you are using an Excel version older than Excel 365.

1. Highlight the cells or the range of cells.

2. Press the Increase Indent button in the Alignment Group to indent the text.

Conclusion

This short tutorial provided a few techniques for indenting text in Excel. Now, formatting individual cells or even multiple lines of text in one cell is a breeze.