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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2012-06-25T13:46:47+00:00

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

    I need to change the line spacing within a cell all the time.

    Since number crunching in a spread sheet is useless if the cells aren't labeled, some degree of word processing is necessary.

    Changing line spacing is sometimes desirable in order to keep the cell and row spacing format even at the same time as fitting a label for a line in its cell without changing the font too much.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-08-08T06:05:07+00:00

    You are replying to a post by Hans who states in the post that you have no direct control over the spacing within a cell.

     

    That feature has not changed since April 16, 2011

     

     

    Gord

    If line spacing is not adjustable in excel, can someone tell me why I have two different line spacing in two cells in this file. My problem is that the double line spacing appears in an excel file passed to me and I would like to remove the double line spacing.

    Was this answer helpful?

    0 comments
  3. HansV 462.7K Reputation points MVP Volunteer Moderator
    2012-08-08T06:19:04+00:00

    When I open your workbook in Excel 2010, the two cells look exactly the same...

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-08-08T06:29:06+00:00

    Strange. They look different in Office 2003.

    See the screen capture.

    Was this answer helpful?

    0 comments