How to drag a formula down in excel quickly
Excel Tutorial Tip 1 - Copy Formula Down Column. Excel Training Courses Sydney
Timecodes:
you
here's a little time-saving tip if you
have a formula that you want to copy
down an entire column in this
spreadsheet
I have sales for New South Wales
Queensland and Victoria by month and
here in cell e2 I have a formula that
adds New South Wales plus Queensland
Pass Victoria sales for the month of
January now let's say I want to copy
that formula down so that it populates
the cells underneath for the months of
February through to December here's a
quick and easy way to do it start by
selecting the cell that contains the
formula and then position your cursor in
the bottom right hand corner of the cell
until a little black plus sign or cross
appears when you see that black cross if
you double click your left mouse key the
formula will automatically be copied and
pasted down to the cells underneath now
I'm just going to remove the formula
that I added to those cells because I
want to show you something I'm also
going to delete the entry for Victoria
Sales in June now watch what happens
when I use that same copy process the
formula is only copied down to the month
of May and that's because this June cell
here is blank the formula will only be
pasted if the cells in the column
immediately to the left are populated
with text or data it will stop the copy
and paste process when it reaches a
blank cell so if I now type a figure
back into the June cell for Victoria and
I then double click on the little black
cross sign here the formula will be
pasted down into the remaining cells
you
Related queries:
how to drag a formula down in excel fast
how to drag formula down in excel faster
how to drag a formula down in excel
how to drag a formula down
drag a formula down in excel shortcut
