Resize Excel Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to resize the height of Excel cells so that they fit tightly
around data?

I know how to select a range and use the cursor "hair" to change all the
cells ot the same height. But i hate the idea of going to each cell just to
make sure all the text is visible.

Thanks!
 
Not sure if this is any help but double clicking between the row and column
headers resizes the row/column to fit the text.

Matthew
 
Its too many rows about 200 or so. I don't want to have to do it manually.
 
Thanks Matthew! It does work!!! I have to wait until it turns into a double
headed arrow between lines in the number header.

I was able to just highlight the whole section and just double click and it
resized everything. Thanks!
 
You must log in or register to reply here.

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

Similar Threads

Resizing merged / wrapped cells. 2
Resize cell to fit picture 3
Excel VBA For excel 0
Scrolling Within a Cell 1
Auto fit wrapped and merged cells in entire worksheet 8
Auto-adjust row height does not work correctly 2
Turning Auto Height Back On 2
How do I autofit row height to adjust to new text on Excel form? 1

Back
Top