How to Indent in Excel: Cells, Lists and Shortcuts

To indent in Excel, select the cells and click Increase Indent on the Home tab. Each click moves the text a little further from the edge of the cell, and Decrease Indent moves it back. This guide shows the buttons, the keyboard shortcuts, exact indents in Format Cells, and how to indent sub-items in a list without typing spaces that break your formulas.

How to indent in Excel with the Increase Indent button#

The quickest way to indent is the pair of indent buttons in the Alignment group of the Home tab. They look like lines of text with a small arrow pointing right (increase) or left (decrease).

1. Select the cell or cells you want to indent.
2. Go to Home > Alignment.
3. Click Increase Indent once for each level you want.
4. Click Decrease Indent to move the text back.

Indent is a format, like bold or a border. It changes how the cell looks, not what it contains. If A3 holds "Salary" and you indent it twice, the cell still holds exactly "Salary", so =A3="Salary" is still TRUE.

You can select a whole block, such as all the sub-items in a budget, and indent them in one go. Indent works with other alignment formats too: you can combine it with wrapped text in a cell, but not with merged cells set to Center, because centred text has no left edge to indent from. If you have used Merge and Center, switch to Left alignment first.

Keyboard shortcuts to indent cells#

On Windows, use the ribbon key tips: press the keys one after another, not all at once.

Press Alt and you'll see letters appear on the ribbon. H opens the Home tab, and 6 or 5 clicks the indent button. Press the sequence again to add another level. Excel for Mac does not use ribbon key tips, so use the buttons or the Indent box in Format Cells. For more time-savers like these, see the strikethrough shortcut and other format keys.

How to set an exact indent in Format Cells#

Format Cells gives you full control: the exact indent level and the side to indent from. Use it when you want every level in a report to line up the same way.

1. Select the cells.
2. Press Ctrl+1 (Windows) or ⌘1 (Mac) to open Format Cells.
3. Click the Alignment tab.
4. Under Horizontal, choose Left (Indent), Right (Indent) or Distributed (Indent).
5. Type a number in the Indent box, such as 2, and click OK.

Each indent level is about the width of one character in the cell's font. Level 0 means no indent. Right (Indent) pushes text or numbers away from the right edge, which is useful for numbers, as you'll see below.

How to indent sub-items in a list#

To show a list with levels, put the main items at indent 0 and the sub-items at indent 1 or 2. A simple budget looks like this:

Select A3:A4 and A6:A7 together (hold Ctrl, or ⌘ on a Mac, while you select the second block), then click Increase Indent once. The headings stay at the edge and the details step in. Add borders under the totals and the structure is clear at a glance.

Because the labels are unchanged, formulas still match them. =SUMIF(A2:A7,"Rent",B2:B7) returns 1,900 whether Rent is indented or not.

How to indent text inside a cell#

To indent one line inside a cell, start a new line and type spaces in front of it. Indent formatting always moves the whole cell, so this is the only way to indent just part of it.

1. Double-click the cell, or press F2 (Windows) or ⌃U (Mac), to edit it.
2. Put the cursor where the new line should start.
3. Press Alt+Enter (Windows) or ⌃⌥Return (Mac) to start a new line.
4. Type a few spaces, then the text.

Excel turns on Wrap Text for the cell so the line break shows. This is fine for notes and comments. For data that you will filter, sort or look up, keep one value per cell and use indent formatting instead.

Why you shouldn't indent with spaces#

Typing spaces in front of a label looks like an indent, but it changes the value. " Salary" with four spaces is a different text from "Salary", so:

• =XLOOKUP("Salary",A2:A7,B2:B7) can't find it and returns #N/A.
• =COUNTIF(A2:A7,"Salary") returns 0.
• Sorting puts the spaced labels together at the top, away from their group.

You can spot spaces with LEN and TRIM. TRIM removes leading and trailing spaces, so this formula counts how many spaces a label starts with:

=LEN(A4)-LEN(TRIM(A4))

If A4 holds " Bonus" (eight spaces, then Bonus), the result is 13 − 5 = 8. To clean a whole column, put =TRIM(A2) in a helper column, fill it down, then copy it and paste it back as values. After that, re-apply the indent with the Increase Indent button.

There is one fair use for spaces: a display column built by a formula. If B3 holds a level number, =REPT(" ",B3*4)&A3 builds an indented label for a printed report, while column A keeps the clean name for formulas.

Indenting numbers and pivot table rows#

Numbers need a little care. When you click Increase Indent on a number, Excel switches it to left alignment, so the digits no longer line up on the right. To keep numbers right-aligned with a gap after them, open Format Cells, choose Right (Indent) and set the Indent box to 1. This keeps decimal places in line, which matters when you format numbers as currency or percent.

Pivot tables indent their own row labels. In the default Compact layout, each inner field steps in under the outer one. To change how far, right-click the pivot table, choose PivotTable Options, open Layout & Format, and change When in compact form indent row labels to the number of characters you want. To remove the steps entirely, go to the PivotTable Design tab (called Design in older versions) and choose Report Layout > Show in Tabular Form, which puts each field in its own column.

Practise it#

Indenting is quick once your hands know where the buttons are. Practise alignment and more formatting in a live spreadsheet: you format real cells and the page checks your work instantly. Then build speed with the formatting shortcuts lesson, and try the exercise on this page to find labels that were indented with spaces.