How to Indent the Contents of a Cell or Set of Cells
If your spreadsheet has text elements, adding indents might help readability.
Select the cell or cells containing the content you want to indent. Go to the Home tab. In the Alignment section, select Increase Indent. The icon has four horizontal lines and a right-facing arrow. The text in the selected cells is indented. To add more indentation space, select Increase Indent again. To remove the indentation space, select the cells and then select Decrease Indent. This icon has four horizontal lines with a left-facing arrow.
How to Indent Individual Selections Within a Cell
If your text is too long to fit in a cell, wrap the text to the next line. However, if you want to indent the next line, you cannot use the Increase Indent feature. There’s an easy workaround. Here’s how it works:
Select the cell containing the text that’s too long. Go to the Home tab and, in the Alignment section, select Wrap Text. The text extends to two lines. Select the text in the cell before the second line of text and press Alt+Enter on a PC or Option+Return on a Mac. Press the spacebar a few times to add a manual indent to the second line of text. Adjust to your preferences.
