Suppose your Excel columns contain a lot of characters.
But doing that constantly can become a time-consuming task.
Lets see how you’ve got the option to automatically adjust column width in Excel.
Excel will now automatically change the column width to accommodate text.
Theres also a shortcut that you’ve got the option to use to get the job done.
What If AutoFit ain’t running?
If your column contains merged cells, you cant use the AutoFit option.
The same is valid if the Wrap Text option is selected.
The only thing you’re free to do is manually adjust the column width.
Alternatively, you could also use the ALT, H, O, and I shortcut.
Remember that the AutoFit option wont work if your column contains merged cells or wrapped text.
