To add space before cell contents in Excel, select the cell or range, then choose Home > Increase Indent in the Alignment group. This indents the contents horizontally; it does not move them down the cell. If you mean downward spacing, use Home > Bottom Align instead. The steps below explain both so you can choose the result you need.
Indent changes how Excel displays a cell’s contents, not the value stored in the cell. It is useful for making labels, subtotals, and levels in a list easier to distinguish without inserting spaces into the data.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- The cell or range whose contents you want to position. You can select one cell, several cells, or a whole column.
- A little room in the column. Indented text uses some of the available display space, so a narrow column may clip it or show #### for some numeric formats.
You do not need to type leading spaces or change the underlying values. The Increase Indent button applies a cell-formatting setting.
Step-by-Step
- Select the cell or cells. Click a single cell to indent one entry. To format several entries consistently, drag over the range or click the first cell and use Shift-click on the last. You can also click a column letter to select the whole column, but use that option only if you want the indentation applied to every relevant cell in it. Selecting a range first makes the change uniform and avoids repeating the command cell by cell.
- Open the Home tab. On the Excel ribbon, select Home. Find the Alignment group, which also contains options such as Wrap Text, horizontal alignment, and vertical alignment. If the ribbon is collapsed or the Excel window is narrow, the controls may be compacted into icons or a menu; maximize the window or expand the ribbon if you cannot see the group.
- Choose Increase Indent. In the Alignment group, click Increase Indent, the indent-increase control shown with lines and an arrow pointing inward. Excel moves the cell contents inward by one indent increment. The control may be presented as an icon without a text label; hover over it to see its name. Do not confuse it with Increase Font Size or the horizontal alignment buttons.
- Check the position and repeat if needed. Look at the selected cells. If the text needs more inset, click Increase Indent again. Each click adds another increment; it is not a command to add a specific number of spaces. Stop when the text is easy to read and the column still has enough room. If you have gone too far, click Decrease Indent in the same group to undo one level at a time.
- Set alignment if the result looks unexpected. Indentation is easiest to read with left-aligned text. If the contents are right-aligned, Excel positions the inset relative to the right side instead, which may not look like a left margin. To make a label indent from the left, select the cells and choose Home > Align Left, then use Increase Indent. For numbers, consider whether preserving right alignment is more important than making their left edges line up.
- Adjust the column width or wrapping. An indent takes up visible space, so a long entry may appear cut off or wrap. Drag the boundary to the right of the column letter to widen the column, or use Home > Wrap Text to show long contents on multiple lines. If the row does not expand to show wrapped text, use Home > Format > AutoFit Row Height. Check that the added line height does not make the sheet harder to scan.
- For a specific indent amount, open Format Cells. On Windows, select the cells and press Ctrl+1, then choose the Alignment tab. Under Horizontal, select an appropriate alignment such as Left, and set the Indent value. Select OK to apply it. This gives you a numeric setting rather than repeated clicks on Increase Indent. The displayed result still depends on the cell’s width and alignment.
- If you meant move the text down, use vertical alignment. Select the cell or range and choose Home > Bottom Align in the Alignment group. This positions contents near the bottom edge of the cell, rather than adding a left-side indent. To create visible room below the text, increase the row height by dragging the row boundary. You can combine Bottom Align with a horizontal indent if you want the content both inset and low in a taller cell.
- Review the sheet and save your work. Check a few cells at normal zoom and confirm headings, numbers, and formulas remain readable. Indenting does not change a formula or the value used in calculations, but it can make entries less visible in a crowded layout. Save the workbook after you are satisfied with the formatting.
In Excel for Mac, select the cells and use the Home tab’s Alignment controls, including Increase Indent and Decrease Indent. The ribbon layout can differ slightly by Excel version and window size. The Format Cells dialog is commonly opened with Command+1 on Mac; use its Alignment tab to set an indent amount. Excel for the web also provides alignment controls on the Home tab, although some dialog options and their layout may differ from the desktop app.
Common Mistakes
Expecting Indent to move content vertically. Increase Indent changes horizontal positioning. For text near the bottom of a cell, use Bottom Align; for more space around a row, adjust its height. Keeping these separate prevents repeated clicks on the wrong control.
Typing spaces before the value. Leading spaces are part of the cell’s contents, whereas an indent is formatting. Spaces can cause inconsistent alignment, affect text comparisons, and need to be removed individually. Use the ribbon control for a visual inset while keeping the actual entry clean.
Applying several indent levels without checking the column. Each click reduces the room available for the visible contents. Long labels may be clipped, and some number formats may show #### when the column cannot display them. Widen the column or use a smaller indent rather than assuming Excel will make more space automatically.
Leaving mixed alignment in a range. The indent can appear to move in different directions when some cells are left-aligned and others are right-aligned. Standardize alignment where a consistent visual hierarchy matters. For numeric tables, preserve a layout that makes digits easy to compare rather than forcing every value to the same side.
Assuming formatting changes the data. Indent does not add characters to a text value or alter a number used by a formula. It may change the visible layout, but it does not create a new level in the data itself. If you need a structured hierarchy for sorting or analysis, store that information in a separate column.
Tips
- Use a small number of indent levels to show a clear hierarchy, such as a section label followed by indented subitems. A consistent pattern is easier to scan than a different amount of inset on every row.
- Apply indentation to a selected range at once when all entries play the same role. If only some rows are subitems, select those rows rather than indenting the entire column.
- Use a separate column for a genuine category or outline level when the information needs to be filtered, sorted, or analyzed. Indent is a visual cue, not a substitute for structured data.
- Use decrease indent instead of clearing all formatting if you only need to back up one step. If you want to remove other formatting too, use Clear Formats carefully, since it resets more than indentation.
- For titles and labels, test the result at the zoom level people will use. A small inset that looks obvious at high zoom may be hard to notice when the worksheet is displayed smaller.
- If the cell contains wrapped text, inspect the full cell rather than just its first line. Indentation and wrapping together can make a long entry take more row height, so adjust the column and row sizes as a pair.
Troubleshooting
The text does not appear to move. Confirm that the intended cells are selected and that you clicked Increase Indent rather than an alignment or font control. Look at the formula bar to verify that you are formatting the correct cell. If the contents are centered or right-aligned, try Align Left for a label and click Increase Indent again. The change can also be subtle at low zoom, so inspect the cell more closely.
The text is still too close to the top. That is a vertical-position issue, not an indent issue. Select the cell and use Home > Bottom Align. If the row is too short for the appearance you want, drag its lower boundary downward or use Home > Format > Row Height to enter a height. A cell’s vertical alignment is easier to judge when the row is taller than its contents.
Some entries are cut off or show ####. Increase the column width, reduce the indent, or adjust the number format if appropriate. #### usually means Excel cannot display a formatted number in the available width, rather than that the value has been erased. For text, a neighboring filled cell can also prevent overflow, so widening the column or wrapping the text may help.
The button is missing or unavailable. Expand the ribbon, widen the Excel window, or look for the compact Alignment menu on the Home tab. If the worksheet is protected, formatting changes may be restricted; check Review > Unprotect Sheet if you have permission and the required password. In a shared or web workbook, the available controls can also depend on editing permissions.
The indentation seems inconsistent across a selection. Check whether the cells have different horizontal alignments, number formats, or existing indent levels. Use Format Cells to inspect the Alignment settings, or apply a common alignment and indent to the selected range. Merged cells can also make spacing harder to interpret; unmerge them where practical or test the formatting on one cell first.
Frequently Asked Questions
Does Increase Indent add spaces to the cell?
No. It changes the cell’s formatting, not the stored text. The value remains available to formulas and other workbook operations without extra leading space characters.
Can I indent several cells at once?
Yes. Select a contiguous range, nonadjacent cells with Ctrl-click on Windows, or the relevant rows, then click Increase Indent. Excel applies the command to the selected cells. On Mac, use Command-click to add nonadjacent cells to a selection.
How do I remove an indent?
Select the affected cells and click Home > Decrease Indent until the contents return to the position you want. This reduces the indent without removing unrelated formatting.
Can I use indent to move text down inside a cell?
No. Increase Indent moves contents horizontally. Use Home > Bottom Align to position contents at the bottom of a taller cell, and change the row height if you need more vertical room.
Will indentation change formulas or sorting?
Indent is a display-formatting setting. It does not change a formula’s result or the underlying value used for sorting. However, indent alone does not identify a hierarchy to Excel; use a separate data field if you need to sort or filter by level.
Related
- How to Rename an Excel File in Windows 11 Using Explorer
- Rename an Excel File on Windows 10: Step-by-Step
- How to Rename an Excel File While It’s Open
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Power Query Text to Columns: Split Data Step by StepTo split text into separate columns in Power Query, select the column in Power Query Editor, then choose…
- Remove Page Break Numbers in ExcelTo remove the large page-break numbers in Excel, switch from Page Break Preview to View > Normal. The…
- Indent Within the Same Cell in Excel: Step-by-StepTo indent only one line within an Excel cell, insert a line break with Alt+Enter on Windows, then…
- Google Sheets and ChatGPT: How to Use ThemYes—you can use ChatGPT with Google Sheets, but ChatGPT is not the same thing as a built-in Sheets…
- Google Sheets Wrap Text Shortcut and Menu OptionsIn Google Sheets, use Format > Wrapping > Wrap to wrap text in selected cells. There is no…
- Excel Column Number Reference: Letters and NumbersIn Excel, columns have both letter references and number positions: A is 1, Z is 26, AA is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.