An curved arrow pointing right. We all know and love the Auto Fill feature in Excel. Microsoft went a step further in Excel 2013 and created Flash Fill. This new feature recognizes patterns in ...

The shortcut to use the Flash Fill is Ctrl + E. Select the cell in which you have entered the data manually without dashes and then press the Ctrl + E keys. Excel will automatically fill data ...