To indent text in an Excel cell, select the cell or range, then choose Home > Increase Indent in the Alignment group. Click the button again to add more space, or use Decrease Indent to move the content back. Indentation changes how cell contents sit inside the cell; it does not add spaces to the value or change a formula.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows. The ribbon steps are similar in Excel for Mac and Excel for the web, though button placement can vary.
- The cell or cells you want to format. You can select one cell, a range, or several non-adjacent cells before applying an indent.
Step-by-Step
- Select the target cell or range. Click a cell containing the text you want to move inward. To apply the same indent to multiple cells, drag across the range or click the first cell, hold Shift, and click the last. For cells that are not next to each other, hold Ctrl while selecting them on Windows. On a Mac, hold Command to select separate cells. You can also select an entire row or column if the formatting should apply throughout it.
- Open the Home tab. Look for the Alignment group on the ribbon. It contains the horizontal and vertical alignment controls, text wrapping, orientation, and indent buttons. The button you need is called Increase Indent; its icon typically shows text with an arrow pointing inward. If the Excel window is narrow, some controls may be collapsed. Widen the window or open the Alignment group options to find the command.
- Click Increase Indent. Each click moves the selected cell contents one indent level farther from the cell edge. Click once, check the result, and click again only if you need more space. The amount of visual space depends on the cell’s font and formatting, so it may not match a fixed number of characters. The content stays in the same cell and remains available to formulas and sorting.
- Use Decrease Indent to reverse it. If the content moves too far, click Decrease Indent beside Increase Indent. Each click removes one level. You can also press Ctrl+Z immediately to undo the last formatting action on Windows; on Mac, press Command+Z. To remove indentation altogether, select the cell and click Decrease Indent until it returns to the cell edge.
- Set a specific alignment and indent in the dialog box. Select the cells, press Ctrl+1 on Windows, and open the Alignment tab in Format Cells. In the Horizontal list, choose an indented alignment such as Left (Indent) or Right (Indent), then set the Indent value. Choose 0 for no indent, or increase the value to move the contents farther inward. Click OK to apply. On Mac, Command+1 opens Format Cells in many versions; you can also open Format > Cells and choose Alignment.
- Check the result at normal viewing size. Click another cell to leave the selection and inspect the layout. If the text looks crowded, widen the column, turn on Wrap Text from Home > Wrap Text, or reduce the indent. If you use a right-aligned number, check that it remains easy to read and does not appear to run into the next cell. Save the workbook when the layout is right.
For a quick keyboard alternative in Excel for Microsoft 365 on Windows, select the cells, press Alt, then H, then 6 to increase the indent. Press Alt, then H, then 5 to decrease it. Press the keys in sequence rather than together. Ribbon KeyTips can differ by version or setup, so follow the letters shown on screen if these sequences do not activate the commands. Excel for Mac does not use this same sequence; use the ribbon buttons instead.
Common Mistakes
- Typing spaces before the text. Leading spaces are part of the cell value, not cell formatting. They can affect sorting, comparisons, and formulas, and may disappear if the value is edited. Use Increase Indent for a visual offset instead.
- Assuming the text has moved to another cell. An indent only changes alignment within the selected cell. The value remains in its original location, so references such as A1 still refer to the same cell.
- Clicking Increase Indent repeatedly without checking. Every click adds another level, which can leave little room for the actual content. Add one level at a time and inspect the result, especially in narrow columns.
- Selecting the wrong alignment. Indentation is applied in relation to horizontal alignment. A left-aligned label is usually indented from the left edge; a right-aligned value is positioned relative to the right edge. If the content seems to move in an unexpected direction, check the horizontal alignment in Format Cells.
- Expecting indent to fix clipping or row height. Indenting does not expand the column or automatically make every row taller. Long text may still be hidden, and wrapped content may need a wider column or an adjusted row height.
Tips
- Use indentation to show hierarchy. A useful example is a list of expense categories, with a main label such as Travel at the cell edge and related items such as Airfare and Lodging indented one or two levels. The visual structure helps readers scan the list, while each label remains a separate cell value.
- Keep indentation consistent. Apply the same number of levels to items in the same category. For a large table, select all relevant cells together before clicking Increase Indent. This avoids subtly different formatting caused by applying different numbers of clicks to individual cells.
- Use the Format Cells dialog for repeatable control. The ribbon buttons are convenient for quick changes, while the Indent box lets you specify a level directly. This is useful when standardizing several worksheets or correcting a range that has mixed indent levels.
- Combine indentation with other formatting carefully. Indent can work alongside bold text, number formats, borders, and Wrap Text. For wrapped text, remember that the indent takes up some horizontal room, so a narrow column may produce more lines than expected.
- Copy the formatting when appropriate. After formatting one cell, use Format Painter on the Home tab to copy its appearance to another cell or range. This copies other formatting as well as the indent, so check whether the destination should also inherit the font, fill, borders, and number format.
- Think about the worksheet’s purpose. Indents are useful for visual organization in a report, but should not be used to simulate separate columns in data that people will filter, sort, or analyze. Keep each distinct field in its own column, and use indentation only as a display choice.
Troubleshooting
The button is missing. Make sure the Home tab is selected and look in the Alignment group. If the ribbon is simplified or the window is too small, expand the ribbon or maximize the window. You can also press Ctrl+1 on Windows and use the Alignment tab in Format Cells to set an indent without relying on the visible button.
Nothing changes when you click Increase Indent. Confirm that you selected a worksheet cell rather than a shape, chart, or text box. Check that the cell is not currently being edited: press Enter or Esc to finish editing, select the cell again, and apply the format. If the worksheet is protected, formatting may be restricted. Ask the workbook owner to allow cell formatting or unprotect the sheet if you are authorized to do so.
The content moves the wrong way or appears cramped. Open Format Cells with Ctrl+1 and inspect the Horizontal setting and Indent value. Choose the appropriate left- or right-indented alignment, reduce the value, or use Decrease Indent. Widening the column can also help. For long labels, try Home > Wrap Text, then adjust the row height if necessary.
The indent seems to vanish after editing or pasting. Check whether the new cell content was pasted with different formatting. A normal paste can replace the destination cell’s existing formatting. Undo the paste if possible, or reapply the indent afterward. When you only want the contents and not their formatting, use Paste Special and choose a values-only option available in your version of Excel.
The printed sheet does not match the screen. Indentation changes the cell layout, but print scaling, margins, and column widths can affect how the worksheet fits on paper. Use File > Print to preview the page. Adjust the column width, page orientation, or scaling settings as needed, and avoid adding more indent levels than the printed column can accommodate.
The command is unavailable in Excel for the web. Select the cell and look on the Home tab for Increase Indent. If the ribbon is condensed, expand the window or inspect the alignment controls. Some features and their locations can differ from the Windows desktop app; if the required alignment setting is not available in the browser, open the workbook in the desktop version and use Format Cells.
Frequently Asked Questions
Can I indent a cell by a custom amount?
Yes. In Windows Excel, open Format Cells with Ctrl+1, choose Alignment, and enter a value in the Indent box. Excel uses indent levels rather than a measurement such as inches or pixels. The Increase Indent button is faster when an approximate visual offset is enough.
Does indenting change the cell value?
No. It changes the cell’s alignment formatting, not the underlying text, number, or formula. A formula that refers to the cell continues to work as before, and the value remains available for sorting and calculations.
Can I indent numbers as well as text?
Yes. You can apply indentation to cells containing numbers, dates, or text. Check the horizontal alignment after applying it, because numbers are commonly right-aligned and their indent will be positioned in relation to that alignment.
How do I remove an indent completely?
Select the affected cells and click Decrease Indent until the contents return to their original alignment, or set Indent to 0 in Format Cells. If you just applied the change, Undo is another option.
Can I indent text on a new line within the same cell?
The indent command applies to the cell’s contents as a whole; it is not a separate paragraph-indent control for each line. If you need different visual positions for lines within one cell, Excel does not provide full word-processor paragraph formatting. Consider placing the lines in separate cells, or use carefully chosen spaces only when the content is strictly for display.
Will the indent appear when I print or export the worksheet?
Cell indentation normally appears in printouts and exported files, but its visible space can change with page scaling, column width, or the destination format. Check File > Print before printing, and review an exported PDF or workbook if precise layout matters.
Related
- How to Paste in Excel While Skipping Rows
- How to Paste in Excel Using Keyboard Shortcuts
- How to Paste in Excel and Keep Formatting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Pulling Data From Other Sheets? FixesIf Excel is not pulling data from another sheet, check that the formula uses the correct sheet name…
- Excel Not Summing Numbers? Causes and FixesIf Excel is not summing numbers, the most common cause is that some values are stored as text…
- Open Point List Template for Excel: Setup and Use GuideAn open point list template for Excel is a tracker for unresolved issues, decisions, actions, or defects: give…
- Excel Basics for Data Analysis: IBM Course GuideIBM’s Excel Basics for Data Analysis is a beginner-level course that introduces spreadsheet skills used to organize, calculate,…
- Extract Rows in Excel to a New Sheet: Step-by-StepTo extract matching rows in Excel, filter your source data, select the visible results, copy them, and paste…
- Excel Cells Filled With Hashes? Causes, Fixes, and TipsIf an Excel cell displays ##### instead of a value, the most common reason is that its column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.