Auto sizing cells when opening workbook

[Noob80]

Hello,

I'm a novice at excel, trying to figure out a way to make my spreadsheet cells auto-size to show all text when I open it. I know I can click on the cell to make it auto fit but I'm trying to get a way that it just does it automatically when its opened. I have 12 columns in my spreadsheet and column "I" has way more data than any other column. I'm trying to get it so that each row will auto size to match the size of the cell in column I with all the text displaying in column "I".

Thanks

 

[Joe4]

Put this in the "ThisWorkbook" module in VBA:

Private Sub Workbook_Open()
    Sheets("Sheet1").Activate
    Cells.EntireColumn.AutoFit
End Sub

and update the sheet name to reference the name of the sheet you want to apply this to (if there is only one sheet in your workbook, this line is not necessary).

This code will automatically run upon opening the workbook, provided you have VBA/Macros enabled.

 

[etaf]

if before you save the spreadsheet you click on the square between the column and row
then goto the side of one of the columns A,B,C etc - mouse should change to a double edged arrow - double click ALL columns now autofit

i just wondered how the spreadsheet was to small when saved
But you have a VBA answer now as well

 

[Noob80]

Put this in the "ThisWorkbook" module in VBA:

Private Sub Workbook_Open()
    Sheets("Sheet1").Activate
    Cells.EntireColumn.AutoFit
End Sub

and update the sheet name to reference the name of the sheet you want to apply this to (if there is only one sheet in your workbook, this line is not necessary).

This code will automatically run upon opening the workbook, provided you have VBA/Macros enabled.

Awesome! Thanks Joe. Sorry I know its been 3 years, haha. Job changed for a long time but now I'm getting back into using excel.