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: Newest
  1. HansV 462.7K Reputation points MVP Volunteer Moderator
    2017-02-11T11:38:29+00:00

    Line (before/after) spacing carries over when cutting/pasting from Word for me       

    Not in any version of Microsoft Office that I have used (from 4.0 to 2016)...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. 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
  3. Anonymous
    2016-06-24T15:26:29+00:00

    Thank you for your shortcut, it's very clever!

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2016-06-23T00:05:10+00:00

    We use Excel to create things such as labels for a phone, printed forms, and so forth.  We are wrapping, but the label size cannot be changed, so enlarging the cell to hold the data is not an option.  Making the font smaller works for certain things, but for others the printed form becomes too small for most people to read easily (depends on word size, location and volume of data).  Line sizing would be the final factor to take care of most of the remaining problems.  Abbreviation only works as far as it is understood by the person reading it later.

    !!!  Just thought of one workaround to share.  One can add new rows (and/or columns) & merge OTHER cells as appropriate to keep the overall size correct.  Then only add the words that fit to the edge of the COLUMN width (where it would wrap if it were in a single cell).  Continue the data on the next row to the end of that COLUMN, and so forth.  When finished adding data, manually size the ROWS to get rid of excess white space above and below each one.  If the spreadsheet uses borders, remove any horizontal borders that appear between lines of the data that was formerly in one cell.

    Below is a graphic to help show what I mean.  Some cells were centered vertically, as needed (B1/B2, e.g.).

    Since this template contains other "forms" to the right, I needed to make choices on how to handle that data, which I will explain below.

    1. I inserted a new row below row 1 in my original, and moved the last names to the row below (alternately, I could have merged the non-problem cells).

    1. Since previously the full height of each row for this particular form was 25.5 (34 pixels), dividing it in half equals 12.75 (17 pixels).   I selected rows 1 and 2 and reduced the height to 12.75 (17 pixels).  Since I had selected both rows, their heights were changed simultaneously.
    2. Next, I removed the horizontal border between the first and last name for Maximillian and Samantha (and will do the same for Jim and his number).

    4. Merging B1 and B2, made the combined cells the exact size of the original.  Cell also needed to be centered horizontally.  For Samantha and Jim I opted to split the data over the two rows instead of merging. 

         A. The area codes were interpreted by Excel as negative numbers, so I entered them as '(800) and '(123).  The ' (single quote) at the beginning of the data is a shortcut to let Excel know that this cell is to be formatted as text. 

    1. I also needed to merge each of the cells to the right until I reached the margin for that page.

         A. Merging can easily be done by copying the merged cells (with the number in my sample below) and pasting it to the right.

         B. Then press Delete to remove the copied data (in this case, the phone number), and recopy the merged cell, pasting wherever needed on the form.

         C. Alternately, one can copy the formatting and paste to the desired cells.

         D. Second alternative: Instead of merging, the "oversized" data (names in my sample) that tended to wrap to three lines for my form can all be placed in subsequent cells to the right, but on the same rows.  Then the telephone numbers (as in my sample) can be split up between two rows without merging.  E.g., place the area code in the cell on the top row, and the phone number on the second row.

    NOTE 1: New lines only need to be inserted where necessary.

    NOTE 2: You may have noticed that column A is wider than column C.  This is not acceptable for this form, but was adjusted for the sample.  A line spacing option similar to Word is still necessary as reducing data to a size 8 font is just too small.  C2 was reduced to 9 point font which is workable, but too small for many people.  With line spacing a hyphen can be added (as Rumpelstilt-skin), and Excel will spread it over 3 lines.  Yes, a third row could be added, and each row could be reduced to 8.5, but even centering vertically, it just doesn't work until it is an 8 point font.  Again, not acceptable.

    We need line spacing, please!

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments