View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
June7 June7 is offline
external usenet poster
 
Posts: 11
Default Autofit to contents

Do you mean to adjust the width? Not that I know of. Would have to build
code to handle that. You can set cell Format/Alignment property to wrap text
and the row height will expand to acommodate the wrapped text.

"Donna" wrote:

Is there a way to format an Excel worksheet to "autofit to contents" the way
it works in a Word table?