How to Indent in Excel: Cell Contents, Rows and Wrapped Lines

Quick answer

Excel indents the contents of a whole cell, not an individual line inside it. Select the cells and click Increase Indent in the Alignment group on the Home tab; each click steps the contents further from the cell edge, and Decrease Indent steps them back. For an exact amount, press Ctrl+1, open the Alignment tab, set Horizontal to Left (Indent) and type a number in the Indent box. Microsoft’s guidance is to indent this way rather than by typing spaces¹.

Indenting is how a flat column of labels turns into something readable — categories flush left, items stepped in under them. The confusion that sends most people searching is that Excel has no indent key the way a word processor does, and the button only ever moves the whole cell.

The two indent buttons

Both live on the Home tab, in the Alignment group, next to the alignment controls.

1. Select the cell or range.
2. Click Increase Indent to move the contents in one step.
3. Click it again for each further step.
4. Decrease Indent reverses one step at a time, down to zero.

The indent is part of the cell’s formatting, not its value. The cell still contains Widgets, not    Widgets, so sorting, filtering, VLOOKUP and every text formula behave exactly as they did before. That is the whole point of using the command instead of the space bar.

The keyboard route, and the shortcut that does not exist

Excel has no dedicated indent shortcut. Word has Ctrl+M; Excel has no equivalent, and Microsoft’s keyboard shortcuts reference lists none². What you use instead is the ribbon’s own Key Tips.

Press Alt and Excel overlays a letter or number on every ribbon control — Microsoft calls these Key Tips². Press H for the Home tab and the Alignment group labels its two indent buttons; on current Windows builds that is 6 to increase and 5 to decrease, giving the sequence Alt, H, 6. Because the letters are drawn on screen, you never have to remember them: press Alt, look, and read the key off the button.

Read carefully

Key Tips are a navigation sequence, not a chord. Press and release Alt, then H, then 6 — holding all three together does nothing. This is also why the digits can differ on a customised ribbon: they describe the button’s current position, not a fixed binding.

Format Cells, when you need an exact indent

The buttons move in fixed steps. To set a precise value, or to indent from the right, press Ctrl+1 to open Format Cells² and go to the Alignment tab. The Indent box only becomes available for certain horizontal alignments.

Horizontal setting	Indent box	What the indent does
Left (Indent)	Available	Pushes contents right, away from the left edge
Right (Indent)	Available	Pulls contents left, away from the right edge
Distributed (Indent)	Available	Spreads the text across the cell, inset from both edges
General, Center, Fill, Justify	Greyed out	No indent is possible in these modes

One unit of indent is based on the width of one character in the default Normal style³, so the visible distance changes if you change the workbook’s font. If an indent looks wrong after a font change, that is why.

Indenting rows to show a hierarchy

A common use is a report where headings sit flush left and detail rows step in beneath them. Apply indent 0 to the heading rows and indent 1 or 2 to the rows under each, all in the same label column.

Worth knowing before you build a sheet this way: the indent is decoration. It does not group anything, it does not collapse, and no formula can read it. If you need rows that actually fold away, use Data → Outline → Group, or let Excel build the structure for you with automatic subtotals, which indents and groups at the same time.

The second line of a wrapped cell

This is the request Excel cannot grant. Indent applies to the cell, so every wrapped line moves together; there is no hanging indent and no per-line control.

The usual workaround is to break the line yourself with Alt+Enter and type spaces at the start of the new line. It looks right, and it comes with a real cost: those spaces are characters in the cell’s value. They travel into lookups, comparisons and sorts, and leading or trailing spaces are exactly what Microsoft warns against¹. Use it only in cells that are purely for display, and if such a cell later has to be matched against anything, strip the padding with TRIM first — the same clean-up that text formulas like extracting the first and last word depend on.

Where the layout genuinely matters more than the data, a text box floating over the sheet gives full paragraph control and stays out of the grid entirely.

What quietly removes an indent

• Format Painter carries the indent along with the rest of the formatting, so brushing a non-indented cell over an indented one flattens it.
• Paste Special → Values keeps the text and drops the indent, because the indent was never part of the value.
• Home → Clear → Clear Formats resets it to zero along with everything else.
• Applying a table style or a different cell style can reset horizontal alignment to General, which disables the indent entirely.

All four are the same fact seen from different angles: an indent is formatting, and anything that replaces a cell’s formatting replaces its indent. The same logic governs hiding cell content with a custom number format, which survives or vanishes under exactly the same operations.

Related

• Automatic subtotals, which indent and group together
• Format Painter in Excel
• How to hide cell content in Excel
• Get the first and last word from a string

Sources