can't format rows to autofit

J

jbf

I am new to excel, I understand how to autofit and wrap text, however, the
autofit will not work on one of my worksheets. I can only autofit one row on
the whole sheet.
 
S

sweet_dreams

in fact i don't understand what you mean. Can you explain what You
would like to do and what excatly is Your question.

regards,
sweet_dreams
 
G

Gord Dibben

Do you have merged cells on this sheet?

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP


I am new to excel, I understand how to autofit and wrap text, however, the
autofit will not work on one of my worksheets. I can only autofit one row on
the whole sheet.
Click to expand...

Gord Dibben MS Excel MVP
 
Top