How to drag Numbers In Excel Mac
2.1 Dragging Code & Numbers in Excel
0:00 / 0:00
Quality:
Sharing buttons:
okay so we're gonna do Excel in here so
for this we first want to look at
dragging numbers dragging numbers and
then dragging patterns and then we'll
look at dragon code and then locking
cells okay if you want to increase the
size you can just double click here that
just gets it to the size of the largest
one okay so dragging numbers first of
all I'm gonna put one into that cell
just one if we want to copy the number
all the cells down you look at that on
that black cross and then you click and
hold and you just drag down and you're
making all one there so that's nice and
dandy and you can drag it across as well
if you want or yeah and then so I'm
going to pull it back up to here so
that's cool so if you drag it down one
number then it would just change all of
the numbers like that if you have a
pattern for example two and you drag it
will drag all the numbers in that
pattern so one two three four five and
it will do increments of one like that
I'm gonna get rid of that
similarly enough if you just have any
sort of pattern so let's say we have 1 4
so we've got by 3 7 then you drag it and
then it will be in that pattern so go by
3 each time so if we have something like
this as well sorry that was a bad
example
I meant to just do the two yeah so it
can
dragged down a pattern usually
relatively simple pattern like simple
increments and stuff like that or you
can just drag down the one number and
then it'll just copy it through all of
them so that's dragging numbers and
dragging patterns as well so now we want
to do code so I'm gonna say let's say
this is our X and this is our while
something like that so I'm gonna do one
two and then use our dragging thing to
drag down to that and so now we want y
equals and then we want y equals let's
say 2x so you just do two times and then
you click the the cell there so then it
comes up a four plus five so now we're
doing y equals 2x plus five basically so
you hit enter now dragon code it's quite
simple we drag down and it's quite smart
about it it changes this for each one so
you see like how our code up here is
going from a six because it's when we
look across it's at a six when we go
down one a seven changes Hey
what you will notice though is we've
only dragged down so that's that's all
well and good but if we drag across it
changes because now it's just
referencing a cell that's just next to
it just directly to the left of it so
this one is referencing that one and so
when we drag the across the code across
to here this cell is referencing this
cell so it's not the same you can't just
drag it across like that so let me just
clear this yeah so you can't just drag
it across like that if we want to drag
it across what we could do is you can
lock columns so for example I'm going to
lock the a column so to do that you just
put the dollar sign in front of it so
I'll show you what that means if we lock
the a column I'm going to drag this down
here
it's the same thing doesn't change
anything there then if we get this and
we drag it across it's gonna be the same
because it's locked out a column so it's
not going to change to our revert to our
B column as it did before so absolute
referencing I think it's called it's
absolute reference to the a column there
so it's also kind of cool that you can
um do is we'll just clear this one out
you can say like eighteen or something
like up here and you can specify a
number like coefficient so you have
eighteen here and then now we're gonna
do a new column so Y times by co F
coefficient so we just can do that
equals that times by this okay so first
of all I'll see that so that works
perfectly right when we drag this down
it doesn't know what this is since this
is referencing this cell OH
the escape to get out of that if you
make it an error in that so if you click
on there and you wanna get out just
click escape but yeah so we're not
referencing any cell in here but then as
well so we still keep going down so
that's like that's not exactly what we
want if we try and do what we did before
but we lock our IE 1e columns so it's
just gonna go down that's not gonna do
anything since it's just gonna keep
going down there and but if we look our
three column instead by doing the dollar
sign in front of the three you can see
that when we drag it down it works
perfectly so sorry so you can see that
each cell is referencing that the
problem happens again if we try and drag
this across because when we look into
this cell it's still locked
r3 but now I've dragged it across to the
right and so the referencing image
to the right one so to fix that we can
go into this cell you can edit it up
here or you can edit it down here it
doesn't really matter if we lock our e
as well so we've locked both the Ian's
and the three so you can't move anything
you drag and you reference the E and
three it's always going to reference
that III cell so I'm gonna hit enter and
if I drag it across and down well across
and then down it will grab our Y value
there and then grab our e ry coefficient
and then grab our 18 here so that's what
locking both cells means and so we've
gone through dragon code down so we just
have dragging it can get easier as you
go on it's better just to keep
practicing with things just dragging
card and seeing what happens but I think
it's quite intuitive and you can pick it
up quite quickly
