Build Your Resume To Get Connected for Jobs and Internships - Resume Builder
How to use Flash Fill in MS Excel
Now we will see that how we can use Flash Fill in MS Excel.
For example we have a column of employee name with first name and last name. Now we insert new column next to that column and in first row we write last name first and first name after that, and then we do similar for second row which will provide us all the rows in same format for this column i.e. MS Excel recognised a particular pattern which we are using.
Now similarly if you want to do this to any other call off then we can use the option of Flash fill from DATA tab, which will recognise a particular pattern and then auto fill all other cells according to that.
Shortcut key for flash fill is 'Ctrl+E'.
We can similarly do this to the address column, for example we just want City names of our employees, then we can use this option.
Learn Making Professional-Quality Documents With MS Wor...
Enroll For FreeImpress Everyone With Fluent Communication Skills With...
Enroll For FreeEnhance your customer engagement skills with our Custom...
Enroll For FreeImprove Your Presentation and Team Management With Soft...
Enroll For FreeBecome A Master In Sales With Career In Sales Taught In...
Enroll For FreeHave a friend to whom you would want to share this course?