hello and welcome to our new video in this video we will
understand how flash fill works in last video we saw that
fill is an option in excel which works left, right, up,
down justify, series we saw many options but now one
feature which we talked about in last video but did not
explore about that feature how flash fill works so let me
open excel my excel is open we know that where we get this
option when we go to home tab here in editing group in this
editing group below O2SUM we get fill
yesterday we talked about down, right, up, left we also saw
how cross worksheet works apart from this we saw series and
justify one option which was left yesterday was flash fill
now how flash fill works we will know that in this video
this is an interesting feature suppose here I have some
names here I have some names 7 to 8
I have some names so it has some features some features of
flash fill and some limitations so let's talk about
features one by one so let's talk about first feature
suppose someone told you this whole name is written
Rahul Rohila, Imran Khan, Jeenat Verma
Shiva Maroda, Deepak Kumar
Hrithik Chauhan so what we have to do we have to separate
them by separating name will come in C column
Rohila will come in D column similarly Imran's name will
come in C column and surname will come in D column so how
to do this now you can say
Rahul and Rohila can be copied by double clicking
I copied it and pasted it similarly I copied Rohila and
pasted it but these are 7 to 8 names what will you do in
2000 will you do this because it is time consuming process
and what we have to do what we are learning in excel how to
save time so let's see this now I will show you how does
first feature work so I went to next column what I wrote
here
Rahul tab clicked next column
Rohila now you will say sir you are also writing manually
I have written only one manually rest I will show you magic
now what we have to do here we want
Imran, Jeenat these names will come in this column and
surnames will come in this column yesterday we saw that we
were focusing on selection we were not focusing on drag so
here also we are going to do the same what I will do, I
selected all when I selected all then I will go to fill
option and now I will do flash fill see magic can you see
all the names were copied and similarly
I am going to do here in D column all the names will come
automatically what I have to do
I have to select
I selected all all the rows in these rows
I selected in D column all the remaining cells will have
surnames so again
I will go to fill option and what I will do
I will do flash fill now you can see what happened the
names and surnames are visible in different columns so this
was the first feature of flash fill now let's talk about
the second feature
I will remove this so that it is visible easily now someone
told me that you have to do
Rahul's first alphabet which is R so what you have to do
you have to write R
Rohila, Imran Khan
I Khan, Jeenat Verma
G Verma and Shiva Maroda
S Arora so you have to do like this and I have list of 1000
people so one by one it will take time so how will you do
here
I wrote R and then
I wrote Rohila ok same thing you have to do in first cell
you have to write the format and pattern after that select
all and go to fill option and flash fill and here the first
character of name copy and the rest of the name so this is
the second feature now let's talk about the third feature
now what I have to do for the surname the second like here
the surname here select the first character of name now
select the first character of surname ok so I wrote here
R and if I write one more R
RRR so after writing RR select all after selecting go to
fill option and flash fill and here the first character of
name and surname is here so this is the third feature now
let's talk about the fourth feature suppose here there is
no prefix in front of my name like doctor mister and
someone told me what you have to do you have this list you
have to put mister or missus ok to put mister
I have to edit in normal way double click go here and write
mister but how will I write in other cells for me it will
be difficult task so I will not do this so what I did go to
this column and increase the size of this column what I did
here mister rahul whatever prefix you want
I will put it in front of my name like I said mister rahul
rohila enter after doing this select all and go to fill
option and flash fill now you can see you can put prefix in
front of all so this is fourth feature now I will take you
to second sheet and I will show you how we can improve more
features so I will go to sheet 1
I will zoom in
so here
I have some data name city city other cells you can see ok
I will remove this ok
so if someone ask me what I have to do you have to write
state and other names so you have to extract this in
another column how I will extract you can do that with
flash fill simple here I will write faridabad after writing
select and go to fill here you can see all cities or state
are extracted in another column you can do that with pin
code like 121004 and other pin code here I have to write
121004 ok now I have selected all what I have to do after
selecting all go to fill and flash fill so
will notice that this cell what we got from this cell is
1,2,1,0 what happened is we told in starting that what we
want we told that we want pin code so we wrote 1,2,1,0,0,4
after that what we did is we selected it so what data we
got from other columns what we extracted
we extracted pin code so this is clear now we talked about
features these are the features now we will talk about
limitation what is the limitation in this now flash fill
option works on patterns what is the meaning of patterns
I will tell you
I will delete this whole thing see here here it is written
Rahul Rohila so you will notice pattern suppose someone's
name is
Rahul Kumar Sharma
I will write Rahul Kumar Sharma here I wrote Rahul Kumar
Sharma here I wrote Rahul Kumar Sharma now what I want here
I will write Rahul, here Kumar here Sharma after that I
will select
Rahul Kumar and Sharma
after that when I selected and clicked on flash fill you
will see here it picked up the name let's go to Kumar and
click on flash fill here it picked up the name again let's
click on Sharma and click on flash fill here it picked up
the name but here there was a problem here it should have
written
Kumar, Verma, Arora but it got confused because we gave
three things
Rahul Kumar Sharma it got confused so it picked up wrong
data so we have to remember this thing can be corrected
let's write Sharma let's write Sharma let's copy it let's
copy it now what will happen you will get to know that what
I am saying is correct or not then what it should do it
should do like this
I will delete all the data
I will delete this
I will delete this here it is written Rahul Kumar Sharma
now what is my pattern this is second third similarly I can
see in second cell Imran Khan Sharma, Jinnat Verma Sharma
now I selected this let's paste it let's paste it let's
paste it
I selected it like this
I went to fill option
I filled it we have to see whether it will work on 3 or not
we have to see what it got under Kumar it got Verma it got
Sharma it got Sharma so you got to know that it got pattern
you have to remember this pattern if here your name and
surname is written and in your data like this here only
this simple thing is written you have 3 cells 3 cells have
different pattern so this will show you wrong data so we
got to know what are the features of flash fill and also we
got to know limitation of flash
so for now that's all for now thank you