Excel: Flash Fill was there and is now Gone

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I saw Flash Fill propose a solution, but I did not hit the correct key, and now it is all gone.

Strategy: Finish typing the second entry. Go to the blank cell below your first two entries. Press Ctrl+E or select Data, Flash Fill. The data will come back.