To indent just one paragraph inside an Excel cell, insert a line break and type spaces at the start of the new line. Excel’s built-in Increase Indent command applies to the whole cell, not to a single paragraph, so spaces are the practical workaround when both paragraphs must stay in one cell. You will need a cell containing text and, for a readable result, enough row height to show all its lines.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows. The method also works in Excel for Mac and Excel for the web, with a different keyboard shortcut for inserting a line break on Mac.
- A cell you can edit. If the worksheet is protected, you may need permission to edit that cell.
- Optional: a few minutes to adjust wrapping, row height, or column width so the indented paragraph displays clearly.
Step-by-Step
- Select and edit the cell. Click the cell that contains the text, then press F2 or double-click inside it. You can also click in the formula bar. If the cell is empty, select it and start typing. Editing inside the cell lets you place the line break exactly where the next paragraph should begin; pressing Enter by itself normally finishes the cell edit instead of starting a new line.
- Put the insertion point at the start of the new paragraph. Use the arrow keys or click in the text to place the cursor after the last character of the preceding paragraph. If you are adding the paragraph between existing text, position the cursor where the split should occur. Take care not to leave the cursor partway through a word unless that is where you intend the line to break.
- Insert a line break within the cell. In Excel for Microsoft 365 on Windows, press Alt+Enter. On a Mac, press Control+Option+Return. Excel starts a new line but keeps the text in the same cell. If you are using Excel for the web and the desktop shortcut does not work in your browser, edit the cell and use the available line-break shortcut for your operating system, or prepare the text with a line break in the formula bar. The browser or operating system may intercept some key combinations.
- Type the paragraph indent. After the line break, press the Space bar two or more times, then type the new paragraph. For example, the cell text could be entered as First paragraph, then a line break, then three spaces followed by Indented paragraph. The leading spaces are part of the cell’s text; they create a visual offset rather than a true paragraph-formatting setting. Start with two or three spaces and adjust after checking the result.
- Finish the edit and turn on wrapping. Press Enter to commit the cell. Select it and choose Home > Wrap Text if the text should continue onto additional lines within the cell width. A manual line break creates a new line whether or not wrapping is on, but Wrap Text helps display longer paragraphs that exceed the column width. If the text already wraps automatically, the manual break still marks the start of the paragraph you chose.
- Make the full text visible. If part of the paragraph is hidden, increase the row height or use Home > Format > AutoFit Row Height. You can also widen the column. When the cell is not merged, double-clicking the boundary below its row number can often AutoFit the row. Merged cells may not AutoFit reliably, so adjust their row height manually if necessary.
- Review the indent and save. Click the cell once to leave edit mode and check that the second paragraph begins farther to the right. Add or remove spaces until the offset looks right. If the spaces are difficult to judge, make the column wider temporarily or use a monospaced font while editing. Save the workbook when the layout is correct.
This approach is for a visual first-line indent inside one cell. If you want every line in the cell to move right, use the cell-level indent control instead: select the cell and choose Home > Alignment > Increase Indent. That setting affects the cell’s alignment as a whole; it cannot target only the new paragraph.
Common Mistakes
- Pressing Enter instead of Alt+Enter. Enter usually commits the edit and moves the selection, which can make it seem as if the paragraph disappeared. Reopen the cell and use the in-cell line-break shortcut.
- Using Increase Indent for only one paragraph. Increase Indent is a cell alignment setting. It shifts the cell’s content rather than adding a paragraph-specific indent. Use spaces after a manual line break when the first paragraph should remain aligned at the left.
- Adding spaces before the line break. Spaces entered at the end of the previous paragraph move that paragraph’s ending, not the start of the next one. Put the spaces immediately after the line break and before the new paragraph’s first character.
- Expecting the indent to behave like a word processor. Spaces do not set a formal first-line indent. If the paragraph wraps, the following wrapped lines may begin at the cell’s normal text edge, rather than lining up under the first indented character.
- Forgetting row height or text wrapping. The line break may be present even when the bottom of the cell’s text is clipped. Turn on Wrap Text and adjust the row height before assuming the entry failed.
- Using a long run of spaces to create a large gap. A wide offset can look uneven, especially if the font or column width changes. Use a small indent for readability; if you need precise page-style layout, use separate cells or a document editor.
Tips
- Use a consistent number of spaces. Decide on a small indent, such as two or three spaces, and use the same amount for similar entries. Consistency makes a worksheet easier to scan even though the spacing is not a formal paragraph property.
- Keep the paragraph in one cell when it belongs to one record. A manual line break is useful for a note, address, or short description that should stay attached to the same row and be copied, sorted, or filtered as one cell value.
- Use separate rows or cells for precise formatting. If each paragraph needs a different alignment, font, or spacing, place it in a separate cell or row. Excel gives you more reliable control over separate cells than over individual paragraphs within one cell.
- Check the result at the normal zoom level. A few spaces can look different at different zoom settings and with different fonts. Judge the result at the zoom level people will usually use, and avoid adding so many spaces that the paragraph seems detached.
- Be cautious when copying the text elsewhere. The line break and leading spaces travel with the cell’s text, but another application may display them differently. If you paste into a web form, email, or word processor, check the pasted result and adjust its formatting there.
Troubleshooting
The shortcut moves me out of the cell. First confirm that you are editing the cell, not merely selecting it. Press F2 or double-click the cell before using Alt+Enter on Windows. On Mac, try Control+Option+Return while the insertion point is inside the cell. Laptop keyboards, browser shortcuts, and remote desktop software can change how key combinations behave. If a shortcut is intercepted, try editing in the formula bar or use the desktop Excel app.
The second paragraph appears on the next worksheet row. That usually means Enter was pressed without inserting an in-cell line break, or the cell edit ended before the new text was entered. Undo if appropriate, reopen the original cell, place the cursor after the first paragraph, insert the line break, and then add the spaces and text. Confirm that the selection remains in the same cell while you edit.
The paragraph starts at the left edge despite the spaces. Check that the spaces come after the line break, not before it. If you can see spaces while editing but the offset is too subtle, add one or two more and check the cell in a standard font. Avoid using a tab character as the indent: tabs do not provide dependable paragraph spacing in worksheet cells.
The last lines are cut off or hidden. Select the cell and choose Home > Wrap Text, then increase the row height. AutoFit Row Height can help with ordinary cells, but merged cells may require manual resizing. Also check that the row is not hidden and that the text color is not the same as the cell fill.
The layout changes after resizing the column. Automatic wrapping depends on the available width, so a narrower column can create extra lines and a wider one can reduce them. The manual line break stays in place, but the visual indentation and paragraph shape may look different. Recheck the row height and spacing after changing the column width.
Frequently Asked Questions
Can I indent only one paragraph with Excel’s Increase Indent button?
No. Increase Indent changes the alignment of the selected cell, not an individual paragraph. To offset just one paragraph while keeping it in the same cell, insert a line break and add spaces at the beginning of that paragraph.
What is the Windows shortcut for a new line inside a cell?
In desktop Excel for Microsoft 365 on Windows, press Alt+Enter while editing the cell. Press Enter afterward to finish the edit. If Alt+Enter is captured by another program or remote session, try entering the line break in the formula bar.
What is the Mac shortcut?
In Excel for Mac, use Control+Option+Return to insert a line break while editing a cell. Keyboard layouts and Excel versions can affect shortcuts, so if it does not work, check Excel’s current keyboard-shortcut help or try editing the text in the formula bar.
Can I use a tab instead of spaces?
A tab is not a dependable way to indent text within an Excel cell. It may move focus or behave differently from one editing context to another. Use a few spaces after the line break for a simple visual indent, or put the paragraph in another cell for more control.
Will the indent remain when I sort or filter the worksheet?
Yes, the line break and spaces are part of the cell’s text, so they generally move with that cell’s row during sorting and remain in the value when filtering. The way the text looks can still change if the column width, font, or row height changes.
How do I indent every line in the cell?
Select the cell and use Home > Alignment > Increase Indent. Unlike spaces at the start of one paragraph, this is a cell-level alignment setting and shifts the cell’s text as a whole.
Related
- How to Find Duplicate Lines in Excel Without Deleting Them
- How to Find Duplicate Data in Excel: Step-by-Step Guide
- How to Find Duplicate Entries in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Close Group Excel Shortcut: Close Workbooks and RowsIn Excel for Microsoft 365 on Windows, press Ctrl+W to close the active workbook; Ctrl+F4 also closes the…
- How to Change Slide Size in PowerPoint to A3To change a PowerPoint presentation to A3, open the Design tab, choose Slide Size > Custom Slide Size,…
- Excel Cell Bullet Points: Add and Format Lists in CellsYes. In Excel for Microsoft 365 on Windows, edit a cell and press Alt+0149 on the numeric keypad…
- How to Change the Outlook View to Show a Message PreviewTo show a message preview in Outlook, turn on the Reading Pane: in new Outlook for Windows, select…
- Excel File Corrupted? How to Repair and Recover ItIf an Excel file is corrupted, first make a copy of it, then try Excel’s built-in repair: in…
- How to Remove the Green Triangle in an Excel CellTo remove a green triangle from an Excel cell, select the cell, click the warning icon that appears…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.