Hello and welcome friends, how are you all, in this video
we are going to talk about rows and columns, so we have
seen that how we can increase or decrease the size of rows
and columns, so in this video we are going to see that how
we can insert a column in the middle of a column.
we can delete that column, we can hide that column, we can
unhide that column, and we can do all these things with
rows, then we will see with sheets that how we can generate
a copy of sheets,
I already have a data, here serial number is written from
roll no.7 to roll no.10, some student names are written,
and some subjects are written here, history, geography,
maths, sociology, here total,
now we don't have to bother about how we can increase or
decrease the size, we already know this cell, but we don't
have to bother about this data, now what we have to do is,
now we have to see that in column B, I have multiple cells,
and student name is written, and in column C, if I want to
insert a column between column B and column C, then how I
can do that, to insert that column, what I have to do is, I
have to go to column C, and right click on that column, and
you can see the insert
so I have inserted a new column, similarly, if I want to
insert a row, then what I have to do is, if I want to
insert a row between 4th and 5th row, then I have to go to
5th row, then what I have to do is, I have to right click
on 5th row, and insert it, see, a new row is inserted, now
I have seen how to insert a column, now if I want to delete
a column, then what I have to do is, I have to go to 5th
row, and right click on 5th row, then what I have to do is,
I have to right click on 5th row,
insert it,
now if I want to insert a column between two columns, then
what I have to do is, I have to go to 5th row, and right
click on 5th row, then what I have to do is, I have to go
to 5th row, and insert it, now I have to hide this column,
I have to hide this column, I have to hide this column, I
have to hide this column, I have to right click on 5th row,
and insert it,
now you can see an option of hide, you have to click on
this option, now I have clicked on this option, now what I
have to do is, I have to delete this column, now what I
have to do is, I have to delete this column,
now suppose I want to hide this column, I have to go to 7th
row, and hide it, now you will ask how to bring this column
back, so the way to bring this column back is,
I have to bring back the column or hide row as you can see
here so I have to pay particular attention that when I will
right click when I see this space white color space so
first of all we bring back student name column so here I
can see space between left arrow and right arrow on this I
will take cursor and
I will right click so here will be option of unhide so I
will unhide what is this? same thing I will do
I will apply here when I apply here with rows so now I am
not getting now what I have ok now what I have is size
increase or decrease size increase or decrease which arrow
I want that space now what I will do
I will right click and unhide so here this row came back ok
now let's see with sheets in this sheet I have data all
this data what I want? I want to make one more sheet and in
that sheet also same data should be there so what I will do
I will go to this sheet right click and here you will see
move and copy option so you will click on this option and
here you can see check box and here it is written create a
copy so what I will do
I will create a copy here it is written move to end move to
end means this sheet data will go to other sheet but this
sheet data will not be saved it will be moved so what I
will do
I want to create a copy so I will fill this check box and
then click on ok button so here you can see this sheet copy
sheet if we click on this sheet so see this is the same
data which we had earlier in this sheet this is the new
sheet this is the same data so in this sheet the data is
copy now I can give color to this sheet if I want to give
other color then
I will click on this and right click and here you can see
tab color option in this tab color option
I will click and give blue color to this so you can see
blue color if I want to change color of this sheet what I
will do right click and tab color option and from here
I will give yellow color so it will be visible so from here
I will give yellow color so now what I have to do
I have to hide all sheets like let's hide one sheet we have
seen how to hide with column we have seen how to hide with
rows now let's see how to hide sheets bring mouse on this
right click on this and hide sheet is hid so in my workbook
there should be at least one sheet with the help of which I
can bring other sheet so in this sheet
I have to bring other sheet so on this sheet
I will click and click on unhide option from unhide it will
show that you have to bring sheet no.1 or sheet no.3
I have to bring sheet no.1 so what happened to this sheet
it came back
I will create one more sheet
I have created sheet no.4 there is no data in this now if I
want to hide multiple sheets then how can I do so what I
will do press ctrl and select sheet no.1, sheet no.4, sheet
no.5 sheet no.6 and after that hide it so all sheets are
hid we have hidden all sheets in one go now how to bring
them back to bring them back we know it should be in
workbook so what we will do we will take cursor, right
click and unhide in unhide it will show all sheets so one
by one if I want sheet no.1
I will click on sheet no.1 now what I want sorry I didn't
want to hide
I wanted to unhide so from 12 we do unhide and from unhide
we bring sheet 4 back ok so now i understand how to hide
and unhide sheet one last thing we see in this now like the
size of this cell ok what is that? it is big ok because the
size of this column is this much so the size of this cell
will also be this much now what i have to do is i have to
make the size of all these columns equal ok i have to make
it even so how i will do it? suppose i select all the cells
from here ok like c, d, e,
g i have selected all the cells now what i have to do is
whichever cell i want to size like i want to size bring it
anywhere bring it on e bring it between any two cells we
can see the arrow by clicking it and we have to see only
the size of f ok how much is the size of f? see the
sociology ok it is coming equal to sociology and i have
left it here now see the size of all the columns all the
columns have the same size with whom we can do the same
thing? we can do it with rows ok what we have to
on rows? like i have done all the rows
i have selected all the rows ok i have to bring it between
any two rows ok i have to bring the cursor of the mouse and
here i can see the arrow and i will see only between 4 and
5 the line which you can see i will notice this line that
how much size i have to make i have to make this much size
i will leave it here so the size of this what happened? it
became even what is the size of all? what is the size of
every row? it became even so you can do this thing with
multiple rows and multiple
you can do it by selecting only once ok so that's all for
today's video see you in the next video