how to reduce line space in excel

G

Guest

I use wrap text to manage long message in a cell. but I think the space is
too large. how to reduce it (like formatting line spacing in MS word)?
thanks,
 
D

Dave O

When you float your cursor over the column headers in Excel, the cursor
turns into a black cross. In that black cross state you can double
click and the column will auto-fit to accommodate text.

Similarly if you float the cursor over the row numbers, you can double
click when the cursor is a black cross, and the line will auto-size to
fit row height.

This also works on multiple columns or multiple rows, if they are
highlighted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top