How to Indent Down in Excel: Cells, Text, and Rows

In Excel, indentation moves cell content horizontally, usually to the right; it does not move text down within a cell. To indent, select the cell or range and choose Home > Alignment > Increase Indent. If you mean moving text lower inside a cell, use vertical alignment or add a line break instead. The steps below explain both, so you can choose the effect you want.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows. The ribbon commands are similar in current Excel for Mac and Excel for the web, though some dialog and menu labels differ.
The cell or cells whose contents you want to reposition. If you are unsure, try the change on one cell first.
For vertical positioning, enough row height to show the text where you want it. You can adjust row height after changing alignment.

Step-by-Step

Select the cell or range. Click one cell to indent its contents, or drag across a group of cells to apply the same alignment setting to all of them. To select non-adjacent cells, hold Ctrl while clicking each one on Windows. On a Mac, hold Command while selecting additional cells. Selecting a whole column or a very large range can affect many cells, so check the selection outline before changing anything.
Use Increase Indent for the usual left-to-right indent. On the ribbon, choose Home > Alignment > Increase Indent. The text or value shifts farther from the cell edge. If the button is not immediately visible, widen the Excel window or look in the Alignment group; a narrow window may compress ribbon controls. You can click Increase Indent more than once to add further indentation levels.
Check the result in the worksheet. The cell itself does not move, and the content is not pushed into a lower row. Only its horizontal position changes. If the content appears clipped, widen the column, turn on Wrap Text, or reduce the indent. An indent does not create extra space in adjacent cells and cannot make a column wider.
Reduce or remove the indent if needed. Keep the affected cells selected and choose Home > Alignment > Decrease Indent. Click it once to reduce the indent level by one step. Repeat as needed until the content returns to the position you want. This is a useful way to undo an indentation change without clearing the cell’s text or number format.
Set a specific indent amount through Format Cells. Select the cells, then open the Format Cells dialog. On Windows, press Ctrl+1, select the Alignment tab, and look under Horizontal. Choose Left (Indent), set the Indent value, then select OK. The number is an alignment level, not a measurement in pixels or a count of typed spaces. This dialog is helpful when you need a consistent indent across several cells or want to check the current setting.
If you mean lower on the sheet, put the content in a lower row. Indentation will not move a cell down. Select the row where you want space, right-click its row number, and choose Insert to add a blank row above it. Alternatively, select the cell and cut it with Ctrl+X, select the destination cell, and paste with Ctrl+V. On a Mac, use Command+X and Command+V. Check formulas and references after moving data, particularly if other cells depend on its original location.
If you mean lower inside the same cell, change vertical alignment. Select the cell, then choose Home > Alignment and select Align Bottom to place the content near the bottom edge. Choose Align Top or Middle Align for the other vertical positions. Increase the row height if there is not enough room to see a difference. Vertical alignment is separate from horizontal indentation, so you can combine the two.
For a new line within a cell, insert a line break. Double-click the cell or select it and press F2 to edit, place the cursor where the next line should start, and press Alt+Enter on Windows. On Mac, the line-break shortcut can vary with the keyboard and Excel version; try Control+Option+Return or use the Mac Excel edit command shown for your version. Turn on Home > Wrap Text if needed, then adjust the row height. This creates a second line; it does not create an indent.

In Excel for Mac, you can use the same Increase Indent and Decrease Indent controls on the Home ribbon. To open cell-formatting options, use Format > Cells from the menu bar and choose Alignment; the exact dialog layout can vary by release. In Excel for the web, select the cells and look for the indent controls on the Home ribbon. If the controls are unavailable in a compact ribbon, expand the ribbon or open the workbook in the desktop app.

Common Mistakes

Expecting Increase Indent to move content down. Despite the phrase “indent down,” Excel’s indent command changes horizontal alignment. It does not move text to a lower part of a cell or shift a worksheet entry into another row. Use Align Bottom for the first effect, or insert a row or move the cell for the second.

Using spaces to imitate an indent. Typing spaces before text may look acceptable at first, but the result can change with fonts, edits, sorting, or copying. Spaces are part of the cell’s contents, not an alignment setting. They can also interfere with matching text in formulas or other data tools. Use Increase Indent for a consistent visual offset without altering the underlying value.

Applying the command to the wrong selection. If several cells, an entire column, or a table is selected, the command affects all selected cells. Click a single cell and confirm the selection border if you only intended to change one item. If the wrong range was changed, press Ctrl+Z on Windows or Command+Z on Mac promptly to undo it.

