drag

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

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

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