How to Use Excel Flash-fill

Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it.

If you have a list of data and need to say split the data or fix the formatting of it then you can teach Flash-fill to sense a pattern and then when it fills the data in another column or row it makes the appropriate adjustments. Lets say you have some data that has a mix of lowercase and uppercase and you want them all to be uppercase or even proper case well you can easily get Excel’s Flash-fill to do that, no need for functions.

The other example I use here is some names that are entered into one column, some are hyphenated and some not, rather than using some functions I quickly use Flash-fill to sense the pattern, you’ll see how quick it is.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, excel data and tagged , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s