Get instant live expert help on how to flash fill in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

In cell D6, type ML3583. Select the range D5:D14, and then use the Flash Fill button (in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fill button to properly receive credit for this step.) [Mac Hint: Flash Fill is not available on Excel 2016 for the Mac, so refer to the Final Figures to enter the correct values.]
Solved by V. E. in 28 mins
Use Flash Fill to place the category data from column H in proper case in column I. Use Flash Fill to place the Manufacturer data from column H into the new column J. Owing to the nature of the data, Flash Fill will need to be invoked from the Data tab. Mac users will need to use the Text to Columns feature. Select the range H2:H24. On the Data tab, click Text to Columns. Use / as the Delimiter and =$I$2 as the Destination.
Solved by X. S. in 18 mins
In cell G5, use Flash Fill to separate the city from column F.
Solved by K. L. in 14 mins
Hi there, I need to create a series of addresses using flash fill, but excel cant' identify the pattern
Solved by E. H. in 16 mins
We undid the option :flash fill, now locked out and entire work book is grayed out please help
Solved by B. B. in 27 mins