Robert at Evaris

IT Support and Managed Service Provider covering the North West UK

14. Let Excel reformat your data

let-excel-reformat-your-dataYou know how powerful Excel’s Fill Down “Control -D” command is? The new version of Office has something that practically reads your mind: Flash Fill.

With Flash Fill Excel sees what you are doing and does the rest of it for you.

For example, say you are changing the formatting of a list of people’s names from spread across two columns (first name, last name) into a single column. When you type the second reformatted name, Excel displays the whole list, reformatted. Just click to accept it.