Excel Keyboard Shortcut to Indent Cells in a Worksheet

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. Press the keys in sequence—not all at once. The shortcut changes how cell contents are positioned, not the underlying values or formulas.

Use the Windows shortcut

Excel’s ribbon key tips provide the indent shortcuts. With a worksheet active, hold Alt and press H to display the Home tab key tips, then press 6 to increase the selected cells’ indent. To reduce it, press Alt, then H, then 5. You can think of each sequence as a quick way to reach the corresponding command on the Home tab.

First select the cells you want to format. The shortcut works on one cell, a contiguous range, or multiple selected cells. For example, to indent the labels in A2:A6, select A2:A6 and use Alt+H, 6. Excel applies the formatting to each selected cell; it does not insert spaces into the cell values.

Increase indent: Alt, H, 6.
Decrease indent: Alt, H, 5.
Repeat: Run the increase command again to add another indent level, or repeat the decrease command to remove one.

The commas in shortcut references indicate a sequence. Do not hold Alt, H, and 6 down together as though they were a three-key chord. Also, use the number keys for the key tips after opening the ribbon sequence; if your Excel interface uses a different display language or customized ribbon, the key-tip letters or numbers may differ.

Apply indent from the ribbon or dialog

If you do not want to use key tips, select the cells and go to Home > Alignment > Increase Indent. Click the button again for a deeper indent. Use Home > Alignment > Decrease Indent to move the contents back toward the cell edge. The buttons are useful when you need to identify the command visually or when a keyboard shortcut is unavailable.

For a specific alignment setting, open the Format Cells dialog with Ctrl+1 on Windows, choose the Alignment tab, and adjust the Horizontal and Indent controls. The horizontal alignment choice determines which side of the cell the indentation is measured from. This dialog is also useful when you want to inspect or set a particular indent level rather than change it one step at a time.

Indent is a cell-formatting property, so you can apply it before or after entering data. It can also be included in a cell style or copied with formatting. If you copy a formatted cell and want only its value in another location, use a paste option that pastes values rather than all formatting; otherwise, the indent may come along with the copied format.

What indentation changes

Indentation creates visual space between a cell’s contents and its edge. It is handy for showing that one label sits beneath another in a report—for example, indenting “Hardware” and “Software” beneath “Expenses.” It can make a table easier to scan without adding leading spaces or changing the text itself.

The displayed direction depends on horizontal alignment. Left-aligned text is moved inward from the left edge. Right-aligned content is moved inward from the right edge. As a result, increasing indent does not always mean that every value appears farther to the right: a right-aligned number may move left, toward the middle of its cell. Centered content is not a good choice when you want a clear left-to-right hierarchy; set it to left or right alignment first if the direction matters.

Indentation does not create a true parent-child relationship between rows, and it does not group, hide, or sort data. It also does not alter a formula’s result, a number’s stored value, or the text in the formula bar. The difference is visual formatting, much like changing horizontal alignment or applying a number format.

Choose indent, spaces, or another layout tool

Use cell indentation when you want a simple, consistent visual offset that remains separate from the data. Inserting spaces at the start of a text value changes the actual content. That can affect exact-match lookups, sorting, comparisons, and exports, and the apparent spacing may vary with the font. Indent formatting avoids those problems because the value remains unchanged.

Indent is not a substitute for every layout feature. Choose the tool that matches the job:

Indent: Add a visual offset within the cell while keeping the value intact.
Wrap Text: Show long content on multiple lines within the cell; it controls line wrapping, not hierarchy.
Increase column width: Give all cells in a column more room, rather than offsetting selected contents.
Outline or grouping: Organize rows or columns that readers should be able to expand and collapse. Indenting labels alone does not provide that behavior.
Leading spaces: Use only when spaces are genuinely part of the text data, not merely to make a report look indented.

For example, a budget can show “Travel” and “Supplies” visually nested under “Operating costs” by indenting those labels. If readers must collapse the detail rows under “Operating costs,” use Excel’s grouping tools as well; indent formatting by itself cannot hide or reveal rows.

Common shortcut problems

If Alt+H, 6 appears to do nothing, check whether Excel is waiting for the next key tip. Press Alt, then H, and look at the ribbon before pressing 6. If you press the keys simultaneously, Excel may interpret them differently. On some keyboards, the number-row key is easier to use for key tips than a numeric keypad key.

Confirm the selection: The intended cell or range must be selected. If you are editing text inside a cell, finish editing with Enter or cancel with Esc, then select the cell and run the shortcut.
Check horizontal alignment: A right-aligned number shifts inward from the right side, which can look like it moved in the unexpected direction.
Inspect the result at the cell edge: A narrow column, long text, or adjacent content can make an indent difficult to notice. Widen the column temporarily or use the ribbon button to confirm the formatting change.
Undo if needed: Ctrl+Z reverses a recent formatting change in Excel for Windows. You can also use Decrease Indent to remove a level, though Undo is preferable if you need to reverse the exact last action.

If the command works but the content still seems crowded, indentation may not be the real issue. Try Wrap Text for long labels, adjust the column width, or review the horizontal alignment. Indenting a long entry takes away display space rather than creating more room, so it can make clipping more noticeable.

Excel for Mac and Excel for the web

The Windows Alt+H key-tip sequence is not the Mac shortcut. In Excel for Mac, the indent shortcuts are Control+Option+Tab to increase indent and Control+Option+Shift+Tab to decrease it. Keyboard behavior can depend on macOS settings and the keyboard layout, so if a combination is intercepted by the system, use the Home tab’s Increase Indent or Decrease Indent button instead.

Excel for the web runs in a browser, where keyboard combinations can be affected by browser behavior and the web version’s ribbon key tips. The dependable alternative is to select the cells and choose the indent button on the Home tab. The formatting result is still a cell indent; it does not add spaces to the data. When switching among Windows, Mac, and web versions, use the visible command if the desktop shortcut sequence is not recognized.

Frequently Asked Questions

What is the Excel shortcut to indent a cell?
In Excel for Microsoft 365 on Windows, press Alt, H, then 6 to increase the indent. Press Alt, H, then 5 to decrease it. These are sequential key-tip presses.

How do I indent multiple cells at once?
Select the range or individual cells first, then use the increase- or decrease-indent shortcut. Excel applies the formatting to every selected cell, without changing their contents.

Can I indent text in Excel without changing the cell value?
Yes. Use Increase Indent or the Alignment controls in Format Cells. Indentation changes the display format, whereas typing spaces into the cell changes its actual text.

Why does increasing indent move a number left?
Numbers are commonly right-aligned by default. Indenting right-aligned content moves it inward from the right edge, which is toward the left. Change the horizontal alignment if you want the indent to start from the left.

How do I remove an indent in Excel?
Use Alt, H, then 5 on Windows, or click Home > Alignment > Decrease Indent. Repeat as needed to remove additional levels. Ctrl+Z can reverse the last action if you have just applied it.

Does indenting a cell add spaces to its text?
No. It changes the cell’s alignment formatting only. The underlying text, number, or formula remains the same, so indentation does not create a data hierarchy or affect calculations.

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.