How to do a VLOOKUP in 60 Seconds - • VLOOKUP How to Excel in 60 Seconds #Shorts
Autofit column width Excel
This is by far the quickest way to adjust the width on your columns
Just go to the space between the columns so your cursor changes to this shape
And double click
It will automatically re adjust the size of the columns to fit the widest point of the data inside the whole column
I’m going to undo the change by pressing ctrl Z
You can also highlight all of the columns and click on anyone of them the same way and it will do multiple columns at the same time
If you don’t want to auto fit you can also adjust all columns at the same time by dragging any one of the columns bigger or smaller.
Click here or in the description to watch how to do a VLOOKUP in less than 60 seconds or check out the other Excel videos on my channel