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
    2017-02-11T01:39:21+00:00

    Line (before/after) spacing carries over when cutting/pasting from Word for me; it must have the ability to control this parameter at least?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2016-03-10T05:05:08+00:00

    Hi, if there's no direct control over the line spacing within a cell, then could we use some work-around?

    It is really a needed feature for the final touch while designing the price lists and other similar materials where Excel is the best choice due to the large number of calculated data in various tables.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2012-05-09T04:36:10+00:00

    I see no reason to prevent this feature in Excel

    Fact that there was not prior such a feature doesn't mean that it should not be included now

    Always there is a first time for everything, don't you agree?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. HansV 462.7K Reputation points MVP Volunteer Moderator
    2011-09-28T08:48:40+00:00

    No, you can only enter font sizes in points, in increases of 0.5 points.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments