[Music]
hello friends welcome to dp-tuner riyals
in this tutorial let's learn a small
trick in ms excel that is how we can go
to last row or last column with data in
ms excel and also learn how to select
the entire row or column in excel in
Excel from any particular cell if you
would like to move to the last row we
generally press this keyboard shortcut
ctrl + down arrow on to move to the last
column we press ctrl + right arrow on
the keyboard
similarly for first row or - first
column we press control up arrow and
down arrow respectively this is all we
need
till now but this is a small interesting
shortcut even for this let's see how it
is now now in the excel sheet go to any
cell and from here if you would like to
move to the last row simply double-click
the bottom edge of this cell you can
observe this for edges of any cell and
when you go to this any of edge you can
see the cursor moving into this move
icon so when you click the bottom edge
for the double times you can see that
the cell moving towards the bottom cell
similarly double click on the right side
right edge of the cell to move to the
last column you can try this with other
two edges to move to the first row and
first column understood friends
so using this feature you can similarly
to select the entire column go to the
first cell
hold shift ctrl and double click the
bottom edge of the cell you can do the
same logic for selecting add a row as
well
so friends I hope you understood this
video tutorial if you have liked this
video please give a like share and
comment for further more interesting
videos please do subscribe for deepen
tutorials thank you friends thanks for
watching