Скачать или смотреть Auto Adjust Column Width in Excel

To Auto-Adjust Column Width Automatically as You Type 

For columns to adjust their width every time you enter new data, you need to use a small amount of VBA (Visual Basic for Applications) code. 

Right-click on the sheet tab name at the bottom of your Excel window and select View Code.

In the VBA editor window that opens, select Worksheet from the first drop-down menu at the top.


Type the following line of code in the editor:
Cells.EntireColumn.AutoFit

Close the VBA editor window.

Save your workbook as an Excel Macro-Enabled Workbook (.xlsm) file for the code to work in the future. The columns will now adjust automatically as you enter data in that specific worksheet. 

‪@naaz143-i1m‬
‪@MrBeast2‬
‪@MrBeastGaming‬
‪@MrBeast‬