How to Indent Cell Content in Excel: Step-by-Step

Indenting cell content in Excel shifts text or numbers away from the cell’s left edge, creating visual hierarchy and making lists, outlines, and grouped data easier to read. You can apply indentation before typing or to existing cells, and adjust the amount in small increments. This guide covers the built-in indent buttons, the Format Cells dialog for precise control, and keyboard shortcuts, along with common pitfalls and fixes.

What You’ll Need

A computer with Microsoft Excel installed (2010 or later, including Microsoft 365).
A spreadsheet with data you want to indent, or a blank worksheet to practice on.
Basic familiarity with selecting cells or ranges.

Step-by-Step

Open your Excel worksheet and navigate to the sheet containing the cells you want to indent.
Select the cell or range you want to indent. Click a single cell, or click and drag to select multiple cells. To select non-adjacent cells, hold the Ctrl key (Windows) or Command key (Mac) while clicking each one.
Locate the Alignment group on the Home tab of the ribbon. It is in the middle section, next to the Font group.
Click the Increase Indent button (it looks like a blue arrow pointing right with vertical lines). Each click moves the content one character width to the right. For a larger jump, click it multiple times.
To remove or reduce indentation, click the Decrease Indent button (the arrow pointing left) next to it. Each click moves the content one character width left.
For precise control (e.g., exactly 2.5 character widths), right-click the selected cell and choose Format Cells. Alternatively, press Ctrl+1 (Windows) or Command+1 (Mac).
In the Format Cells dialog, click the Alignment tab (the second tab at the top).
Find the Horizontal drop-down menu under the “Text alignment” section. It currently shows “General” by default. Change it to Left (Indent) or Right (Indent) depending on which side you want to indent from. The “Distributed (Indent)” option also works for centering with indents on both sides.
Use the Indent box that appears to the right of the Horizontal menu. Type a number (e.g., 3) or use the spinner arrows. This number represents the width of one character in the default font and size. Click OK to apply.
For keyboard-only users, select the cells and press Alt+H+6 to increase indent, or Alt+H+5 to decrease it. On a Mac, press Option+Command+Right Arrow or Option+Command+Left Arrow respectively.
To indent only the first line of a wrapped paragraph (like a hanging indent), select the cell, open Format Cells (Ctrl+1), go to the Alignment tab, and under “Text control” check the Wrap text box. Then set Horizontal to Left (Indent) and type a number in the Indent box. This indents all lines; to create a true hanging indent, you must use a text box or adjust the cell with spaces (less reliable).
Apply indentation to an entire column or row by clicking the column letter or row number first, then using the Increase Indent button or Format Cells dialog.

Common Mistakes

Using spaces instead of the indent feature: Spaces work visually but break sorting, filtering, and alignment consistency. They also make the content harder to edit later.
Indenting numbers changes their alignment: By default, numbers are right-aligned. If you apply a left indent without changing horizontal alignment, the number may appear to jump oddly or not indent at all. Use the Format Cells dialog to set Horizontal to “Left (Indent)” for numbers.
Clicking Increase Indent on merged cells: Merged cells sometimes ignore the indent buttons. Unmerge or apply the indent before merging.
Expecting the indent to affect only the first line: The built-in indent moves the entire content of the cell, not just the first line. For a true hanging indent, you need a different approach (e.g., a text box).
Forgetting that indentation is part of cell formatting: If you copy and paste cells, the indent comes along. Use “Paste Values” or “Paste Formatting” options if you want to avoid it.

Tips

Use consistent increments: For a clean outline look, increase indentation by the same number of clicks (or indent value) at each level. For example, level 1 = 1 indent, level 2 = 3 indents.
Combine with cell borders or shading: Indentation pairs well with subtle background colors to group related rows visually.
Set a default indent for new data: If you frequently indent a certain column, select the entire column, set the indent once, and new entries typed in that column will inherit it.
Use the Format Painter: After setting the indent on one cell, double-click the Format Painter (Home tab) to copy that formatting to multiple cells by clicking each one.
Keyboard shortcut for Format Cells: Ctrl+1 opens the dialog instantly, saving time when you need precise indent values.

Troubleshooting

Indent button is grayed out: This happens when the worksheet is protected or the cells are locked. Go to the Review tab, click Unprotect Sheet (if you know the password), or check if the cells are merged. Unmerge them first.
Content does not move when clicking Increase Indent: Check if the cell has a horizontal alignment set to “Fill” or “Center Across Selection.” Change it to “General” or “Left (Indent)” in Format Cells.
Indent works but text gets cut off: If the cell has a fixed width and no wrap text, the indented content may overflow into the next cell. Either widen the column, enable Wrap Text in the Alignment tab, or reduce the indent value.
Numbers appear to indent on the right instead of left: By default, numbers are right-aligned. Set Horizontal to “Left (Indent)” in Format Cells to make the indent apply from the left edge.
Indent disappears after saving and reopening: This is rare but can happen if the file is saved in an older .xls format. Save as .xlsx or .xlsm to preserve all formatting.
Can’t type a decimal in the Indent box: The Indent box only accepts whole numbers. If you need a fractional indent, use spaces (not recommended) or adjust column width instead.

Frequently Asked Questions

Q: How much does one indent click move the text?
A: One click of the Increase Indent button moves the content by one character width, which is roughly the width of the letter “0” in the default font (Calibri 11). The exact distance depends on the font and size you are using.

Q: Can I indent text from the right side of the cell?
A: Yes. Open Format Cells (Ctrl+1), go to the Alignment tab, set Horizontal to “Right (Indent),” and specify the indent amount. The Increase/Decrease Indent buttons on the ribbon only work from the left, so use the dialog for right-side indents.

Q: Does indenting affect sorting or filtering?
A: No. Indentation is purely visual formatting. Sorting and filtering ignore it. If you want to sort by indent level, you would need a helper column with a numeric value.

Q: How do I create a hanging indent (first line at left, rest indented)?
A: Excel does not support true hanging indents in a normal cell. A workaround is to use a text box (Insert > Text Box) and set paragraph indents there, or use a formula to add leading spaces to the first line only (not recommended for data integrity).

Q: Can I indent multiple cells at once?
A: Yes. Select all the cells you want to indent (click and drag, or hold Ctrl while clicking), then use the Increase Indent button or Format Cells dialog. The indent applies to all selected cells simultaneously.

Q: Why does my indent not show when I print?
A: Indentation should print normally. If it does not, check that the cell formatting is not set to “Shrink to Fit” (which can compress content), or that the print area includes the indented cells. Also check that the column width is sufficient to display the indented content on paper.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →