AutoFit column widths

PHOTO

Mon May 04 2026 00:27:11 GMT+0000 (Coordinated Universal Time)

Saved by @iwaschristina #excel-formula

Sub AutofitAllColumns()

Cells.EntireColumn.AutoFit

End Sub

https://www.goskills.com/excel/resources/vba-code-library

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

AutoFit column widths

Sub AutofitAllColumns()

Cells.EntireColumn.AutoFit

End Sub

AutoFit column widths (Specific Columns)

Sub AutofitSpecificColumns()

Range("D:D,F:F").EntireColumn.AutoFit

End Sub

Browse more snippets >>