🎯 Auto Fit Columns in Excel Using Macro (VBA) 🔥

📄 VBA Code
VB
Sub AutoFitColumns()

Cells.EntireColumn.AutoFit

End Sub
💥 This macro automatically adjusts the width of all columns based on the content.
🚀 AutoFit Only Used Columns
VB
Sub AutoFitUsedColumns()

ActiveSheet.UsedRange.Columns.AutoFit

End Sub
✔ Fits only the columns that contain data.
⚡ How to Use
1️⃣ Press Alt + F11
2️⃣ Click Insert → Module
3️⃣ Paste the code
4️⃣ Press F5 to run
💥 All columns will be adjusted automatically.
💡 Bonus Shortcut
After creating the macro:
1️⃣ Press Alt + F8
2️⃣ Select Macro
3️⃣ Click Options
4️⃣ Assign a shortcut (e.g., Ctrl + Shift + A)
✔ One-click AutoFit anytim

Видео 🎯 Auto Fit Columns in Excel Using Macro (VBA) 🔥 канала Explore With Roshan