How to Indent in an Excel Cell: Steps, Tips and Fixes

How-to basics · Updated November 20, 2026

To indent text in an Excel cell, select the cell or range, then choose Home > Alignment > Increase Indent. Click the button again to move the content farther in. If you need a precise indent level, open Format Cells and set it on the Alignment tab. Indenting changes how content sits inside a cell; it does not add spaces to the value or change the underlying data.

What You’ll Need

  • A workbook open in Microsoft Excel. These instructions focus on Excel for Microsoft 365 on Windows.
  • The cell or cells you want to format. You can select one cell, a continuous range, or multiple nonadjacent cells.
  • For the detailed alignment settings, access to the Format Cells dialog. Excel for Mac has similar options, although its menus and keyboard shortcuts differ in places.

In this guide, “box” means a worksheet cell. A drawing object such as an inserted text box is formatted differently and is covered in the troubleshooting and FAQ sections.

Step-by-Step

  1. Select the cell or range. Click the cell whose contents you want to move inward. To format several neighboring cells at once, drag across them or click the first cell and Shift-click the last. You can also select a full column or row by clicking its heading. To select nonadjacent cells on Windows, hold Ctrl while clicking each one; on Mac, hold Command while clicking. Applying an indent to a range changes the alignment of every selected cell, so check the selection before continuing.
  2. Open the Home tab. On the Excel ribbon, click Home. Find the Alignment group, which contains controls for horizontal and vertical alignment, text wrapping, and orientation. If the ribbon is collapsed, expand it or use the Home tab to reveal its controls. In Excel for the web, the corresponding ribbon controls are also on the Home tab, though the layout may be more compact.
  3. Increase the indent. In the Alignment group, click Increase Indent. The icon usually shows horizontal lines with an arrow pointing inward or to the right; hover over an icon to display its name if you are unsure. Excel moves the cell content inward by one indent level. The change is visual: the cell’s text, number, or formula result remains the same.
  4. Add more space if needed. Click Increase Indent again to add another level. Watch the selected cell after each click rather than clicking repeatedly without checking. Indentation is most noticeable when the cell has spare width. If the content is long or the column is narrow, it may wrap or appear crowded; widen the column or enable Wrap Text if that suits your layout.
  5. Reduce or remove the indent. To step back one level, click Decrease Indent in the same Alignment group. Repeat until the content returns to the cell edge. Decrease Indent reduces the formatting; it does not delete leading spaces that were typed into the cell. If those spaces are part of the actual cell value, remove them separately by editing the cell.
  6. Set an exact level in Format Cells. Select the cell or range, then press Ctrl+1 on Windows to open Format Cells. Choose the Alignment tab. Under Horizontal, choose a left- or right-aligned option that supports indentation, then set the Indent level. The dialog offers levels from 0 to 15: 0 means no indent, and larger numbers move the content farther inward. Click OK to apply it. On a Mac, use Command+1 to open Format Cells, then look for the Alignment tab and its Indent setting. You can also open the dialog from the cell’s context menu or the Format menu, depending on the Excel layout.
  7. Check the result in the worksheet. Click another cell and inspect the formatted one. Confirm that the content is still readable, the intended cells changed, and the value or formula is intact. If the cell looks unchanged, check its horizontal alignment, column width, and whether you selected the correct cell. Excel’s Windows ribbon KeyTip sequence for Increase Indent is usually Alt, H, 6, pressed in sequence rather than all at once. KeyTips can vary by ribbon configuration; on Mac, use the ribbon button or Format Cells instead of relying on that Windows sequence.

For a simple label inside a table, one click is often enough to distinguish it from nearby headings. For a nested-looking list, use consistent levels: indent each child item the same number of times, and leave parent items at a smaller level. Excel does not create a true outline hierarchy when you indent cell contents; the levels are visual formatting only.

Common Mistakes

  • Typing spaces at the start of the value. Leading spaces become part of the cell’s contents, can affect sorting and comparisons, and may be hard to remove consistently. Use Increase Indent for visual spacing instead.
  • Expecting indentation to move only part of a cell’s text. The indent applies to the whole cell’s displayed content. It will not move just one word or one line independently.
  • Using the wrong alignment control. Increase Indent is not the same as Center, Align Left, or Align Right. If you change horizontal alignment while trying to indent, the content may jump to a different side of the cell.
  • Applying the format to too many cells. A whole-column selection can affect existing data and future entries in that column. Select only the cells that need the formatting, or check the selection highlight before clicking.
  • Assuming the indent changes the data. Indentation does not insert characters, add a list level to a formula, or alter the cell’s value. It is a display setting, so copying values alone may not carry it over.

