How to edit A Cell In Excel Without Double Clicking Mac
How to Activate Cell Editing Mode in Excel With a Single Mouse Click
0:00 / 0:00
Quality:
Sharing buttons:
how to activate cell editing mode in
excel
with single mouse click hello everyone
welcome to excel 10 tutorial in this
advanced excel tutorial i'm going to
show you
an excellent way to go to cell editing
mode with a single mouse click okay
let's get started
[Music]
there are three ways to go to cell
editing mode in excel
first one is if i double click most of
us use this
double click and we are in the editing
mode and we can
start writing the second way is that we
click on a cell
and just click on the formula one and it
is in the editing mode
and the third way is if you select the
cell and if you press the keyboard
shortcut
f2 and you are in the editing mode okay
these
are the three basic ways to activate
cell editing mode in microsoft excel and
the mostly used option is double click
but
in this tutorial i am going to introduce
a new way
so that if you click on a cell it will
automatically go to the editing mode
with a single click so i
click here it will be in the editing
mode this is what i
am going to show you in this tutorial
this is an advanced excel tutorial
and i am going to use vba for this to do
that we are going to right click on the
sheet1 tab
click on the view code and we are in the
visual basic editor and take a look at
here we are in
sheet1 this is the worksheet where i
want this functionality
now write the code i have already
written the code if you need the code
please check the link in the description
and when you have done it please close
the vbe
and it's done now if you click anywhere
with a single mouse click you can go to
the editing mode just check here you can
see
we are in editing mode again in cell d4
single click and we are in editing mode
okay and
in c2 single click we are in editing
mode so this is how you can
achieve an additional feature to
activate editing mode in
cells in microsoft excel so from now on
you will have four ways to go to the
cell editing mode and the first one is
double click and the second one
is if you select and write in the
formula bar and the third one is if you
select and press keyboard shortcut f2
and the final one is just a click and if
you activate this you won't need the
rest of them so click here
and it's in the editing mode okay thank
you thanks for watching see you in the
next tutorial if you can support the
channel through patreon please share the
video with your friends and don't forget
to subscribe
thank you
