After setting to wrap text, set the rows to Autofit.

FormatRowAutofit.



Gord Dibben MS Excel MVP

On Wed, 21 Jan 2009 07:43:02 -0800, Meenie
wrote:

someone sent one of my managers a huge document (page setup as portrait and
letter) to print it page setup had to be changed to landscape and legal, but
it still wouldn't print everything across the rows on one page (49 pages long)

they had put the peoples names across the column with no word wrap. I
changed that column to word wrap, but the row doesn't open to show the whole
name... the row has to be manually moved down on each one to show the whole
name!
How can I make it open without doing each one separately??
I have excel 2003