4 Easy Ways to Indent Text in Microsoft Excel

Download Article

Easily indent text in Excel cells with this user-friendly guide

Written by Rain Kengly

Last Updated: September 27, 2023

Download Article

Using Increase/Decrease Indent Button

|

Using the Format Cells Dialog Box

|

Using Wrap Text for Multiple Lines

|

Indenting Individual Text Lines in a Cell

Do you want to change your indent settings in Microsoft Excel? You can easily add space before text in a cell using the Increase/Decrease Indent button on the Home tab. You can also right-click the cells to launch the Format Cells window, where you'll find the option to manually adjust your indentation settings. This wikiHow will show you easy ways to indent text in cells in any Excel workbook.

Things You Should Know

To indent, select one or more cells, click Home , then click the Increase Indent icon.
You can also select the cells you want to edit, right-click the selection, and choose Format Cells… to manually input an Indent value.
If text extends past the cell, use Wrap Text in the Alignment section to shift into multiple lines within the cell.

Method 1

Method 1 of 4:

Using Increase/Decrease Indent Button

Download Article

1
Open a project in Microsoft Excel. If needed, you can begin a new Spreadsheet .
- Microsoft Excel is available on Windows and Mac. You can also use the online web version at the Microsoft 365 website .
The cells must contain the content you wish to indent. ^{[1]
X
Trustworthy Source
Microsoft Support
Technical support and product information from Microsoft.
Go to source}

Advertisement
This will open a new section of your toolbar.
4
Click the "Increase Indent" icon. This looks like lines of text with a blue right-facing arrow.
- The text in the selected cells will be indented to the right.
- You can continue clicking Increase Indent to indent the cells to your preference.
- To remove an indent space, click the Decrease Indent icon. This looks like lines of text with a blue left-facing arrow.
  - You can continue clicking Decrease Indent to position the cells to your preference.

Method 2

Method 2 of 4:

Using the Format Cells Dialog Box

Download Article

You can use Excel to make tables , type formulas , make graphs , and more.
The cells must contain the content you wish to indent.
3
Right-click the cells and click Format Cells… . This will be underneath Clear Contents .
- You can also use the keyboard shortcut CTRL + 1 (Windows) or CMD + 1 (Mac).
- A pop-up window will open.
4
Adjust the Indent settings. By default, the Indent will be 0. Click the up arrow next to the box to adjust your Indent to 1 or higher.
- You can also manually type the number into the Indent field.
This will be at the bottom-right corner of the window. Your cells will be indented.

Method 3

Method 3 of 4:

Using Wrap Text for Multiple Lines

Download Article

1
Open a project in Microsoft Excel. You can also create a new project.
- Use this method if your text extends beyond the right side of the cell.
You can select one or multiple cells.
This will open a new section of your toolbar.
4
Click the "Wrap Text" icon. This looks like a blue left-right arrow in the Alignment section.
- The text will shift into multiple lines within the selected cell.

Method 4

Method 4 of 4:

Indenting Individual Text Lines in a Cell

Download Article

You can use a new or existing project.
In most cases, this is a cell with text that extends into another cell.
This will open a new section of your toolbar.
4
Click the "Wrap Text" icon. This looks like a blue left-right arrow in the Alignment section.
- The text will shift into two lines within the selected cell.
This will separate the two lines of text.
7
Press the spacebar to input a manual indent. You can add as many spaces as you'd like. To delete additional spaces, use the backspace or delete key.
- Your cell is now indented.