Course Content

Course Content


Place the mouse pointer over the cell's bottom right-hand corner until a black + symbol appears. Drag the + symbol over the cells you wish to fill by clicking and holding the left mouse button. Using the AutoFill tool, the series is automatically filled in for you.

  • Enter the example data you'd want to get.
  • Select the cells you want to fill as well as the cells that contain the examples.
  • In the Data Tools area of the Data tab, press the Flash Fill command.

 The Flash Fill results do not automatically update. Flash Fill produces static effects, unlike formulas. Any changes you make to the original data won't show up in the Flash Fill results.

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere