Monday, February 20, 2023

How to Master Microsoft Excel's Flash Fill Feature

Microsoft Cool Tip Logo
One cool tech tip for using Microsoft Excel is to use the "Flash Fill" feature. 

This feature allows you to quickly split, combine, or format data without using complicated formulas or macros.

For example, let's say you have two column of names, First and Last and you want to join them into one new column. 

Instead of manually copying and pasting the data into the one new column and adding a space between the names, you can use Flash Fill to automate the process.

Here's how to do it:

  • Start by typing the first and last name in the third column of the first row, next to the last name.
  • Type the First name in the next row.
  • Excel will automatically recognize the pattern and suggest the combines names in the list.
  • Press Enter to confirm the suggestion.
  • The rest of the names will automatically be entered.

You can use Flash Fill for many other data manipulation tasks, such as formatting dates or removing duplicates. 

This feature can save you a lot of time and effort, especially when working with large data sets.

Microsoft Excel Flash Fill Example
Microsoft Excel Flash Fill 


Please Like and Share OneCoolTip!

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #FlashFill @Microsoft 

No comments: