To indent content in Excel, select the cell or range, then choose Home > Increase Indent in the Alignment group. Click it again to add more space from the cell edge, or choose Decrease Indent to move the content back. This changes how content is positioned inside cells; it does not insert spaces into the value or change the underlying data.
The steps below are for Excel for Microsoft 365 on Windows. You can use the same basic ribbon controls in Excel for Mac and Excel for the web, although the ribbon layout can vary slightly. Indenting is useful for showing hierarchy, separating subitems from main items, or making a worksheet easier to scan without changing the data used in calculations.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365.
- The cell or range you want to indent. You can select one cell, several cells, or an entire column or row of cells.
- Optional: a clear plan for which entries are main items and which are subitems, especially if you are formatting a list or report.
Step-by-Step
- Select the cells. Click a cell to indent just that cell. To format several cells at once, drag across them or click the first cell, hold Shift, and click the last cell in the range. To select nonadjacent cells, hold Ctrl while clicking each one on Windows. The selected cells should be highlighted before you use the ribbon control. You can also select a full column or row if you want the same formatting applied to its cells.
- Open the Home tab. On the ribbon at the top of Excel, select Home. Find the Alignment group, which contains controls for horizontal and vertical alignment, text wrapping, and orientation. If the Excel window is narrow, some ribbon controls may be compressed into smaller buttons or a menu, so expand the window or inspect the Alignment group for the indent controls.
- Choose Increase Indent. Click Increase Indent in the Alignment group. Excel shifts the displayed content farther from the cell edge. The button may appear as an arrow beside horizontal lines; hover over a ribbon button if you are unsure of its name, and Excel displays a tooltip. Depending on the ribbon width, the control may be shown as an icon rather than a text label.
- Repeat only as much as needed. Each click adds another indent level. Click once for a modest offset, then review the sheet at its normal viewing size. Repeated clicks can push the content far into the cell and leave less room for the text. Indent levels are formatting settings, not a fixed number of typed spaces, and their visible width depends on the font and cell layout.
- Use Decrease Indent to reverse it. If the content moves too far, keep the same cells selected and click Decrease Indent in the Alignment group. Click as needed until the content is positioned where you want it. This removes indent formatting one level at a time; it does not delete characters from the cell or alter a formula.
- Check the horizontal alignment. Indentation is easiest to understand when you consider the cell’s alignment. Text with left alignment is offset from the left edge, while right-aligned content is offset from the right edge. If the result looks unexpected, select the cell and check Home > Alignment for the alignment setting. Choose Align Left or Align Right as appropriate, then apply the indent again. Centered text may not show the offset in the way you expect, so change the alignment if the purpose is to create a clear inset from one side.
- Set an exact indent level if needed. For more control, select the cells, open the Format Cells dialog, and use the Alignment tab. In the Horizontal list, choose Left (Indent) or Right (Indent), then set the Indent level. Select OK to apply the setting. The dialog is useful when you need the same specific level in multiple places or want to inspect the alignment options. The ribbon’s Increase Indent and Decrease Indent buttons are usually faster for routine adjustments.
- Review the result in context. Look at the formatted cells alongside nearby headings and values. Widen a column if the indent leaves too little room for the content, or use text wrapping if a long entry should remain visible on multiple lines. If the cells are part of a printed report, use Print Preview to check that the indented content still fits the page. Save the workbook when the formatting is ready.
To indent a list, put each item in its own cell or row and apply the indent to the subitems. For example, a project list might have a main task such as Planning in one row, with Research and Scheduling in the rows below it. Select only Research and Scheduling, then click Increase Indent. That visual hierarchy can make the relationship clear while keeping every entry in a separate cell for sorting, filtering, or editing. If the list uses several levels, use a consistent number of clicks for each level and check that the distinction is still easy to see.
Excel for Mac has similar indent controls on the Home tab in the Alignment area; the precise arrangement can differ by ribbon version and window size. In Excel for the web, select the cells and look for Increase Indent or Decrease Indent on the Home tab. If you cannot see a button, expand the ribbon or open the relevant alignment options. The Format Cells dialog may offer fewer or differently arranged controls in the web version, so use the ribbon buttons when available.
Common Mistakes
- Typing spaces before the content. Leading spaces become part of the cell’s text. They can affect matching, sorting, or formulas that compare text, and they may look different in another font. Use the indent formatting control when you only want a visual offset.
- Expecting the indent to change the value. Indentation does not add a level to a formula, change a number, or create a true parent-child relationship between rows. It is a display choice. Use Excel’s grouping or outline features when you need rows that can be expanded and collapsed.
- Applying the setting to the wrong range. If you selected an entire column, all relevant cells in that column may receive the formatting, including cells you did not intend to change. Check the selection before clicking Increase Indent. Use Undo immediately if you applied it too broadly.
- Using too many levels. Several indent clicks can make entries look cramped or push important text toward the center of a narrow column. Keep levels limited and consistent. If you need many nested categories, consider separate columns for category and subcategory instead of relying on a large visual offset.
- Confusing cell indentation with row grouping. Indenting a cell does not hide rows, add outline buttons, or change the worksheet structure. It only moves displayed content within cells. Group rows separately if your goal is to collapse details beneath a summary.
- Assuming every alignment behaves the same. Centered, general, left, and right alignment can make an indent appear differently. If the cell seems unchanged, confirm its horizontal alignment and try left or right alignment to make the direction clear.
Tips
- Format related entries together. Select all the subitems that should share a level and apply the indent once. This is quicker and reduces inconsistent spacing compared with formatting each cell individually.
- Use a small number of levels. A main item and one or two sublevels are generally easier to scan than a long staircase of increasingly indented text. Keep the same indent level for entries with the same role.
- Separate meaning from appearance. If you need to filter or summarize categories later, store each level in its own column or use a dedicated category field. Indentation can help readers, but it is not a substitute for structured data.
- Combine indentation with other clear formatting. Bold headings, borders, or a restrained fill color can distinguish main items from details. Avoid using indentation alone if readers must interpret the hierarchy quickly, especially in a large worksheet.
- Check column width and wrapping. An indent takes up visible space, so long labels may be clipped. Widen the column, turn on Wrap Text from the Home tab, or shorten the displayed label while keeping the full information elsewhere.
- Copy formatting carefully. If you want to reuse an indent, copy a correctly formatted cell and use Paste Special > Formats, or use Format Painter. Check the destination afterward because copied formatting can also include alignment, number format, borders, and fill.
Troubleshooting
The button is missing or hard to find. Confirm that the Home tab is selected and look in the Alignment group. A narrow window or simplified ribbon can hide labels. Maximize Excel, expand the ribbon, or hover over alignment icons to read their tooltips. If you are using Excel for the web, check that the workbook is open in edit mode; a read-only view will not let you change cell formatting.
Clicking Increase Indent seems to do nothing. First confirm that the intended cells are selected and that the sheet is not protected against formatting changes. Check whether the content is centered or whether the cell is merged, since either can make the offset less obvious. Try a left or right alignment and click Increase Indent again. If the cell already has a substantial indent, use the Format Cells dialog to inspect its alignment and level.
The content moves in the wrong direction. Indentation follows the horizontal alignment. A left-aligned entry moves inward from the left, while a right-aligned entry moves inward from the right. Change the horizontal alignment to match the side you want to inset, then apply the indent. For a worksheet using a right-to-left layout, the screen direction may also differ from what you expect.
The text is cut off after indenting. The indent reduces the room available to display the cell’s content. Increase the column width, turn on Wrap Text, or reduce the indent level. If the cell contains a long number or identifier, check its number format and column width too; indentation does not change the stored value, but it can make less of that value visible.
Undo did not remove all the indent. Each click adds or removes a level, so one Decrease Indent click may not return a cell to its original position. Select the affected cells and click Decrease Indent until the display is right, or open Format Cells and set the indent level to zero. If you just made the change, Ctrl+Z on Windows or Command+Z on Mac can undo it.
Frequently Asked Questions
Does indenting a cell change its contents?
No. It changes alignment formatting only. The text, number, or formula remains the same, and formulas that refer to the cell continue to use its original value.
Can I indent only part of the text inside a cell?
The Increase Indent control applies to the cell’s contents, not just a selected word or character. To position separate parts independently, put them in separate cells or use a layout with multiple columns.
Can I indent a whole range at once?
Yes. Select the range first, then use Increase Indent. Excel applies the formatting to the selected cells. To avoid changing unrelated entries, select only the cells that belong to the same level.
How do I remove an indent completely?
Select the affected cells and click Decrease Indent until no inset remains. For a precise reset, open Format Cells > Alignment, set the indent level to zero, and confirm the horizontal alignment you want.
Is cell indentation the same as indenting a paragraph in Word?
No. Excel formats content within cells; it does not provide the same paragraph ruler and paragraph indentation controls as Word. For multi-line cell text, indentation applies to the cell’s content rather than to a chosen paragraph within it.
Can I use indenting to create collapsible subitems?
No. Indentation only changes appearance. To expand or collapse detail rows, select the rows and use Data > Group. Use indentation alongside grouping only when the visual offset adds useful context.
Related
- Find Duplicate Entries in an Excel Column
- How to Find Duplicates in Excel and Review Them Safely
- How to Find Duplicate Lines in Excel Without Deleting Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Custom Sort in Google Sheets: Steps, Rules, and ExamplesTo custom-sort Google Sheets data, select the full table, choose Data > Sort range > Advanced range sorting…
- How to Freeze Specific Columns in Excel While ScrollingTo freeze columns in Excel, select the cell immediately to the right of the last column you want…
- Hanging Indent in Word: Use Ctrl+TTo create a hanging indent in Microsoft Word for Windows, click in the paragraph or select the paragraphs…
- How to Get Rid of a Page Split in ExcelTo remove a page split in Excel, first identify what you are seeing: for a print-page boundary, go…
- How to Schedule an Email in Outlook for iOS on iPhoneTo schedule an email in Outlook for iOS, compose your message, tap the three-dot menu, choose Schedule Send,…
- Can You Shuffle Names in Excel? Methods and ExamplesYes. In Excel for Microsoft 365 on Windows, add a random number beside each name and sort the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.