Format>Row>Autofit

[fostertom]

Hi

in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far.
Text was imported from Word, other Excels etc. Up to 10 lines of text in some
cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells.

Problem is, Format>Row>Autofit is unreliable. For 90% of cells works fine
but some either show white space between text lines, or shrink too much,
cutting off last text line(s). If adjusted manually, seems unstable - will
revert for no reason.

 

[Dave Eade]

Looks like you need to remove the formatting before you pasted into the new
spreadsheet.

when youu paste - if you use paste special there should be an option to
remove the fomatting so you just paste text. Anywhite space will have to be
removed manually.