I want excel to adjust the height of the row correctly
J JE McGimpsey Nov 9, 2004 #2 If you've manually set the row height, choose Format/Row/Autofit to restore the default behavior. If instead you've got cells merged (which IMNSHO you shouldn't, but people do anyway), you'll need to use VBA. See Jim Rech's macro: http://google.com/groups?selm=uGMQVjd0CHA.2296@TK2MSFTNGP10
If you've manually set the row height, choose Format/Row/Autofit to restore the default behavior. If instead you've got cells merged (which IMNSHO you shouldn't, but people do anyway), you'll need to use VBA. See Jim Rech's macro: http://google.com/groups?selm=uGMQVjd0CHA.2296@TK2MSFTNGP10