Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You might want to improve the look of the text inside a cell by changing the vertical line spacing. Although Excel offers no direct control for line spacing within a cell, you can use several text alignment strategies to adjust white space or make the text more readable. You can also add a text box, which offers more control.

In this article

Tight the spacing for text inside a cell

If your text inside a cell is too widely spaced, it might be vertically justified. You can often improve readability by changing the Text alignment to get the lines closer together.

  1. Right-click inside the cell you want to change, and click Format Cells.

    On the right-click menu, click Format Cells.
  2. On the Alignment tab, change Vertical to Top, Center, or Bottom, depending on where you want your text to be placed inside the cell.

    The Alignment tab of the Format Cells dialog box.
  3. Click OK. The text is evenly spaced.

    Your text is now aligned and evenly spaced where you wanted it.

    Tip: If you have lots of white space in one cell because another cell on the same row has more content, you can change the vertical alignment for the cell with too much space to Center to fill the space more evenly.

Top of Page

Increase the spacing for text in a cell

If your cell has white space, and you want to increase the line space to fill it evenly, change the vertical spacing to Justify.

  1. Right-click in the cell you want, and click Format cells.

  2. On the Alignment tab, change Vertical to Justify.

  3. Click OK.

    Your text is now distributed evenly inside the cell. If you change the height of the row, the text re-adjusts evenly to the new width.

Top of Page

Replace the text in a cell with a text box

If you have only few cells with text that need to be modified, you can consider inserting a text box on top of the cell. By using a text box instead of a cell, you have more control over text formatting.

  1. Double-click the cell you want to modify, select all of the text in it, and press Ctrl+X.

    The text is selected.
  2. Click another cell to deselect the cell.

  3. Adjust the height of the row, if needed.

  4. On the Insert tab, click Text Box.

    Click Text Box.
  5. Move the cursor to the upper-left corner of the cell you want, and click and hold to draw a text box that fits the cell. If you need to adjust the size of the text box after creating it, drag the selection squares at the edges.

  6. Click in the text box to activate it, and press Ctrl+V to paste your text inside the text box.

    The new text is pasted in the text box.
  7. Select all of the text in the text box, right-click it, and click Paragraph.

    On the right-click menu, click Paragraph.
  8. Select the line spacing you want.

    Image of the Paragraph dialog for editing text box text indents and spacing

    Tip: You can also tighten the text by reducing the font size. Select the text, then right-click on it, click Font, and select the font size you want.

    Note: The text box is not inside the cell but floats over it. If the row on which it was inserted moves as the content above is changed, the text box does not move along with the cell. To move the text box, move the cursor to the edge of the text box, and click and hold to drag the text box to a new location.

Top of Page

See Also

Add, copy, or delete a text box

Change the format of a cell

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×