so in this video we'll look at top 20 ms excel microsoft sort console let's get started so
first one is control a so using control a you can select the entire worksheet
so let's say the control and then say a so that way it will select the entire worksheet
so let's move to the second one second one let's assume you want to select only use areas in that
case what we do is we first we say is control and then say home so that way it goes to the first
cell then from there i say control shift and end so that way it will select only use area of my
worksheet now let's move that i'll move to the next one the next one is is control space
so using that you can select the entire column so let's go to this set and say
control and space so that way it will select this columns the column c so let's move to the next one
let's assume you want to select the entire row so in that case
what you have to do you have to say select shift and space so let's assume here you are here
and says shift and then space so that way it will select this particular row so let's move to the
next one next one is f2 f2 using f2 what you can do you can edit the current cell so here let's see
i'm at this cell and if i want to enter some text what i have to do using mouse i have to double
click on this one and then i can type something instead what you can do let's assume you are here
and you say is f2 that way it comes comes in the edit mode and you can type something like this
now let's move to the next one next one it says alter enter so using that you can enter a new
line into cell so let's assume i'm here and i say hello and after that i want to have hi
and that has to be in the new line so what i say is i say alter and then say enters and say
hi so that way it comes hi hello and using this one this way you can enter new line so
i say control led and let's move to the next one next one we have something called control then
semicolon using this one what you can do you you can enter the current date so let's assume
i'm here and i say control and say semicolon see you can see the current date now let's go to that
format cell and see what's the type so to type says it date so let's say say ctrl z now the
next one is let's assume you want to enter a current time so in that case what i do i go to
the cell and say current shift and semicolon so it gives me a time so if i go to the cell and i say
it's custom one says h mm so instead let's assume i said time and select probably this one
and say okay okay now let's delete this and say it's ctrl shift and semicolon
let's see this one see it gives me this time strain but somehow it doesn't capture the second
but yeah i think that's fine so next one what we have something called control enter so using that
you can fill the selected cell with uh content of the current so let's do the practical dub so
first one i have a a then i have bb then i have cc so what i say is i select all this c and say
control and then select one and then say f2 and then say uh control enter see all cell become bbb
so that's what you can do using control enter the next one is something what we have is ctrl d so
using ctrl d you can delete the context context of selected say let's assume you have this bbb just
select all these three and say ctrl d okay same also you can do a ctrl z even you can you simply
say delete it will delete this thing so either you can use delete or you can go with ctrl d
so in the next we have a control y so using control y you can repeat the
last action so let's do one thing let's copy this and paste it here so my last action is best so if
i go to the cell and say control y so it will do the best action so that way you can repeat the
last action so let's do ctrl z let's move to the next one the next one we have control
f1 so using that you can say or hide the ribbon so let's do control f1 so it will hide the ribbon
and now let's do a ctrl f1 again so again i can see the excel ribbon so the next one
is uh something called shift f11 so using that you can open a new excel sheet so what i do is i just
shift and f11 so i can see this and you see it that's called as seat four so let's delete the
set so let's go to the next one so next one i have control page down and up so using that you
can go to the next or previous workshop so let's do control and then say page down or rc page app
see it's moving
so that way you can move to the next day so the next one we have the control g
so using that you can open the go to dialog so i say control and say control g so it will open
the go to dialog box even i can do f5 so using that again i can open this go to dialog box
the next one we have a control f which using that you can find or replace dialog box
so let's do this ctrl f so here you have that find or replace box so you can type something you can
find for this one it didn't find something again if i say control h it directly go to
replace so using that you can find and replace the text so let's move to the next one i say home
then return the first cell of the current row in the worksite so if i am here and say home so
it it comes with the first so uh sale of this row so next one we have something called control home
which is used to move to the beginning of the worksheet so i say control and then say home
so it it comes at the first sale of the entire set so now let's go to the what was the next one
i say control and so the next one is ctrl end i say control and say where is that end and so
it gives it goes to the last cell of that use ready area of the excel the last one we have f1
if i say f1 it will open the help file of the excel i think that's all for this video thanks
you thank you for watching this video and in the next video we'll look at another shortcut