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 No 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 No comments

65 additional answers

Sort by: Most helpful
  1. Anonymous
    2014-05-06T14:53:36+00:00

    Seriously, this is a major flaw with Excel.  You should be able to select or deselect "double spacing" as an option within a cell.  It seems ridiculous that this is omitted.  If you highlight text in Word with the Format Painter and then select text in an Excel cell, it should match the formatting to the Word formatting as well.  Major flaw.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2014-03-19T20:54:40+00:00

    I just added a "1" in my font text box and it worked just fine.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-02-23T13:44:01+00:00

    Note that with some of the font options the spacing is narrower.... I have used Arial Narrow...

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2014-02-03T16:35:49+00:00

    Agree.

    Was this answer helpful?

    0 comments No comments