To indent only one line inside an Excel cell, edit the cell, place the cursor at the start of that line, and type a few spaces. Press Alt+Enter on Windows to add another line within the same cell. Excel’s Home > Alignment > Increase Indent command is different: it indents all the cell’s contents, not just one line. Turn on Wrap Text if you need the lines to display clearly.
What You’ll Need
- Excel for Microsoft 365 on Windows. The main steps also work in recent desktop versions of Excel.
- A cell containing text, or a blank cell where you can enter it. If the cell has a formula, editing the formula directly may change its result, so consider making a copy first.
- Optional: a wider column or a taller row if the indented text does not fit on screen.
You do not need a special add-in or setting to indent one line. The key is to distinguish spaces that are part of the cell’s text from the alignment indent setting, which applies to the cell as a whole.
Step-by-Step
- Select the cell and start editing it. Click the cell, then press F2 or double-click it. You can also select the cell and click in the formula bar. If you are entering new content, select a blank cell and begin typing. Editing mode matters because you need to position the text cursor inside the cell, rather than replace the whole cell’s contents.
- Place the cursor where the line should begin. For an existing paragraph, move the insertion point to the start of the line you want to indent. You can use the arrow keys while editing, or click near the beginning of the line. If the cell contains one long line and you want to make a new indented line, move to the point where the break should go.
- Insert a line break if needed. On Windows, press Alt+Enter to start a new line without leaving the cell. For example, you might enter a heading, press Alt+Enter, type several spaces, and then type a detail on the next line. To edit an existing cell, first enter edit mode and position the cursor; pressing Alt+Enter while a cell is merely selected may not put the break where you intend.
- Type spaces at the start of the line. Press the spacebar two or more times, then type the line’s text. The spaces are characters in the cell, so they move that line’s text to the right while leaving other lines unchanged. Use a small, consistent number of spaces; repeated spaces are a simple visual indent, not a special paragraph-format setting.
- Repeat for any other lines that need indentation. Insert each line break with Alt+Enter, then type the desired spaces before that line’s text. You can leave a heading or first line unindented and indent only its supporting details. Keep the breaks and spaces within the same cell; do not press Enter by itself, because that normally finishes editing and moves the selection to another cell.
- Finish editing and check the display. Press Enter to commit the changes. Select the cell and choose Home > Wrap Text if the lines are not visible. If the row does not expand enough to show them, use Home > Format > AutoFit Row Height, or drag the row boundary to make the row taller. Widening the column can also reduce unwanted wrapping.
- Use Increase Indent only when the entire cell should move. Select the cell and go to Home > Alignment > Increase Indent. Each click adds an alignment indent to the cell’s contents. Use Home > Alignment > Decrease Indent to reduce it. This option is useful for a whole-cell indent, but it cannot indent just one line or paragraph inside a cell.
- Check the final result in the worksheet. Click another cell, then return to the edited cell and confirm that the intended line starts farther to the right. If you see extra gaps or the line breaks in unexpected places, reopen the cell and adjust the number of spaces, the break location, or the column width.
On Excel for Mac, use Control+Option+Return to insert a line break while editing a cell. The ribbon command for whole-cell indentation is still on the Home tab in the Alignment group. In Excel for the web, line breaks and spaces can be entered in a cell, but some editing and ribbon details may differ slightly from the Windows desktop app.
Common Mistakes
- Expecting Increase Indent to affect only the current line. Excel applies that alignment setting to the cell’s contents as a unit. To indent one line, add spaces at the beginning of that line instead.
- Pressing Enter when you mean to add a line break. Enter normally commits the cell entry. Use Alt+Enter on Windows, or Control+Option+Return on Mac, while editing the cell to keep the next line in the same cell.
- Adding spaces before the wrong text. If you type spaces while the cell is selected but not in edit mode, you may replace its contents. Start editing first, then put the cursor at the exact beginning of the line you want to indent.
- Using too many spaces. A large indent can make text appear disconnected or cause it to wrap onto several lines. Start with a few spaces and adjust after checking the cell at its normal column width.
- Confusing a visual indent with separate data. Line breaks and leading spaces stay inside one cell. They do not create separate rows or values. That is helpful for display, but it can make sorting, filtering, or using the text in other calculations less convenient.
- Assuming Wrap Text adds indentation. Wrap Text controls how text flows onto lines; it does not add leading spaces. Use spaces for a line-specific indent, then use Wrap Text as needed to show the result.
Tips
- Use a deliberate pattern. For example, keep the first line as a label and indent the next two lines as supporting details. Using the same number of spaces on similar rows makes a worksheet easier to scan.
- Keep the content in one cell only when that structure is useful. A multiline cell works well for a compact note or label. If each line needs to be sorted, filtered, or analyzed independently, put the items in separate cells or rows instead.
- Use the formula bar for long entries. Clicking in the formula bar can make it easier to find a specific line in a cell with a lot of text. Position the cursor carefully before inserting a break or spaces, then check the cell itself after committing the edit.
- Adjust the row rather than adding more spaces to solve clipping. If the indented line is cut off vertically, AutoFit Row Height or a manually taller row is usually the right fix. If it is cut off horizontally, consider widening the column or enabling Wrap Text.
- Be cautious with copied text. Text pasted from a web page or document can include its own line breaks and leading spaces. If the result looks uneven, edit the cell and remove unwanted breaks or spaces rather than applying a larger whole-cell indent.
- Remember that spaces affect the actual text. If another formula, export, or system reads the cell’s contents, the spaces and line breaks may be included. If the cell is only for presentation, that may be fine; if the text is used as data, keep formatting separate where possible.
Troubleshooting
The line break starts a new worksheet row. You probably pressed Enter while the cell was selected rather than inserting a break during editing. Reopen the cell, place the cursor at the intended position, and use Alt+Enter on Windows. On Mac, use Control+Option+Return. Then commit the edit with Enter.
The spaces disappear or the text does not look indented. Confirm that the cursor is inside the cell and that you typed spaces before the line’s first character. The whole-cell alignment may also make a small space hard to notice. Try a few more spaces, check the cell at a larger zoom, and make sure the line is not clipped by the column boundary.
Only the first line appears. Select the cell and choose Home > Wrap Text. If the row remains too short, choose Home > Format > AutoFit Row Height. Merged cells can behave differently with automatic row sizing, so if AutoFit does not work with a merged cell, increase the row height manually.
Every line moves when you click Increase Indent. That is the expected behavior of the alignment indent. Use Undo if you just applied it and did not want the whole cell moved, or choose Decrease Indent to remove an existing alignment indent. Then edit the cell and add spaces only to the line you want shifted.
The indentation changes after resizing a column. Spaces take up character width, and wrapping depends on the available column width. A narrower column can push text onto additional lines, making the original indent look larger or less consistent. Adjust the width, row height, or number of leading spaces, and review the result at the worksheet’s intended size.
The cell contains a formula and editing it causes problems. A formula cell displays a calculated result, and typing spaces into it would overwrite or alter the formula. If you need a formatted note, use a separate cell. If the formula’s displayed text itself must include line breaks or spaces, the formula needs to be designed to return that text; keep a copy of the original formula before changing it.
Frequently Asked Questions
Can I indent just one line in an Excel cell?
Yes. Edit the cell, place the cursor at the beginning of that line, and type spaces before its text. The spaces affect that line, unlike Increase Indent, which applies to the whole cell.
How do I put two lines in the same cell?
While editing the cell, press Alt+Enter on Windows at the point where the second line should start. On Mac, press Control+Option+Return. Type the second line and press Enter when you are finished editing.
Does Increase Indent add spaces to the cell?
No. Increase Indent changes the cell’s horizontal alignment formatting; it does not insert space characters into the text. It moves the cell’s contents together and is not a per-line indent control.
Can I use the Tab key to indent text inside a cell?
Usually, no. In Excel, Tab moves the selection to another cell rather than inserting an indentation character in the current cell. To indent one line, edit the cell and use spaces. To move all cell contents, use Increase Indent on the Home tab.
Will the indent print or appear when I copy the cell?
Spaces and line breaks typed into the cell are part of its text, so they generally appear in the worksheet and print with the cell’s contents, subject to print scaling and wrapping. A whole-cell alignment indent is formatting and can behave differently when copying only values. Check Print Preview if the exact layout matters.
Is there a keyboard shortcut for Increase Indent?
Excel does not provide a standard direct keyboard shortcut for the Increase Indent ribbon command. Select the cell and use Home > Alignment > Increase Indent. For a single line, edit the text and add leading spaces instead.
Related
- How to Find Copilot in Excel and Check Your Access
- Days Between Two Dates in Excel: A Simple Guide
- How to Find Blank Rows 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
- How to Ensure Track Changes Is On in Microsoft WordTo ensure Track Changes is on in Microsoft Word, open the document, select Review > Track Changes, and…
- How to Add a Header Underline in Word for Every PageTo add a line beneath a header in Microsoft Word, open the header, click its paragraph, then choose…
- Excel Save As Shortcut: Windows, Mac, and WebIn Excel for Microsoft 365 on Windows, press F12 to open the Save As dialog. On a Mac,…
- Box and Whisker Plot in Excel: Set It Up Step by StepTo create a box and whisker plot in Excel for Microsoft 365 on Windows, arrange each group of…
- How to Add a Running Header in Word for MacTo add a running header in Word for Mac, open the document, choose Insert > Header & Footer…
- Find Duplicates in Excel: A Practical Step-by-Step GuideTo find duplicate values in Excel, select the cells you want to check, then choose Home > Conditional…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.