Many of the tasks that you will be doing in Microsoft Excel are boring. Happily, Excel has several features that make this type of spreadsheet tolerable. We’re going to look at two of these: Flash Fill and Auto Fill.
How to use Flash Fill in Excel
Flash Fill can automatically detect patterns in data and help you fill cells quickly.
To the exampleIf we start with a list of full names (first and last names) but then decide we should have broken them up into separate columns, Flash Fill can do much of the work for you.
First, let’s say we have a list of names. Enter only the first name from the first cell in the column in which the first names should appear.
At the top of the ribbon, click the Data tab. Excel Window.
Then click the “Flash Fill” button in the “Data Tools” section.
As you can see, Excel recognized the pattern, and Flash Fill filled the rest of our cells in that column with just the first name.
From here, now this Excel If you know our pattern, it should preview you as you type. Try the following: In the next cell where you entered the first name, enter the appropriate last name.
If we click on “Enter”On the keyboard that moves us into the cell below, Excel now shows all last names in their correct places.
Click “Enter“To accept, and Flash Fill will automatically complete the remaining cells in that column.
How to use autofill Excel
Auto Fill works similarly to Flash Fill, but is better for tasks with many cells. It’s also better for cells that have an even more obvious pattern, such as: B. Pay, for example. To see how it works, let’s put in a few numbers.
Click and drag to select both cells.
Find the square in the lower right of the cell and drag it down. You can pull it as far as you want.
Excel recognized the pattern and filled in all cells below.
But that doesn’t just work for numbers. Auto Fill is great for all types of patterns, such as days and months example. Let’s put a few in to get started.
Just like the previous one exampleif we click on the box at the bottom right and drag it down, Excel fills all cells below with the Auto Fill function.
Using Flash Fill and Auto Fill are two easy ways to automate your work Excelas long as it’s an obvious pattern.
Even though Excel Sometimes surprises us with its ability to spot more complex patterns that you cannot rely on. Stick to simple things for the best, most consistent results.