Скачать или смотреть How to use Flash Fill in Excel 2013/2016

Flash Fill is one of the best tools in Excel - but not many people know about it! It's only available in Excel 2013 and 2016. Learn how it works in this two-minute video.

With Flash Fill, Excel can autofill information for you - but you have to 'train' it first. For example, if you have title, first name and surname in three columns, you can add a fourth column where you input this information all into one cell, as in Nicky's example above. Then, just press CTRL + E and Excel will auto complete the rest for you!

Don't confuse this with Autofill - learn about this great time-saving tool here:    • Save Time With Autofill in Excel  

Learn how to work more productively with our Excel training courses, delivered live online with an experienced faclitator: bit.ly/HappyExcelOnline