Auto column width adjustment

[Salamullah]

Hi,

Due to the fixed column width the figure more than width is showing ###### and need to double click to see the figures, how column adjust itself automatically ?

<colgroup><col></colgroup><tbody>
</tbody>

 

[Joe4]

How are these cells populated? Manually? By formula?

When would you like this columns to self adjust?
When the file is opened? When an entry is made is certain cells?

 

[Salamullah]

by formula
Self adjust as well as when an entry is made in certain cells

 

[Joe4]

What cells are these formulas that you want to auto fit in?
What do these formulas look like (can you post an example)?