Every once in a while, Excel can surprise even us hardened pros. We discovered "Flash Fill" today (totally by accident) while working on some client work and it made our afternoon. Bear in mind we are using Excel 2013, so this might be a new feature. Check out the video below.
Have a great weekend!
Flash Fill in Excel from Shooju on Vimeo.
Frequent use programs and spreadsheets,
ReplyDeleteas well as files with the separated values by commas, led me to open csv file https://wikiext.com/csv using the universal program viewer for plenty of file extensions with just one click.
I realized how this is convenient only after I used such program in my office during for the whole working week. So I appreciate this application 5/5.
Amazing tip, thank you for sharing your experience and this valuable knowledge. Looking forward to apply this newly acquired knowledge. www.Office.Com/Setup
ReplyDelete