### in row & won't "auto fit" - how do I show all text?

G

Guest

I can't get my rows to "auto-fit" to correct height allowing all text to be
seen. I select the row then go to Format>Row>autofit, but this does not add
to row height and ##### remains as only visible text in cell.
 
G

Guest

I think that you might want column autofit not row. Row adjusts the height
and column adjusts the width.

Regards,

OssieMac
 
G

Gord Dibben

Excel has a problem when the number of characters in a cell is between 255 and
1024 if that cell is formatted as Text.

Change the formatting to General and the ######'s should go away.



Gord Dibben MS Excel MVP
 

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

Auto fit row height 2
Auto fit and text wrapping problem 1
How do I stop Excel from automatically resizing my row height? 0
Use autofit to row height.But row does not expand 2 cover content 1
AUTO ROW HEIGHT 2
Excel autofit row height not working 0
Referencing a cell in other worksheet that is using autofit row he 3
Why does my text in a cell with wrap text and auto height get cut 4

Top