How to change Colum Width in automatically in Excel

Question

Hey, Folks! I want to colum width automatically in my excel sheet looks like this

and I want to change look like this

I save this but I close the excel and I open never change

question from:https://stackoverflow.com/questions/65901867/how-to-change-colum-width-in-automatically-in-excel

Answer 1

1. I would advise saving the document as the Excel-macro one .xslm.

2. Next open Developer and select Visual Basic. If you don't have the one, customize your ribbon: https://wellsr.com/vba/excel/enable-developer-tab/

3. In the VBA Excel project find the sheet you are working on

4. Provide the VBA code like this:

   Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   
   Columns("C").ColumnWidth = 15
   
   End Sub
   

https://docs.microsoft.com/en-us/office/vba/api/excel.range.columnwidth

Every time you open this sheet it should be as wide as you defined in the code.