In this video, first, you’ll learn how to leverage VBA to automatically fit all worksheet rows and columns to the size of the data as you enter it. Then you’ll learn how to quickly autofit data using Excel shortcuts. Nine out of ten times, Excel data doesn’t fit within columns and we are unable to read the data. After watching this video, you’ll be able to clean up data in seconds using two different methods!
RESOURCES
Download the workbook and follow along: https://exceldictionary.com/pages/yo...
SHOP EXCEL DICTIONARY
COURSES: https://exceldictionary.com/collecti...
GUIDES: https://exceldictionary.com/collecti...
MERCH: https://exceldictionary.com/collecti...
TEMPLATES: https://exceldictionary.com/collecti...
NEWSLETTER
Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.exceldictionary.com/subs...
SUBSCRIBE
Subscribe to never miss a video: / exceldictionary
TIMESTAMPS
‘0:00 Intro
‘0:23 Autofit data using VBA
‘2:03 Autofit data using shortcuts
‘2:40 Wrap up
#excel #exceltips