Flash Fill – the Magic of Ctrl + E!
Ever need to manipulate data repeatedly through multiple rows? In the old days we would need to use complex nested Text Formula. Today (well since 2013) we can give Excel an example, and then get it to replicate this through all the other Rows simply by using the Shortcut Ctrl + E.
Before you get too excited, thinking that Ctrl + E is the solution to all your Excel woes, it’s not a formula. In other words, if the data used had to change you would manually need to change your Flash Fill content. In addition, sometimes Excel doesn’t quite get it right the first time. In these cases, you then need to train it by giving it further examples in other rows. For a quick manipulation of multiple rows of data though, it truly is a fantastic time saver.