Confusing indent with alignment or margins. Left, Center, and Right control horizontal alignment; Top, Middle, and Bottom control vertical alignment. Indent changes the horizontal offset, not a page margin or the cell’s size. If the text needs more room, adjust the column width or row height rather than repeatedly increasing its indent.

Assuming a line break is an indent. A line break makes a cell contain multiple display lines. An indent shifts content away from a cell edge. These can be combined, but they solve different layout problems. If a heading needs a second line, use a line break or Wrap Text; if a sub-item should sit farther right, use indentation.

Tips

Use indentation to show hierarchy in a list, such as placing subcategories slightly to the right of category names. Keep the number of indent levels consistent so readers can tell which entries belong together. For instance, if each subcategory is one level deeper than its parent, avoid giving some subcategories two levels unless they contain another level of detail.

Consider using a separate column for hierarchy when the worksheet is also used for filtering, sorting, or analysis. A visual indent is formatting; it does not tell Excel that one row is a child of another. A Category column and a Subcategory column preserve that meaning in the data and are usually easier to sort or summarize than a single column of indented labels.

For a clean layout, apply the indent after deciding on the column width and text wrapping. A long label with several indent levels may wrap onto multiple lines or appear cut off. You can widen the column by dragging the boundary between column letters, or double-click that boundary to AutoFit the column width to its contents. AutoFit may make the column wider than your preferred layout, so review the result.

When formatting many similar cells, select the full intended range and apply the same indent once rather than clicking cells one by one. If some cells need a different level, select those separately afterward. You can also copy formatting with Format Painter, but inspect the destination cells: it may copy more than indentation, including number formats, borders, and other formatting.

Remember that cell alignment affects appearance, not the stored value. A number with an indent remains the same number, and formulas continue to calculate as before. This makes indentation a safer choice than inserting leading spaces when you only want a visual outline. If you need the hierarchy to affect calculations or grouping, represent it in columns or use Excel’s grouping features rather than relying on indentation alone.

Troubleshooting

The text did not move. First confirm that you selected a cell and that the ribbon is showing the Home tab. Click Increase Indent again and check whether the cell is formatted in a way that changes how the offset appears. If you need precise control, open Format Cells with Ctrl+1, choose Alignment, and inspect the Horizontal and Indent settings. A very narrow column can make a small shift difficult to notice.

The text is clipped or disappears. The indent takes up display space inside the cell. Widen the column, reduce the indent with Decrease Indent, or enable Wrap Text. If wrapping creates extra lines, increase the row height or use Home > Format > AutoFit Row Height. Merged cells may not AutoFit as expected, so you may need to adjust their row height manually.

It moved sideways, but I wanted it lower. That is the expected behavior of Increase Indent. Select the cell and choose Align Bottom, Middle Align, or Align Top in the Home tab’s Alignment group. If the content still appears near the same place, increase the row height; vertical alignment is easiest to see when the cell has spare vertical space.

The whole row or column changed. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select only the intended cells and try again. If you have already made other changes, select the affected range and use Decrease Indent to correct its indentation without undoing unrelated work.

The ribbon button is missing or unavailable. Expand a collapsed ribbon, maximize the Excel window, or open the Alignment group’s additional options. In Excel for the web, some controls may be tucked into a compact toolbar. If a workbook is protected or opened with restricted editing, you may need permission to change formatting. Check whether the worksheet is protected before assuming the command has failed.

Frequently Asked Questions

How do I indent text one level in Excel?
Select the cell or range and choose Home > Alignment > Increase Indent. Click the command again for additional levels. Use Decrease Indent to step back.

Can I indent text downward in a cell?
Not with the indent command. Indent is horizontal. To position content lower in a cell, use Align Bottom and make the row tall enough to show the vertical spacing.

How do I indent a second line in the same cell?
Excel does not offer a separate paragraph-indent control for just one line in a cell. You can insert a line break and use spaces as a visual workaround, but spaces may be fragile. For structured text, consider splitting the information across cells or columns.

Is there a keyboard shortcut for Increase Indent?
Excel does not provide a standard single-key shortcut for Increase Indent. Use the Home ribbon command. Ctrl+1 on Windows opens Format Cells, where you can set the alignment and indent level. On Mac, use Format > Cells to reach the alignment options.

Will indenting change my data or formulas?
No. Indentation changes cell formatting, not the cell’s stored text, number, or formula. It can change how content is displayed, but it does not change a formula’s calculation or move the cell to another location.

Why can’t I see the indentation?
The column may be too narrow, the indent may be small, or the alignment may make the shift hard to distinguish. Widen the column, check the Horizontal and Indent settings in Format Cells, or reduce the indent if the content is being clipped.

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.