How do I change the spacing between lines in Excel 2010?

Strange indeed - in my Excel 2010, cell B1 looks the same as cell A1.

Asolutely correct!  If Microsoft's impementation would have been better this may not have been as critical of an issue.  However, their default is such that headings that are entered on two lines (or also wrapped) in the same cell, have too much spacing between the text and too little spacing between the text and borders.  Increasing the height of the row helps a little bit, but it still does not address too much spacing between the text.  For a crude example (a little over-exaggerated as text only) and assuming that each example is one cell, see the following:

THIS IS WHAT WE CURRENTLY GET IN EXCEL 2010 :

_______________

   EMPLOYEE

        NAME           

THIS IS WHAT WE WOULD LIKE :

_______________

EMPLOYEE

 NAME

We could very easily get the results we needed if there were a very simple line spacing setting that could be applied to cells or ranges. 

Another pet peave is that we cannot set cell margins or spacing between text content and borders.  All too often we have to waste time changing the row height and text alignment settings just so the text in the bottom row of a table doesn't look like it crowds up against the bottom border of a table, which is often a thicker border!

Excel is an industry standard for making tables for important presentations, but it lacks the most simplest spacing tools for providing a  visually pleasing table.

I haven't found a way to directly alter line spacing in Excel, but here are a couple of suggestions.

If you have this problem:

_______________

   EMPLOYEE

        NAME           

Right click on your cell and choose "format cell".  On the "Number" tab, set the category to text. On the "alignment" tab, set the "Horizontal" to general, and the "Vertical" to top.

Finally (and most important). Change the font. The Calibri font in Excel 2010 inherently has more space between lines than other fonts (plus it looks like the font a 6 year old would choose!). Arial probably looks the most professional on spreadsheets, but play around with other fonts until you find what you're looking for.

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

I agree with all of the other Excel and Office users.  The Excel default (and only) spacing allowed between lines almost always produces too much space.  It makes the result look amateurish and that the user doesn't know better.  With all of the similar comments about the obvious need, it is time for Microsoft to make this change / update / enhancement.  Of course, it exists within Word 2010 and there are multiple ways to change spacing.