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
    2012-05-16T21:50:02+00:00

    I mean text line-spacing, as in Word.   I have done it in Excel, but with difficulty.   I had to go into Word and copy text into the Excel cell.   I have tried to do it again, but can't remember how I did it.    My Excel entries have the same 10-point line spacing as in my Word setting.

    There should be a way to control this in Excel (when text-wrapped) as in Word.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2012-05-09T13:49:32+00:00

    I agree that it may be a good feature for those who need Excel to have word processing capabilities.

    I just posted to point out I did not agree that it it had been "taken out" as you stated.

    Gord

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2012-05-09T04:35:49+00:00

    thanks

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2012-05-08T14:31:26+00:00

    No version of Excel has ever had a line spacing function so it was never "taken out" as you state.

    Office comes bundles with Word.................use that application for your word processing and leave Excel to the number-crunching.

    Gord

    Was this answer helpful?

    0 comments No comments