highlight the entire sheet and double click on the line between 2 cells
will resize all the column/row to fit the longer text string.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=387554