Gone are the days when we need to manually fidget with column widths as we enter our data, and thank goodness. Let's learn how to leverage a simple VBA code (don't panic!) to automatically resize our columns to fit what we're typing!
Check out the gif above for an example - first, we need to open our worksheet's VBA code by right-clicking the sheet, selecting "view code", and selecting "worksheets" in the dropdown. Now we'll just enter the code 'cells.entirecolumn.autofit' after the first existing line of code, and that's it! Close out of the VBA code, type the longest column header your heart desires, and watch as the cell now magically updates to fit the size of your data!
I wish this was an automatic setting in Excel - what do you guys think?!? Have fun trying this out!
