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.
Learner's Ratings
4.7
Overall Rating
83%
10%
5%
2%
0%
Reviews
A
AB Nazim
5
good
I
Ibrahim Khalil
5
Very good
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
Share a personalized message with your friends.