top of page

Learn to use an AMAZING feature in Excel! FLASH FILL

Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to Combine first and last names from two different columns and to fill a column of Company e-mail addresses.


Make sure your Flash Fill is turned on. You can go to Data > Flash Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box.



DOWNLOADABLE RESOURCES

ExcelFlashFill-01
.xlsx
Download XLSX • 131KB

408 views0 comments

Recent Posts

See All

Comments


bottom of page