How to Indent a New Line in Excel Using Cell Alignment

To indent text in an Excel cell, select the cell and choose Home > Alignment > Increase Indent. That indents the cell’s contents, including every line in it. If you want to indent only a new line within the same cell, insert a line break with Alt+Enter on Windows, then type spaces at the start of that line; Excel does not provide paragraph-style indentation for just one line. The steps below explain both approaches.

What You’ll Need

Excel for Microsoft 365 on Windows, or Excel for Mac or the web if you need to adapt the steps.
A worksheet with the cell you want to format. If you want a separate indented line inside a cell, the cell should contain text you can edit.

You do not need a formula, add-in, or special setting. The main thing to decide first is whether you want to indent all the text in a cell or only one line within it. Those are different formatting tasks in Excel.

Step-by-Step

Choose what you mean by an indented new line. If the cell has one or more lines and you want all of them moved in from the left edge, use Excel’s Increase Indent command. If only the second or another individual line should move in, edit the cell and add leading spaces to that line. Excel’s alignment indent applies to the whole cell, not to an individual line or paragraph.
Select the cell or cells. Click a cell to format just that cell. To apply the same indentation to several cells, drag across a range or select nonadjacent cells while holding Ctrl on Windows. Make sure you select the cells themselves, not just text inside the formula bar. The alignment setting is applied to each selected cell.
Indent all lines in a cell with the ribbon. On the Home tab, find the Alignment group and select Increase Indent. Each click moves the cell content farther from the left edge. Select the button once, check the result, and select it again only if you want a larger indent. To reduce the indent later, select Decrease Indent in the same group.
Turn on wrapping if you need multiple displayed lines. Select the cell, then choose Home > Alignment > Wrap Text. Wrapping lets text appear on more than one line as the column width requires. It does not create an intentional line break at a specific point, and it does not let you indent only one of the wrapped lines. If a line should start at a precise position, add a manual line break instead.
Insert a new line within a cell on Windows. Double-click the cell, or select it and press F2, then click or use the arrow keys to place the insertion point where the next line should begin. Press Alt+Enter. Excel inserts a line break without moving to another cell. If you are entering text from scratch, type the first line, press Alt+Enter, and continue typing in the same cell.
Indent just the new line with leading spaces. After inserting the line break, type a small number of spaces before the line’s text, then continue typing. For example, the cell can contain a heading, a line break, and then three spaces followed by a detail. Adjust the spaces to suit the font and column width. This is a visual workaround: the spaces are part of the cell’s text, not an alignment indent setting.
Finish editing and check the display. Press Enter to commit the edit. If the line break or part of the text is not visible, select Home > Wrap Text and adjust the row height or column width. You can also double-click the lower edge of the row number to AutoFit the row height. Review the cell at normal zoom to make sure the indent looks right.
Use the Format Cells dialog when you want a specific indent level. Select the cell, press Ctrl+1, and open the Alignment tab. Under Horizontal, choose Left (Indent), then set the Indent level and select OK. This is another way to indent the entire cell’s contents. It does not set a different indent for each line.

On Excel for Mac, the ribbon command is also on Home in the Alignment group. To insert a line break while editing a cell, use Control+Option+Return; keyboard behavior can vary with the Mac keyboard and Excel version, so use the ribbon or Excel’s shortcut help if that combination is intercepted by macOS. In Excel for the web, use Home > Increase Indent for cell-level formatting. Editing shortcuts can differ by browser and operating system; if Alt+Enter does not insert a break, edit the cell and use the shortcut shown in Excel’s help for your setup.

Common Mistakes

Expecting Increase Indent to affect only the new line. The command changes the horizontal alignment of the whole cell. If just one line should be inset, use a manual line break and spaces, or put the detail in a separate cell where you can format it independently.
Pressing Enter when you mean to add a line break. Enter normally commits the current entry and moves the selection. Use Alt+Enter on Windows while editing a cell to stay in that cell and start another line.
Confusing wrapping with a manual line break. Wrap Text moves text onto another displayed line when it reaches the cell edge. The break can shift if the column width changes. Alt+Enter inserts a deliberate break at a chosen point.
Adding too many spaces. A large run of spaces can push the text out of view or look uneven when the font or column width changes. Start with a few spaces and check the result. Spaces are less reliable for layout than a separate cell or a whole-cell indent.
Using Increase Indent on text aligned to the right. The result may not look like a left-side indent. If that is not intended, check Home > Alignment or Ctrl+1 > Alignment and set Horizontal to Left (Indent) before adjusting the level.
Assuming the row height will always expand as expected. Wrapped or manually broken text can be clipped if the row has a fixed height or merged cells are involved. Inspect the row height and the cell’s wrapping before changing the indent again.

