Here we will learn about FLASH FILL. By using this we can increase SPEED to work in our EXCEL and also save a lot of our time.
FLASH FILL FOLLOW a PATTERN. In which whatever PATTERN we tell him, he fills or fills all the remaining DATA according to the stated PATTERN. In this, we only have to tell him in one cell how we want our DATA according to it and then it fills the DATA in the remaining CELL as soon as we use it.
So how can we use it?
We can use it by doing some STEPS.
For example, we will FILL the data mentioned in the photo below with the help of FLASH FILL. In which we have been given full name in one column and we have to write NAME and its SURNAME in different columns.
STEP -1 # First of all, we will write the DATA according to which we need complete data. So here we have to separate the NAME from the FULL NAME, first of all, we will TYPE the NAME in the first CELL.
STEP -2 # After that, in the EDITING BLOCK of HOME TAB, CLICK on the OPTION of FILL.
STEP -3 # After that FLASH will CLICK on FILE OPTION.
Our entire DATA AUTOMETICALLY FILL becomes due to CLICK on FLASH FILL. And we get separated by NAME.
Similarly if we want to separate SURNAME then we will first type SURNAME in the first cell.
Previously we had taken a long way to fill our DATA, this time we will fill it with SHORT CUT.
And the SHORT CUT way to fill it is CTRL + E. As soon as we press it, all our DATA becomes FILL.
In the same way if we want all our names in front of us. If added, we will first write the same DATA in the first cell as we need and then use FLASH FILL. And our DATA becomes FILL.
Similarly, if we have been given a data in which we have given all the information together in the same column and we have to separate it, then we can easily separate it using it.
In the photo below, we are given name, city and PIN together and we have to separate it, then we will first write it separately then after that we can get all DATA separately using FLASH FILL.