hello please help how can i increase by 1 every time i drag in coulmn?like so=SUM($A$1:$A1)=SUM($A$1:$A2)=SUM($A$1:$A3)thanks
Set a column to a specific width
Select the column or columns that you want to change.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click Column Width.
In the Column width box, type the value that you want.
Click OK.