Tips

Prefer cell alignment for consistent formatting. If every line in a note should start at the same inset, Increase Indent is cleaner than typing leading spaces. It preserves the text and makes the formatting easier to adjust later.
Use separate cells for structured information. If you are making a heading with subordinate details, place the heading and details in separate rows or cells when practical. You can indent only the detail cells without inserting spaces into the text.
Keep manual line breaks purposeful. A manual break keeps related text together in one cell, but it can affect sorting, row height, and copying to other programs. Use it for a short note or label rather than building a complex layout inside a single cell.
Check the result after changing column width. A manual break stays at the point you inserted it, while wrapped text responds to the width. Spaces used as a visual indent may also appear wider or narrower depending on the font and zoom.
Copy formatting carefully. If you want the same whole-cell indent elsewhere, copy the formatted cell and use Paste Special > Formats, or use Format Painter. Remember that copied formatting does not create a line-specific indent; that still depends on the text and its spaces.
Use the dialog for repeatable levels. Format Cells lets you see the Horizontal setting and indent level. It is useful when matching a set of cells, particularly if repeated clicks on Increase Indent make it difficult to tell how far the text has moved.

Troubleshooting

The Increase Indent button is missing or hard to find. Make sure the Home tab is selected and look for the Alignment group. If the Excel window is narrow, some ribbon commands may be collapsed into a menu. Widen the window or open Format Cells with Ctrl+1, select Alignment, and choose Left (Indent) with an indent level.

Alt+Enter moves the selection instead of adding a line. First make sure you are editing the cell, rather than simply selecting it. Double-click the cell or press F2, position the cursor inside the text, and try Alt+Enter again. If you are in Excel for Mac or the web, use the platform-specific shortcut or consult Excel’s shortcut help; shortcuts can vary by operating system and browser.

The text still looks like one line. Confirm that the cell contains a manual line break or that Wrap Text is enabled. Then make the row taller or use Home > Format > AutoFit Row Height. A narrow column can also cause automatic wrapping in unexpected places, so widen it if needed.

The second line is not indented. This is expected if you used Increase Indent: it moves all content in the cell together. To move only the second line, edit the cell, place the cursor after the line break, and add leading spaces. If the spaces seem to disappear, verify that you are entering them as part of the cell’s text and not in a separate cell.

The line is clipped or the indent looks excessive. Reduce the indent with Home > Alignment > Decrease Indent, remove some leading spaces, widen the column, or increase the row height. If the cell is merged, try unmerging it or adjusting the row height manually, since AutoFit may not size merged cells as expected.

Frequently Asked Questions

Can I indent only the second line of a cell?

Not with Excel’s Increase Indent alignment command; it applies to the whole cell. Insert a line break and add spaces before the second line, or place that line in another cell and format it separately.

What is the Windows shortcut for a new line inside an Excel cell?

Edit the cell, place the cursor where the break should go, and press Alt+Enter. Pressing Enter by itself usually finishes the entry rather than adding a line within it.

Does Wrap Text indent a line?

No. Wrap Text displays long content on multiple lines within a cell, but does not add an indent. It may wrap at different points when the column width changes. Use a manual line break for a chosen break point.

Can I add an indent without changing the cell’s text?

Yes. Select the cell and choose Home > Alignment > Increase Indent, or set Left (Indent) and an indent level in Format Cells. Those options change formatting, not the text itself.

Will the indent remain if I sort or copy the worksheet?

Cell-level indentation generally travels with the cell’s formatting when you copy or move it, and sorting moves cell contents and formatting together. Leading spaces are part of the text, so they also travel, but they may be less predictable when the text is edited or reused elsewhere.

How do I remove an indent?

Select the cell and choose Home > Alignment > Decrease Indent until the text returns to the desired position. If you used spaces before one line, edit the cell and delete those spaces without removing the line break or the text.

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.