How to Dynamically Adjust Column Width in Excel

Published: 18 March 2021
on channel: Chris Waite

14,497

120

Shows you how to automatically adjust the width of a column in Excel

Code to use is below:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Application.ScreenUpdating = False

For Each Value In Target.Columns

Worksheets(Sh.Name).Columns(Value.Column).AutoFit

Next Value

Application.ScreenUpdating = True

End Sub

Watch video How to Dynamically Adjust Column Width in Excel online without registration, duration hours minute second in high quality. This video was added by user Chris Waite 18 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,497 once and liked it 120 people.

7,349

184