Excel 2013 – New features in Flash Fill!

Flash fill is a great feature that was brought in as a new feature with Excel 2013. This feature allows you to bring together Excel 2013 - screen shot of how flash fill worksthe contents of two cells from two different columns and put them together in one cell in the next column along.

A good example of how this can be used is for taking two columns that have a list of peoples first and last names separately and using flash fill to quickly create a third column with both the first and last name in it.

From when it first came out in 2013, Flash fill has developed and become even more useful for use in your work. We are going to have a look at some of the options that you can use it with.

Remember: when using Flash Fill in Excel, there has to be a consistent pattern in your data that Excel can recognise and the column(s) that you are using to combine or split up have to be next to each other.

A key thing to remember is that to use Flash Fill, you need to type in one combined or split up ‘answer’ and then in the cell underneath that type in Ctrl+E and it should have then filled in the rest!

Below is a spreadsheet that you can try out Flash Fill! There are four examples for you to try out with some help information on each sheet.

Flash Fill Example Spreadsheet

Flash Fill is available in Excel 2013 and other later versions, so if your version of Microsoft Office is older than 2013, you won’t be able to use Flash Fill unfortunately.

Let us know what you think! If you have any thoughts on Flash Fill, please do email us as we love to hear what people think of our hints and tips!

You can email your thoughts to us at johnlegge@jplcomputer.co.uk

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy