View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default Wrap text in column headers to fit text in column

You may want to consider using alt-enter to force new lines within the cell.
Then you'll be able to break each header line where you want it.

MarkN wrote:

Hello,

I get about forty columns of data dumped into an Excel sheet every month.
The column headers at the top of the columns are usually considerably wider
than the data in the columns. I want to wrap the header text in each column
so that it is as wide as the widest entry in the rest of that column. Each
column width is diferent.

If anybody knows a quick method of doing this, it would save me a lot of time.
--
Thanks,
MarkN


--

Dave Peterson