drag
## Excel Tutorial Tip 1 - Copy Formula Down Column. Excel Training Courses Sydney

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

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