View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Columns.Autofit not doing what I want

. . . and maybe Excel doesn't behave like I want, but if anyone can help
me, I'd appreciate it. What I want is the column to fit a logical word or
group. But I have A7X-00090, and AutoFit makes it fit the A7X-, squeezing
the 00090 to another line. Similarly, a header is Identification, but it
breaks between the last t and i because that's the longest whole word in the
column under that header. Is there any way to tell Excel what I want
besides setting individual column widths by size number?

Ed