Auto column width adjustment

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
218
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>
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,156
Office Version
365
Platform
Windows
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?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,156
Office Version
365
Platform
Windows
What cells are these formulas that you want to auto fit in?
What do these formulas look like (can you post an example)?
 

Watch MrExcel Video

Forum statistics

Threads
1,089,862
Messages
5,410,856
Members
403,331
Latest member
dignityy

This Week's Hot Topics

Top