How to Indent Text in an Excel Cell

How-to basics · Updated November 22, 2026

To indent content in an Excel cell, select the cell or cells, then choose Home > Alignment > Increase Indent. Click again to add another indent level; to set a specific level, open Format Cells > Alignment and change the Indent value.

Indent a cell using the ribbon

In Excel for Microsoft 365 on Windows, the quickest method is the Increase Indent button on the Home tab. It is in the Alignment group, alongside commands such as Wrap Text and horizontal alignment. The button shifts the cell contents inward from the cell edge without inserting spaces into the value.

  1. Select one cell, a range, or multiple nonadjacent cells. To select nonadjacent cells, hold Ctrl while clicking each one.
  2. Open the Home tab.
  3. In the Alignment group, select Increase Indent. The contents move inward by one level.
  4. Select Increase Indent again if you want more space. Use Decrease Indent to undo a level, or repeat it until the content returns to its original position.

This changes cell formatting, not the underlying value. For example, a cell containing the text “West” still contains “West” after indentation. A formula that refers to the cell, a sort, or a filter continues to work with the same value. This makes the ribbon method useful for visual structure without changing data.

What cell indentation does

Excel indentation is an alignment setting. It controls how the cell’s displayed content sits inside its boundaries; it is not the same as adding blank characters before the content. The distinction matters when data is used in calculations, searches, exports, or other worksheets. A formatted value remains ordinary text or a number, while a value prefixed with spaces includes those spaces as part of its contents.

Indentation is measured in levels rather than a fixed number of pixels or spaces. The visible gap can depend on the font, font size, column width, and the type of content. Excel’s alignment settings allow an indent level from 0 to 15. If an indent seems larger or smaller than expected, remember that it is a formatting increment, not a precise ruler measurement.

Indentation is often used to show hierarchy in a worksheet: a main category can stay at the edge of a column while its subcategories move inward. It can also make a short label easier to distinguish from a number or adjacent column. It does not create a new outline level, group rows, or alter the worksheet’s data structure; it only changes the selected cells’ appearance.

Set an exact indent level in Format Cells

The ribbon button is convenient when one or two clicks are enough. For a particular level, or when you want to inspect the alignment settings, use the Format Cells dialog in Excel for Windows:

  1. Select the cells to format.
  2. Press Ctrl+1 to open Format Cells. You can also right-click the selection and choose Format Cells.
  3. Choose the Alignment tab.
  4. Under Text alignment, set the Indent value. Choose 0 to remove the indent, or a higher level for more inset.
  5. Select OK.

The dialog also lets you review horizontal alignment and other display choices, which can help if the indent button seems to have no effect. For example, a cell set to centered alignment is not a good candidate for a left-edge indent: first choose an appropriate left or right alignment, then apply the indent. The precise options shown can vary with the selected cell format and Excel version.

Choose the right alignment and indent

Indent is most useful when it supports the alignment already used in the cell. Text entries are generally left-aligned by default, while numbers are generally right-aligned. Increasing indent moves content inward rather than changing that general alignment. If a set of labels should line up consistently, select the whole set and apply the same number of levels rather than indenting cells one by one.

  • Left-aligned labels: Indent subcategories to the right to show that they belong under a broader label.
  • Right-aligned values: An indent can inset the displayed value from the right side. Check that this is the visual effect you intend, particularly in a column of figures.
  • Centered headings: Indenting usually is not the right way to position centered text. Use the alignment controls or adjust the column layout instead.
  • Long descriptions: Combine indentation with Wrap Text if the content needs to remain inside a narrow column. Wrapping controls line breaks; indentation controls the inset.

Consistency is usually more useful than adding many levels. If a sheet needs to show several levels of hierarchy, use indentation alongside clear labels, spacing between sections, or Excel’s grouping features where appropriate. Indentation alone does not tell a reader whether rows are parent and child records.

Excel for the web and Mac differences

In Excel for the web, select the cells and look for Increase Indent on the Home tab in the alignment controls. The ribbon may show a compact icon rather than the full command name, especially when the browser window is narrow. If you cannot see it, widen the window or expand the ribbon. The web app can have a more limited set of formatting controls than desktop Excel, so the Format Cells dialog may not expose every desktop alignment option.

In Excel for Mac, select the cells and use the Home tab’s alignment controls to increase or decrease the indent. The Format Cells dialog is also available from the cell’s formatting options; on many Mac keyboards, Command+1 opens it. The key combination can be affected by keyboard settings or an external keyboard, so using the menu or ribbon is a reliable alternative. On Windows, the corresponding shortcut is Ctrl+1.

