💻VBA SPECIAL💻
🔰Remove Text Wrap🔰
This code will help you to remove text wrap from the entire worksheet with a single click. It will first select all the columns and then remove text wrap and auto fit all the rows and columns.
Sub AutoFitRows()
Cells.Select
Cells.EntireRow.AutoFit
End Sub
There’s also a shortcut that you can use (Alt + H +W) for but if you add this code to QAT it’s way more than keyboard shortcut.
If you have any query or want any help related to excel feel free to join our Telegram channel and message us..
Channel link :
https://t.me/msexcelmaster101
0 Comments