See all How-To Articles

How to Indent (or Increase Indent) in Excel & Google Sheets

This tutorial demonstrates how to increase and decrease indentation in Excel and Google Sheets.

 

excel increase cell indent 2

 

Indent Cells

Using Excel’s alignment options, you can adjust the text indent in the cell. You can move the text from the cell border to the left or the right. For example, you can move the text in cell A1 a bit from the left border.

  1. Select a text cell (A1).
  2. In the Ribbon, go to the Home tab.
  3. In the Alignment group, choose Increase Indent.

 

excel increase cell indent 1a

 

As a result, the text in cell A1 is moved a bit from the left border.

 

excel increase cell indent 2

 

If you want to increase indent, click the Indent Increase icon several times. If you click three more times, for example, the text is moved farther from the left border, as shown below.

 

excel increase cell indent 3

 

Decrease Indent

  1. To decrease indent and move text back to the left border, select the cell again.
  2. In the Ribbon, go to the Home tab.
  3. Click Decrease Indent. If you increased the indent several times, you’d have to decrease it several times to get back to the left border.

 

excel increase cell indent 4

 

Note: You can also use VBA code to change the alignment of a cell.

Indent Cells in Google Sheets

Unfortunately, in Google Sheets, you don’t have an option to indent cells, but you can use the custom number format as a workaround. To do this, follow the next steps.

1. (1) Select a cell that you want to indent, and in the menu, (2) go to Format > Number > Custom number format.

 

google sheets increase cell indent 1a

 

2. In the format box enter as many spaces as you need (in this example 5 spaces), type @, and click Apply.

 

google sheets increase cell indent 2a

 

As a result, the cell now has an indent.

 

google sheets increase cell indent 3a