Flash Fill Formula Excel. Flash fill is normally activated by default in excel. Once you ve done this excel will do its best to carry on the pattern.
Click file options. You can do the same function manually. First tell excel what you want to do by entering the value 130 into cell b1.
Click the flash fill button in the data tab of the ribbon.
You can do the same function manually. If you establish a pattern by typing the full name in column c excel s flash fill feature will fill in the rest for you based on the pattern you provide. Click the flash fill button in the data tab of the ribbon. Drag the fill handle.
