To indent cell content in Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, 6 in sequence. Each press increases the indent; use Alt, H, 5 to reduce it. You can also click Home > Alignment > Increase Indent. Indenting changes how content is positioned inside a cell; it does not add spaces to the cell’s value.
What You’ll Need
- Excel for Microsoft 365 on Windows for the Alt-key shortcut described below. The shortcut uses Excel’s ribbon key tips, not a three-key combination pressed all at once.
- A worksheet with the cells you want to format. You can select one cell, a range, or several nonadjacent cells before applying the setting.
- If you use Excel for Mac or Excel for the web, access to the Home ribbon. The Windows key-tip sequence is not the same across those versions, so their alternatives are covered below.
Step-by-Step
- Select the cells. Click a cell to indent just that cell. To apply the same formatting to a range, drag across it or click the first cell, hold Shift, and click the last. You can also hold Ctrl while selecting individual, nonadjacent cells on Windows. Check the selection before continuing: formatting a range changes every selected cell, including blank cells within it.
- Check the alignment. The indent setting works with cell alignment, so first consider which side the content should move away from. Text is often left-aligned, while numbers are commonly right-aligned. If the content is centered, the indent may not create the inward offset you expect. To choose an alignment, use the relevant alignment buttons in the Home tab’s Alignment group, then apply the indent.
- Use the Windows keyboard shortcut. With the cells selected, tap and release Alt, then tap H, then tap 6. Do not hold all three keys down together. Excel uses these ribbon key tips to run Increase Indent from the Home tab. Tap the sequence again to add another level. If the key tips displayed on your screen differ, follow the letters or numbers Excel shows; they can vary with language or interface configuration.
- Use the ribbon button if you prefer clicking. Keep the target cells selected, open the Home tab, and find the Alignment group. Click Increase Indent, represented by an icon with lines and an arrow pointing inward. Click again for additional indent levels. To reduce the indent, click Decrease Indent beside it. The command changes cell formatting and does not insert characters into the text.
- Set an exact indent level. For more control, open Format Cells. On Windows, press Ctrl+1; on a Mac, press Command+1, or choose Format > Cells. Open the Alignment tab, find the Indent setting, enter a level, and confirm with OK. This is useful when you need a known setting or want to return directly to zero instead of clicking Decrease Indent repeatedly.
- Check the result and apply it consistently. Look at the selected cells in the worksheet. The text should appear farther inside the cell from its aligned edge. If you are formatting a list, select the whole list and apply one level at once so the entries line up. If the content looks crowded or clipped, widen the column, enable Wrap Text from the Home tab, or adjust the indent rather than adding manual spaces.
In Excel for Mac, use the Increase Indent button on the Home ribbon or set the level through Format Cells; the Windows Alt, H, 6 sequence is not the Mac shortcut. In Excel for the web, select the cells and use Increase Indent on the Home ribbon. Ribbon placement can vary with window width, so expand the ribbon or look in the Alignment group if the button is not immediately visible.
Common Mistakes
- Pressing Alt+H+6 as one chord. Excel expects a sequence: press and release Alt, then H, then 6. Holding the keys together may not activate the command.
- Expecting the value to change. Indent is visual formatting. A formula still returns the same result, and copying the value elsewhere without its formatting will not carry the indent with it. Use actual spaces only when the spaces need to become part of the text, and bear in mind that this can affect sorting, matching, and calculations.
- Applying it to only the active cell by accident. When a range is selected, verify that the intended cells are highlighted. Clicking a single cell inside a list and using the shortcut formats only that cell.
- Using indent to fix a column that is too narrow. Indenting takes up room inside the cell and can make text harder to read or cause it to appear cut off. Adjust the column width or wrap the text if the issue is lack of space.
- Expecting the same movement for every alignment. Indent moves content inward from the aligned side. It does not create a paragraph-style margin independent of alignment, and centered content may not visibly move as expected.
- Confusing cell indent with a text-entry tab. Pressing Tab while editing or navigating a worksheet moves the selection; it is not a way to insert a tab or indent a line inside a cell.
Tips
- Use a small number of levels. One or two levels are usually enough to distinguish a subcategory from a main label. Too many levels consume space and make a table harder to scan.
- Indent labels, not necessarily every value. In a summary table, indenting subordinate row labels can show hierarchy while leaving the numeric columns aligned for easy comparison.
- Choose an alignment before adjusting the indent. For a label that should move in from the left edge, use left alignment and then increase indent. For a value positioned from the right, the indent is measured from that side.
- Use Format Cells for repeatable formatting. A specific Indent level is easier to reproduce across sheets than clicking Increase Indent an uncertain number of times. It also makes resetting to zero straightforward.
- Copy formatting when appropriate. If another cell already has the right alignment and indent, use Format Painter on the Home tab to copy its formatting. Check the destination afterward, especially if it contains formulas or different number formats.
- Keep the source data clean. For a worksheet that will be sorted, filtered, or used in formulas, prefer Excel’s cell formatting over leading spaces. Formatting preserves the underlying text or number while giving it a visual hierarchy.
Troubleshooting
The shortcut does nothing: Confirm that you are using Excel desktop on Windows and entering the keys one at a time. Tap Alt and look for the ribbon key tips; then follow the displayed sequence for the Home tab and Increase Indent. If your keyboard layout or Excel language shows different key tips, use those instead. You can always select the cell and click Increase Indent in the Home tab’s Alignment group.
The content moves the wrong way: Check the cell’s horizontal alignment. Indent moves content inward from its aligned edge, so right-aligned values move inward from the right, while left-aligned text moves inward from the left. Set the alignment you want before increasing the indent. If the content is centered, try left or right alignment first.
The indent is too large or too small: Use Decrease Indent on the Home ribbon to step back one level at a time. For an exact reset, open Format Cells, choose Alignment, and set Indent to 0. If the content still appears misplaced, check whether the cell has an unusual alignment setting or whether you selected more cells than intended.
The text is clipped or looks crowded: Indenting reduces the visible space available inside a cell. Widen the column by dragging its right boundary, use Home > Wrap Text to show long content on multiple lines, or reduce the indent level. If the row height does not expand after wrapping, adjust the row height or use AutoFit Row Height.
The ribbon button is missing or unavailable: Expand the Excel window or ribbon; a compact ribbon may hide commands inside a group menu. Make sure you are not editing text inside the cell, since some ribbon actions are unavailable while editing. Press Enter or Esc to finish editing, reselect the cell, and try again. If the worksheet is protected, formatting may be restricted; ask the workbook owner to allow cell formatting or unprotect the sheet if you have permission.
Mac or web instructions do not match: The Windows key-tip sequence is specific to the Windows desktop ribbon. On Mac or the web, use the visible Increase Indent command on the Home ribbon, or use Format Cells on Mac to set an exact level. If the ribbon is collapsed, expand it or use the app’s command search to locate the formatting command.
Frequently Asked Questions
What is the shortcut to indent a cell in Excel?
In Excel for Microsoft 365 on Windows, press and release Alt, then press H, then 6. This runs Increase Indent. Use Alt, H, then 5 to decrease the indent. On Mac or the web, use the ribbon button or the applicable Format Cells option instead.
Can I indent a cell by a specific amount?
Yes. Open Format Cells, select Alignment, and enter an indent level in the Indent box. The setting is expressed as a level rather than a measurement such as inches. You can set the level to 0 to remove the indent.
Can I indent just one line within a cell?
The cell’s indent setting applies to the cell’s content as a whole, not to an individual line. A line break inside a cell does not provide separate paragraph indents. If you need different visual positions, consider splitting the content across separate cells or using leading spaces only when those spaces are genuinely part of the text.
Does indenting change a number or formula?
No. It changes how the cell content is displayed, not the stored value or formula result. The indent may make a number look farther from the cell edge, but calculations still use the underlying number.
How do I remove an indent?
Select the affected cell or range and click Decrease Indent until it is back at the normal position. For a precise reset, open Format Cells > Alignment and set Indent to 0. Be sure the selection includes every cell you want to reset.
Can I indent multiple cells at once?
Yes. Select the range or nonadjacent cells first, then use Increase Indent or the Windows key-tip sequence. Excel applies the formatting to every selected cell. Confirm the selection carefully to avoid changing unrelated headings or values.
Related
- How to Find Duplicates in Excel and Review Them Safely
- How to Find Duplicate Lines in Excel Without Deleting Them
- How to Find Duplicate Data in Excel: Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets FILTER Function: Basics and ExamplesGoogle Sheets’ FILTER function returns only the rows or columns that meet conditions you specify, while leaving the…
- How to Highlight in Excel Using Keyboard ShortcutsTo highlight cells in Excel with a keyboard on Windows, select the cell or range, press Alt, H,…
- Excel Keyboard Shortcut for Next Sheet: Ctrl+Page DownIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next visible sheet in…
- Data Validation and Quality Assurance in ExcelIn Excel, data validation limits what people can enter in a cell, while quality assurance (QA) is the…
- How to Delete a Tab in Excel Without Losing Your DataTo delete a worksheet tab in Excel for Microsoft 365 on Windows, right-click the sheet tab at the…
- How to Copy Only Filtered Data in Excel Without Hidden RowsIn Excel for Microsoft 365 on Windows, apply your filter, select the range you want to copy, press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.