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,
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.