i'm going to talk about you how useful
checkboxes for data entry in excel so
here we have what it looks like and so
for example I am entering in customers
or people's name address and then the
vast majority of my customers come from
Edmonton and so so i'll put in Joe Blow
here 35 something lane
ok and now since with the majority of my
clients are here from Edmonton so what
I'm going to do is I'm just going to
click on the checkbox here and then
automatically it fills in this whole
line it saves a bunch of typing in this
one section let me show you how I did
this so let's open up a new sheet here
the first thing that you need to do is
you need to have the Developer tab on
your screen so right-click by the ribbon
here and then you're going to go
customize ribbon and from the dialog box
that comes up you make sure that the
Developer tab is checked here and then
you say okay and then you're good
what we're going to do on this Developer
tab we have an insert below a little
toolbar here a toolbox here and then
from the top forms control we select the
checkbox now we go out to our screen we
press the Alt key so that it goes right
into a cell and press enter
that's how you put it in now what you
need to do is you need to right-click on
the and then you can go edit text and
what you can do is
is you can put in whatever question you
want to be answered true or false what I
need to do here is I need to specify
which cell is going to have the answer
to true or false
so what I'm going to do is I'm going to
right click again on here and I am going
to format control so right now it's
unchecked but cell link i wanted the
answer to appear in which cell so i'm
going to click a little red arrow here
and i'm going to select the cell
directly next to my my check box and
then i'm going to click my little red
arrow again and I'm going to say ok so
now when it's not checked you have
nothing there but when you check it it
says true so what we're going to do with
the true is we're going to we're going
to go in the next cell to the true so
we're going to enter an if statement
here so if this cell is true
then we're going to have the answer to
the question and if it's not true if
it's false
we're just going to have it say nothing
and we're going to close our are
quotations in our bracket here and we're
going to press ENTER and so it says
answer to the question and if we take
that check box off it says nothing
now the other thing that we're going to
do a cover over the falses or the true
now you could hide this or the other
thing you can do is you can right click
this and what we can do is we can format
and we can create a fill-in here so
right now has no filll and so let's
select the lowest level of fill that we
can and will say okay and then what I
simply did is I just dragged over my
answer here so if you are if you need to
have a checkbox and you check it then
you have the the text already entered
into the cell that you need so that's
how you use a check box with an if
statement to simplify data entry please
subscribe