hello and welcome to a new video
and in this video
we are going to learn something interesting
the topic we are going to do today
is how to use skip blanks
in excel
now you will say
skip blanks
our mind is blank
we don't know what it is
I will tell you
I have an excel file
which has some data
I told my friend
he doesn't know excel
I told him this is the data
and you have to add it
in the file
I told him
what should come below monday
it should be Tuesday
Wednesday
it should be Thursday
he didn't know
he wrote Monday here
he wrote Tuesday here
he wrote Wednesday here
he wrote Thursday here
he filled the rest of the marks
here
he made a mistake
how did he make a mistake
he left blank space here
he didn't put data in excel
he didn't put marks
he didn't put marks here
what should I do
he didn't have to put marks here
if he had to put
he could have put 0
there is empty space
or
minus sign
he could have put
or he can write nil
it would have been good
this empty space
but he couldn't
we will see the same thing
if by mistake
we do like this
we have
so many blank space
that left
we have to put a common thing in it
like we have to put a common zero
or we have to put a ten
in the remaining cells
so how will we do that?
so one thing we will see and the second thing we will see
that what is written here Tuesday,Thursday,Sunday
how to bring it from here to here
you will say that we know
copy it from here and paste it here
how easy it is, I copied it from here
and what did I do here? I pasted it
sir this was very easy, it got pasted
you will say like this
and what did I do with this data? I deleted it
it is easy, what did I do like this? I cut it
cut or copied it and what did I do from here?
I pasted it
my question to you is
this is in the name of days
now suppose I have 6-7 data
after this if I have
800-900-1000 rows of data
then what will you do? then this will be messed up
then what will you do? so we should have a smart way
so we will see that smart way
so what do we have to do? I will bring it to the first state
how to bring it to the first state?
if you press ctrl plus z then it will be undo
and it will come to the first state
like the previous data
is it clear to you?
now what do we have to do?
we have to see that this whole data
how to bring this data here?
so what do we have to do?
we have to select it
and what do I have to do?
I have to copy it
after that I have to go here
on monday cell
and I have to right click on monday cell
now I will see an option here
paste special
and here
you will get skip blanks option
you have to check it
now it is unchecked
after that you have to click ok
so you see this data is automatically
filled
after that you have to delete this data
so it is simple
now this is done
now we have to see
if these cells are left
without data
how to resolve it?
so what do we have to do?
we have to use a shortcut
which shortcut do we have to use?
you have to press ctrl
after that you have to press g
so what did you do?
press ctrl plus g
and it will open
go to
you will see go to section like this
you have to go to special
you clicked here
now you have to go to blanks
you clicked here
ok
now it has selected all the cells
where data was not filled
now you have to
press ctrl
I have selected this cell
now you have to
put the data you want
for example
I have put
this side
after putting this
you have to press ctrl again
now you will see
all the blanks
this side
but we don't want this
so we delete this
delete this
because it is not useful
and these two sections are not useful
so I delete them
but I have seen
minus sign
so you can put
zero sign
is it clear?
now your question will be
why it is here?
because it is a table
and table row is selected till 12
so it filled all the blanks
is it clear?
so it filled all the blanks
in one time
is it clear?
for this
we went to paste special
we clicked here
now it is disabled
because we are not working on it
for this
and
we went to go to section
and filled it
is it clear?
so that's all for today
keep practicing
and if you have any doubt
play this video again
see you in next video