How do I change the spacing between lines in Excel 2010?

Anonymous
2011-04-16T19:05:07+00:00

Original Title: "2010 excel line spacing"

How do I change the spacing between the lines in 2010 excel, Is there a way to make the lines closer together

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
HansV 462.7K Reputation points MVP Volunteer Moderator
2011-04-16T20:12:20+00:00

Do you mean within a cell with text wrapping turned on? You can only change the font size, you have no direct control over line spacing within a cell.

If you mean between cells, you can change the row height, of course.

Was this answer helpful?

80+ people found this answer helpful.
0 comments

65 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. HansV 462.7K Reputation points MVP Volunteer Moderator
    2014-08-12T18:57:22+00:00

    How does row height influence line spacing within a cell?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-08-12T18:00:55+00:00
    • Change the layout to Page Layout (status bar).
    • Home tab > Cells group > Format > Row Height
    • Enter: 1 in (see figure)

    Don't be so rude by saying it's a no brainer, everyone has to learn

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-08-05T18:03:05+00:00

    Hi all. There is only one way to this. Copy the text box in word. Change the line spacing and copy back to excel. It works!!!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-07-01T12:52:56+00:00

    I had the problem with increasing the spacing of lines in a single merged cell. Just playing around I found that pressing the Alt key then Enter did the trick for me. However I couldn't adjust how big the space was.

    Was this answer helpful?

    0 comments