This a very useful feature. It wiill save you time and typing!
You will have to practice this on your own version of Excel.
Go to cell A1 and type:
You have now filled down the number 1 into cells A1-A12.
Point the mouse to the bottom right corner of cell A1 -
Your cursor should turn into a black cross-hair (+)
then click and hold the left button and drag to cell
A12. When cells A1 - A12 are highlighted, release the
You can also create a series of numbers:
Now Highlight both cells B1 and B2, and fill down
(using bottom right corner of cell B2) to cell B12.
You should now see a series of numbers from 1 -12 in
Go to cell B1 and type:
Go to cell B2 and type:
We can also fill down formulas. Let's go to cell C1 and write a formula to add cells A1 and B1.
You should see different values in cells C1-C12
In cell C1 type:
= A1 + B1
Fill down the formula through cell C12
Look at the edit line in several of the cells in column C - the formulas should change corresponding to the row that you are in.
If a particular reference needs to remain the same regardless of row. The reference should be proceeded by a $ sign.
How is it different then column C? Look at several of the cells in column D. Notice that all cells in column D contain reference to cell B1.
Go to cell D1 and type:
= A1 + $B$1
Fill D1 down through D12
Back to the Tutorial