Excel Indent Shortcut: Increase or Decrease Cell Indent

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, 6 to increase the indent; press Alt, H, 5 to decrease it. These are sequential key presses, not keys held down together: press Alt, release it, then press H and 6 or 5.

The Windows Excel indent shortcuts

The shortcuts use Excel’s ribbon Key Tips to reach the indentation commands on the Home tab. They work on selected cells, including a multi-cell selection. The number keys are the top-row numbers, and the sequence can be used again to add or remove another increment.

  • Increase indent: Alt, H, 6.
  • Decrease indent: Alt, H, 5.

If a sequence does not work, press Alt and look at the letters and numbers displayed on your ribbon. Key Tips can vary with the version, language, or ribbon configuration. Follow the displayed tips to reach the Increase Indent or Decrease Indent command rather than assuming a key sequence is identical in every localized Excel installation.

What the indent command changes

Indent changes the horizontal position of a cell’s displayed content within that cell. Increasing the indent adds space before the content; decreasing it removes one increment. It changes alignment formatting, not the value itself. A number remains a number, and text remains text, so formulas that refer to the cell continue to use its original value.

For example, if A2 contains the text “North region,” increasing its indent moves the displayed text to the right inside A2. It does not insert spaces into the text, change the contents visible in the formula bar, or move the text into column B. Similarly, indenting a currency value does not alter the amount used in a total.

The indent amount is a formatting step, not a measurement that always equals a fixed number of pixels or spaces. Its visible size depends on the font and the available cell width. Repeating Increase Indent adds further steps, but the content can eventually run out of room or appear clipped if the cell is narrow and text wrapping is off.

Use the ribbon if you prefer not to use a shortcut

The ribbon provides the same controls and is useful when you do not remember the Key Tip sequence, are using a different keyboard layout, or want to confirm the command before applying it.

  1. Select the cell or range whose content you want to reposition.
  2. Open the Home tab.
  3. In the Alignment group, choose Increase Indent or Decrease Indent.

The commands are usually shown as small alignment icons with arrows. If the ribbon is collapsed or the Excel window is narrow, the Alignment controls may be compressed into a smaller group. Expand the ribbon or widen the window to locate them. You can also point to a ribbon control to see its tooltip and verify its command name.

Indenting one cell, a range, or a whole column

The shortcut acts on the current selection, so select the intended cells before pressing it. To indent one cell, click it. To indent a contiguous range, drag across the cells or select the first cell, hold Shift, and select the last. For nonadjacent cells, hold Ctrl while selecting additional cells, then apply the command once to the combined selection.

You can also select a column by clicking its letter at the top of the worksheet, or select a row by clicking its number. Applying an indent to a broad selection is quick, but check first whether every cell should have the same alignment. An entire column may include headings, data, and blank cells that are meant to be formatted differently. Formatting blank cells is not harmful, but it can affect how new entries appear later.

When the selected cells have different indent levels, Increase Indent adds a step to each selected cell and Decrease Indent removes a step where one exists. If a cell is already at the minimum indent, decreasing it cannot move the content farther left than its normal alignment position.

Excel for Mac and Excel for the web

The Windows sequence Alt, H, 6 or Alt, H, 5 is not the Mac shortcut. On Excel for Mac, select the cells, open the Home tab, and use Increase Indent or Decrease Indent in the Alignment controls. Ribbon layout and available keyboard options can differ by Mac version, so use the visible command if a Windows instruction does not match your screen.

Excel for the web also has alignment controls on the Home ribbon. The Windows desktop Key Tip sequence may not behave the same way in a browser, partly because browser and operating-system shortcuts can take precedence. If it fails in the web app, select the cells and use the ribbon buttons instead. The result is cell formatting, so a workbook saved after the change retains that formatting when opened in another supported Excel version.

Indent is not the same as spaces, tabs, or alignment

Indent is often a better choice than adding spaces to the beginning of text. Spaces become part of the cell’s actual content, can make sorting or matching text less reliable, and may display inconsistently with different fonts. Indent keeps the underlying value intact while changing its appearance.

It is also distinct from horizontal alignment. Left, Center, and Right alignment determine how content is positioned across the cell; indent adds an offset to the alignment. For instance, left-aligned text can be pushed inward with Increase Indent. Indent does not create a hierarchy in the data, add outline levels, or group rows. If your goal is to show expandable and collapsible detail rows, use Excel’s outlining or grouping features instead.

For visual hierarchy within a list, indentation can still be useful. A worksheet might show a main category such as “Operating costs” and slightly indent related labels such as “Travel” and “Supplies.” The values remain ordinary cell entries; the visual relationship is for readers, not a structural relationship Excel automatically understands.

How indent interacts with wrapping and column width

Indent uses space inside the cell, reducing the room available for the displayed content. If a long label appears cut off after you increase its indent, try widening the column, reducing the indent, or turning on Wrap Text from Home > Alignment. With wrapping enabled, text can continue on additional lines within the cell, though you may need to adjust the row height if the full content is not visible.

Indent does not change column width or row height by itself. It also does not make adjacent cells empty. In a worksheet, text that appears to extend into the next blank cell may stop at the next occupied cell; an indent can make that text fit less comfortably even when the column’s width has not changed. Check the actual cell value and layout before concluding that Excel removed or altered text.

For a table of numeric data, consider whether indentation is the right visual tool. Right alignment is commonly used for numbers because it makes digits and decimal places easier to compare. Indenting a number can be appropriate for a particular layout, but it may make a column of figures harder to scan.

Common shortcut problems and fixes

  • Nothing happens: Confirm that a worksheet cell is selected and that you are pressing the keys in sequence. Press Alt, release it, then follow the ribbon Key Tips. If you are in Excel for Mac or a browser, use the ribbon control.
  • The wrong command runs: Key Tips can differ across languages or ribbon configurations. Press Alt and follow the labels shown on your own screen instead of relying on a sequence from another version.
  • The content seems unchanged: The indent may be subtle, especially with a wide cell or a small font. Try one more increase step, check the Alignment controls, or compare the cell with an unindented cell.
  • Text is clipped: Reduce the indent, widen the column, or use Wrap Text. Indenting does not automatically expand the cell.
  • Only some cells change: Check the selection and inspect whether the cells have different alignment settings. Select the intended range again before applying the command.

Undo is available immediately after a formatting change with Ctrl+Z on Windows. On Mac, use Command+Z. Undo can also reverse other recent actions, so check the worksheet after using it. If you have made several subsequent edits, you may need to use the ribbon command to correct just the indent rather than undoing a longer series of changes.

Frequently Asked Questions

What is the Excel shortcut to increase indent?
In Excel for Microsoft 365 on Windows, press Alt, release it, then press H and 6 in sequence. This increases the indent of the selected cell or cells.

What is the shortcut to decrease indent in Excel?
On Windows, use Alt, H, 5 as sequential key presses. It removes an indent step from the selected cells. You can also choose Decrease Indent on the Home tab.

Does indent add spaces to the cell value?
No. Indent changes the cell’s alignment formatting, not its stored text or number. That is why it is usually preferable to typing leading spaces when the goal is only to adjust the display.

How do I indent in Excel on a Mac?
Select the cell or range, then use Increase Indent or Decrease Indent on the Home tab in the Alignment controls. The Windows Alt, H, 6 and Alt, H, 5 sequences do not apply to Mac.

Why is my indented text cut off?
Indent takes up space within the cell, and Excel does not automatically widen the column. Reduce the indent, widen the column, or enable Wrap Text and adjust the row height if necessary.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.