Tuesday's Tip #1 - Excel: Flash Fill
Hey! I'm super excited to start this journey of a blog with Microsoft Office tips. It's something I've been wanting to do for YEARS and today is the day! Here we go!
My goal is to provide you with FREE, practical, awesome tips to better user your Office apps - Excel, Word, OneNote, Outlook, PowerPoint - you get the idea.
Tip #1 - Excel Tip: Using the New Flash Fill
This tip is included in my FREE mini-course:
3 Excel Secrets to Super Charge your Excel Skills. If you haven't taken it yet - you can get it for free here.
It's such an awesome tip - it allows you to quickly and automatically fill values. It's hard to explain without seeing an example.
So the idea is - Excel tries to find the pattern to what you're doing, more specifically, what you're extracting or adding to the text.
I've documented one example below - but watch the video for another example and to see exactly how it works.
Example 1 -
You've got a list of part numbers with similar formatting.
You may want to extract information from this part number or combine it or reformat it another way. Perhaps similar to the example below.
The first step - is to set it up the first line the way you want it. Like you see below.
Then you will click in the cell where you want to "fill" and use the Flash Fill feature.
On the Data tab, click on the Flash Fill button.
This will fill all the remaining cells below with the same formatting. Excel doesn't ALWAYS get it right, but it does a pretty good job.
If you're interested in more awesome tips like this - check out my Excel Course.
