⚡Use Flash Fill for MAJOR Time Saving in Excel | Split cells | Combine Cells | Change Case in Excel
Flash Fill is one of the best tools of MS-Excel. It automatically fills your data when it senses a pattern. You just need to enter a sample text, you want as output. Flash Fill will show you a preview of the data. Just check the list, if it’s ok then accept it.
So now use Flash Fill & save your important time. In this video, we are sharing here some usage of Flash Fill Feature:
- To Split Cells in Excel.
- Flash Fill to Combine/Merge Cells in Excel.
- To Change Case (Like LowerCase, UpperCase, Proper Case).
- Write E-mail in a flash.
- For Initials
Keyboard Shortcut for Flash Fill: PressCtrl + E
Note: Flash Fill is only available in Excel 2013 and later versions (2013, 2016, 2019 & office 365). Excel 2007 & 2010 versions will not have Flash Fill.