How to Change Line Spacing in Excel
Excel has no single “line spacing” button like Microsoft Word, but you can absolutely control the space between lines of text. The fastest way to add space between lines in a cell is to widen the row height and set the cell’s vertical alignment to Distributed (Indent) or Justify — this spreads wrapped text evenly from top to bottom. For spacing between separate rows of data, you simply increase the row height.
This guide covers every method for changing line spacing in Excel: spacing within a single cell, spacing between rows, and the keyboard and dialog-box techniques that work on both Windows and Mac. Because Excel treats “lines” differently from a word processor, knowing which method to reach for is the real trick.
Line Spacing in Excel: How It Actually Works
Word processors store text as flowing paragraphs, so “1.5 line spacing” is a built-in setting. Excel stores text inside cells, and each cell sits in a row with a fixed height. That means “line spacing” in Excel splits into two separate ideas:
| What you want | What you actually adjust |
|---|---|
| More space between rows of data | Row height |
| More space between wrapped lines inside one cell | Vertical alignment + row height |
| A visible line break inside a cell | A manual line break (Alt + Enter) |
| Tighter, denser text | Smaller font size or autofit row height |
Once you know which of these you need, the steps are short. Note that the old “Line Spacing” dropdown some tutorials reference does not exist in modern Excel for cells — that control belongs to text boxes and shapes, not worksheet cells.
Method 1: Add Space Between Lines in a Single Cell
This is the method most people searching for “line spacing in a cell” actually want. It works when a cell contains text on multiple wrapped lines and you want even spacing between those lines.
Step 1: Turn on Wrap Text
Select the cell, go to the Home tab, and click Wrap Text in the Alignment group. Your text now breaks onto multiple lines inside the cell instead of spilling sideways. If you need a refresher on this, see our guide to wrapping text in Excel.
Step 2: Open Format Cells
Right-click the cell and choose Format Cells, or press Ctrl + 1 (Windows) / ⌘ + 1 (Mac) to open the Format Cells dialog box directly.
Step 3: Set Vertical Alignment to Justify or Distributed
On the Alignment tab, open the Vertical dropdown and choose:
- Justify — spreads the wrapped lines evenly from the top of the cell to the bottom.
- Distributed (Indent) — similar even spacing, with optional indents on both sides.
Step 4: Increase the Row Height
The spacing only becomes visible when the row is taller than the text needs. Drag the bottom border of the row’s number header downward, or right-click the row number, choose Row Height, and enter a larger value. As the row grows, the justified lines spread further apart. This is the closest Excel gets to true “double spacing” inside a cell.
Method 2: Change Space Between Rows (Row Height)
If your queries are really about the gap between separate rows of data, you just need to change row height — there’s no alignment trick involved.
On Windows and Mac
- Click the row number to select the whole row (or drag to select several rows).
- Right-click and choose Row Height.
- Enter a number (the default is around 15 points for the standard font) and click OK.
You can also drag the boundary between two row headers to resize visually. To make every selected row the same size at once, select them all first, then drag any one boundary. For the full walkthrough, see how to adjust row height in Excel.
To let Excel size rows automatically to fit their contents, double-click the boundary below a row header, or use Home → Format → AutoFit Row Height. Our AutoFit guide covers this in depth, and the same idea applies to widening columns when text runs sideways.
Method 3: Add a Manual Line Break Inside a Cell
Sometimes you don’t want extra spacing — you want to force text onto a new line at a specific point (for example, an address block). That’s a manual line break, not line spacing.
| Platform | Shortcut to insert a line break |
|---|---|
| Windows | Alt + Enter |
| Mac | Control + Option + Return |
Double-click into the cell, place your cursor where the break should go, and press the shortcut. Excel automatically turns on Wrap Text for that cell. See how to create a new line in an Excel cell and starting a new line within a cell for more examples.
To insert line breaks with a formula instead of by hand, use CHAR(10) (the line-feed character) inside a CONCAT or & formula, then enable Wrap Text. CHAR(10) is the correct code on both Windows and Mac in modern Excel. For instance:
="Line one"&CHAR(10)&"Line two"The text won’t break visually until Wrap Text is on. More on this in entering a new line in Excel.
Method 4: Fake Extra Spacing With Font and Indent
When Justify isn’t giving you enough control, two formatting tweaks help fine-tune the look:
- Smaller or larger font size changes how much vertical room each line needs. Pairing a slightly smaller font with a taller row creates visible breathing room. You can also lock in a consistent look across the workbook by setting a default font in Excel.
- Indent pushes text in from the cell edge for horizontal breathing room. Use the Increase Indent button on the Home tab, or read how to indent in Excel and increase indent.
For overall cell sizing, expanding cells, making cells bigger, and making cells fit text all interact with how spacing reads on screen.
Method 5: Line Spacing in Text Boxes and Shapes
If you’ve inserted a text box (Insert → Text → Text Box) rather than typing into a cell, you do get true line-spacing control. Select the text, right-click, choose Paragraph, and set Line Spacing to Single, 1.5, Double, or an exact point value — exactly like Word. This is the only place in Excel where a real line-spacing dropdown lives, which is why some tutorials describe a control you can’t find in regular cells.
Troubleshooting Line Spacing
- Justify did nothing. The row isn’t tall enough. Increase the row height (Method 2) so there’s empty space for the lines to spread into.
- My text is one long line. Wrap Text is off. Turn it on (Home → Wrap Text) so the cell can show multiple lines.
- Spacing looks uneven after merging. Merged cells handle wrapping and alignment unpredictably. Consider merging cells without losing data or unmerging cells and using Center Across Selection instead.
- Hidden spaces are throwing off alignment. Stray spaces in your text can distort how it wraps. Clean them up with the TRIM function or by removing extra spaces.
- Text won’t center vertically. Set the Vertical alignment to Center in Format Cells; you may also want to center text horizontally for a balanced look.
Quick Reference: Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Open Format Cells | Ctrl + 1 | ⌘ + 1 |
| Insert line break in cell | Alt + Enter | Control + Option + Return |
| Toggle Wrap Text (ribbon) | Alt → H → W | (use ribbon button) |
| AutoFit row height | Alt → H → O → A | (double-click row border) |
Frequently Asked Questions
How do I change line spacing in Excel?
Excel has no single line-spacing setting for cells. To add space between lines inside a cell, turn on Wrap Text, open Format Cells (Ctrl + 1), set Vertical alignment to Justify or Distributed, then increase the row height so the lines spread out. To space separate rows apart, just increase each row’s height.
How do I add line spacing in a single cell?
Enable Wrap Text on the cell, press Ctrl + 1 to open Format Cells, go to the Alignment tab, and choose Justify under the Vertical dropdown. Then drag the row taller. The wrapped lines will distribute evenly across the extra vertical space.
How do I add space between lines in Excel without changing row height?
Without extra row height there’s nowhere for the lines to spread, so true spacing requires a taller row. As a workaround, insert manual line breaks (Alt + Enter on Windows, Control + Option + Return on Mac) and add an extra blank break between each line to push them apart visually.
What is the keyboard shortcut for line spacing in an Excel cell?
There isn’t a dedicated line-spacing shortcut. The closest is Alt + Enter (Windows) or Control + Option + Return (Mac) to insert a line break, combined with Ctrl + 1 / ⌘ + 1 to open Format Cells where you set Justify alignment.
Why doesn’t Excel have a line spacing option like Word?
Excel stores text in cells within fixed-height rows rather than flowing paragraphs, so spacing is controlled by row height and vertical alignment instead of a paragraph setting. The one exception is text inside text boxes and shapes, which do offer a true Line Spacing control under Paragraph.
How do I make line spacing consistent across a spreadsheet?
Select all the rows you want to match, set the same row height for them at once, and apply the same vertical alignment (Justify or Center) in Format Cells. Using AutoFit row height on the whole selection keeps spacing uniform as content changes.
Conclusion
Changing line spacing in Excel comes down to three levers: row height, vertical alignment, and manual line breaks. For space between lines inside a cell, wrap the text and justify it in a taller row. For space between rows of data, simply resize the rows. And for word-processor-style spacing, drop your text into a text box. Combine these with clean text and consistent row heights, and your spreadsheets will read clearly on any screen or printout.