There is no need to use a Windows-only feature to indent ordinary cell contents: the basic ribbon control is available in desktop Excel on both platforms and in Excel for the web. The exact ribbon layout and dialog details can differ between versions, so use the command name or its tooltip if the button is not immediately obvious.

Indentation compared with typing spaces

Typing spaces before text can appear to indent it, but it changes the actual contents. For instance, “ West” is not the same text value as “West” for comparisons or some lookups. Leading spaces can also make sorting, matching, cleaning, and exporting less predictable. For a normal worksheet layout, use cell formatting rather than manually inserting spaces.

There are cases where spaces are intentional, such as preparing plain text for a fixed-width export or producing a text label that must contain leading spaces. In those cases, a formula can create them, but the result is text and should be treated as such. With the word “Apples” in A2, enter this formula in another cell:

=REPT(" ",3)&A2

The result displays three leading spaces followed by “Apples.” Because the formula joins spaces to the source value, the result is text; it is not a formatting indent and is not suitable as a replacement for a numeric value. Also, Excel may visually collapse or make leading spaces difficult to notice in some contexts. Use this approach only when the spaces themselves are part of the desired text output.

Common problems and fixes

  • The button appears to do nothing: Check whether the content is centered, or whether the selected cells have a different alignment setting. Open Format Cells > Alignment and review both Horizontal alignment and Indent.
  • The words are clipped: Indenting reduces the room available inside the cell. Widen the column, turn on Wrap Text, or reduce the number of indent levels. Increasing row height may also be necessary for wrapped text.
  • Different rows look uneven: They may have different indent levels, fonts, or horizontal alignment. Select the range together and apply a consistent alignment and indent. Setting Indent to 0 removes the indent from the selection.
  • The number no longer looks aligned with other values: Confirm that the number cells share the same horizontal alignment and indent. Indenting changes the display position, so compare the whole column rather than judging one cell in isolation.
  • Spaces remain after removing the indent: Decrease Indent removes formatting levels, not typed spaces. If spaces were entered into the value, edit or clean the contents separately.

Also check whether the cell is part of a merged range or a specially formatted report. Such layouts can constrain how content appears, and changing alignment may affect the overall presentation. If a workbook has an established style, consider whether a change to the cell style or table layout would be more consistent than applying a one-off indent.

Practical examples

Suppose a department list has “Operations” as a heading, followed by “Shipping” and “Inventory.” Keep Operations at indent level 0, select the two subcategory cells, and choose Increase Indent once. The visual hierarchy is clear, while the actual labels remain unchanged and can still be used in formulas or filters.

For a monthly report, a short descriptor such as “Total” might look crowded beside a neighboring value. A modest indent can separate it visually without adding spaces or changing the number format. If the column is too narrow, however, indentation is not a substitute for enough space: expand the column or wrap the text so the label remains readable.

For a reusable template, format a whole label range at once and apply the same level to corresponding rows. If you later need to remove the visual hierarchy, select the cells and use Decrease Indent or set Indent to 0 in Format Cells. This is usually safer than trying to delete invisible spaces from many values.

Frequently Asked Questions

How do I indent text in an Excel cell?
Select the cell, then choose Home > Alignment > Increase Indent. Click more than once for additional levels. To set a specific level, use Format Cells > Alignment.

Can I indent only part of the text in a cell?
The standard Increase Indent command applies to the cell’s contents as a whole, not just a selected word or character. If only part of a label needs a different position, consider separating the parts into neighboring cells or using a text layout designed for that purpose.

How do I remove an indent in Excel?
Select the indented cells and choose Decrease Indent on the Home tab until the content returns to its original position. Alternatively, open Format Cells > Alignment and set Indent to 0.

Can I use a keyboard shortcut to indent a cell?
Excel does not provide a standard single keyboard shortcut specifically for Increase Indent. On Windows, Ctrl+1 opens Format Cells so you can change the indent setting; on Mac, Command+1 commonly opens the corresponding dialog. The ribbon button is the direct way to increase a level.

Does indenting change the cell’s value?
No. The Increase Indent command changes formatting, so formulas and data operations still use the original value. Typing spaces or joining spaces with a formula does change the text, which is why those methods should be reserved for cases where spaces are intentionally part of the content.

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.