Tips

  • Use a consistent number of clicks. Choose one level for a first-level subitem and two for the next level, then apply that convention throughout the worksheet. This gives a clearer visual structure than using a different amount of spacing in every row.
  • Use Format Cells for repeatable formatting. The dialog is useful when you need to specify the same indent level for multiple selected cells, or when repeated button clicks are inconvenient. It also makes the current level easier to inspect.
  • Combine indenting with Wrap Text when appropriate. An indent takes up some of the room available for displayed content. Wrapping can keep longer labels within the cell, but it may increase row height. Check the whole table after applying both settings.
  • Copy the formatting when you want consistency. Copy a correctly formatted cell, select another cell, and use Home > Paste > Paste Special > Formats where available. This copies formatting rather than replacing the destination’s value. Check the result, especially if the source has other formatting you do not want.
  • Consider column width and alignment together. Left-aligned text generally indents from the left edge, while right-aligned content can be indented from the right. If the result looks backward, check the horizontal alignment before changing the indent again.
  • Keep indentation for presentation, not data structure. If you need to sort, filter, or calculate levels, store a category or level in a separate column. Indent alone does not tell Excel that one entry is a child of another.

Troubleshooting

The button is missing or hard to find. Make sure the Home tab is active and look in its Alignment group. If the window is narrow, Excel may compress the ribbon and hide some labels; maximize the window, expand the ribbon, or hover over the alignment icons to see tooltips. You can also use Format Cells and set the indent on its Alignment tab.

Clicking Increase Indent does nothing obvious. Confirm that a worksheet cell, rather than a shape, is selected. Check that the content is not already close to the cell edge or hidden by a narrow column. Try increasing the level once more, then widen the column temporarily to see whether the change is visible. Also check the horizontal alignment: centered content may not show the effect as expected. Choose left or right alignment if that fits your layout, then apply the indent.

The text wraps or seems cut off afterward. Indenting reduces the room available for content inside the cell. Widen the column, reduce the indent level, or use Home > Wrap Text to display long content on multiple lines. If the row height does not adjust as expected, use Home > Format > AutoFit Row Height, or adjust the row height manually. Merged cells can make automatic sizing less predictable, so consider unmerging them if the layout allows.

The wrong cells changed. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the intended cells and try again. If you already made other changes, use Decrease Indent or reset the alignment carefully rather than undoing unrelated work. A selection that includes an entire row or column can apply formatting much more widely than intended.

You are working with an inserted text box. Worksheet-cell indent buttons do not format text inside a drawing text box. Select the text box and use its shape or text-formatting controls, or put the text in worksheet cells if you need cell alignment and spreadsheet formatting.

Frequently Asked Questions

Does indenting change the value in an Excel cell?

No. Increase Indent changes the cell’s formatting, not its stored text, number, or formula. The value remains available to formulas and sorting as before. This differs from typing spaces at the beginning, which changes the text itself.

Can I indent numbers as well as text?

Yes. Indentation is an alignment setting and can be used with numeric values as well as text. Numbers are commonly right-aligned by default, so the indent may appear on the right side. Check the alignment and number format if the result is not where you expect.

How many indent levels can I set?

The Indent setting in Format Cells provides levels from 0 through 15. The Increase Indent button moves the setting in steps, while Decrease Indent moves it back. The amount of visible space also depends on the cell’s width and alignment.

Can I indent just one line or one word inside a cell?

Not with the cell’s Increase Indent control: it formats the whole cell. Excel does not provide a per-line indent setting through that button. If you need separately positioned text, use separate cells or an inserted text box, depending on whether the content needs to remain part of the worksheet grid.

Can I indent a group of cells at once?

Yes. Select the range first, then click Increase Indent or set the level in Format Cells. All selected cells receive the formatting. To keep the change limited, check the highlighted selection before applying it; use Ctrl-click on Windows or Command-click on Mac to add nonadjacent cells.

Related

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.