Hi,

The easiest (and non programmatic) way to do this is to highlight the sheet,
and mouse over one of the row divisions (i.e. between 2 rows, which you
would normally use to resize). Double clicking here will expand all rows to
autofit contents.

Otherwise, try running this Macro:

Sub FitMeUp()
Cells.Select
Cells.EntireRow.AutoFit
Range("A1").Select
End Sub

Hope this helps.

Warm regards

Sunil Jayakumar


"bobf" wrote in message
...
I have a spreadsheet where one column is cells that each
contain 30 to 50 words of text. Even after applying
FORMAT, ROW, AUTOFIT when I print I lose the top 50% of
the characters in most, but not all, of the top line of
these cells. Everything looks fine on screen prior to
printing. Has anyone any ideas or work-rounds, please?

www.ayyoo.com/credit-cards.html