Craig Gerdes, Author at Centriq
Centriq Training Print Logo

Thursday

July 27 11:35 PM

78°F Mostly Cloudy


Blog Banner Graphic

Posts by: Craig Gerdes

How to use Flash Fill in Microsoft Excel

How to use Flash Fill in Microsoft Excel

July 6, 2017 in Microsoft / by Craig Gerdes

You are probably familiar with Excel’s very powerful Autofill feature (if not, click here to learn more and then read on). However, did you know there is a similar feature that is equally useful called Flash Fill?

Say you have information in Excel not formatted the way you need it to be and going through the entire list manually to correct it seems daunting. In this case, Flash Fill can do the work for you. You use the Flash Fill feature to automatically fill-in values in one column from information referenced from another, adjacent column (extract, combine/concatenate, insert characters, reverse data, change case, format, etc.).Read More