Excel: Flash Fill Won't Fill Numbers

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: Flash Fill is not working with numbers. Actually, I see the grey numbers appear, but then Excel erases them.

Strategy: Chad Rothschiller at Microsoft points out there are too many coincidences that can happen in numbers. With only 10 digits, Chad might think he knows the pattern but then screw up your data. So, Chad shows you the preview, but then withdraws it. It is up to you to go to the blank next blank cell and press Ctrl+E.