From the course: Miss Excel’s Top Productivity Hacks

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Meet Flash Fill: The superhero of Excel

Meet Flash Fill: The superhero of Excel - Microsoft Excel Tutorial

From the course: Miss Excel’s Top Productivity Hacks

Start my 1-month free trial

Meet Flash Fill: The superhero of Excel

“

(dramatic music) - Got your cells stuck together? This sounds like a job for Excel's superhero, the flash fill. Let's fly over and see what's going on. Let's explore Excel's superpower, the flash fill tool. Here, we're going to be leveraging some of Excel's pattern-sensing technologies in order to manipulate our data. Now before we get started, if you haven't already downloaded the exercise files that go along with each of these lessons, I would recommend you do so here. Now let's take a look at our data. In column A, we have a list of our superheroes with their first names, last names, and their sales amount all crammed there into column A. And let's say we want to break this out into multiple columns. This seems like a job for the flash fill. Now in order to activate flash fill, we first need to demonstrate in Excel what pattern we want it to follow. So the first thing we're going to do is click into cell B3 and…

Contents