How to Auto Fill Rows in Excel

Sequences
1. Launch Microsoft Excel or create a new, blank worksheet to experiment with.
2. Click the first cell in the first column (Cell 'A1').
3. Type the number '1' in the cell and press 'Enter' to store the cell contents and move to the next cell in the column (Cell 'A2').
4. Type the number '2' in the cell and press 'Enter' to store the cell contents and move to the next cell in the column (Cell 'A3').
5. Type the number '3' in the cell and press 'Enter' to store the cell contents and move to the next cell in the column (Cell 'A4').
6. Click cell 'A1' and hold down the mouse button while dragging the mouse pointer down to cell 'A3.' Release the mouse pointer to select the first three cells.
7. Move the mouse to the lower-right corner of cell 'A3' while the three cells are selected until the mouse pointer changes to a small black cross with no arrows.
8. Click and hold the mouse button and drag the mouse pointer down the column for a few cells and release it. Notice that Excel automatically continued the sequence of numbers in the column based upon the selected numbers. The same feature also works with dates.
Formulas
9. Launch Microsoft Excel or create a new, blank worksheet to experiment with.
10. Click in the first cell in the second column (Cell 'B1') and type the word 'Rent' in the cell. Press the 'Tab' key to store the cell contents and move to the next cell in the row.
11. Type the word 'Power' and press 'Tab.' Repeat this process for the words 'Food' and 'Phones.'
12. Click in the second cell in the first column (Cell 'A2').
13. Type 'January, 2012' in the cell and press 'Enter' to store the value and move to the next cell down the column.
14. Click the cell 'A2' and point at the lower-right corner of the cell until the mouse pointer turns into a small black cross with no arrows.
15. Click and hold the mouse button and drag the mouse pointer down to cell 'A13' to fill in the date sequence automatically.
16. Type the number '750' in cell 'B2' to represent the rent for January of 2012. Press 'Tab' and type the number '75' to represent the power bill, and press 'Tab.' Repeat using '200' for food and '120' for phones.
17. Click cell 'B2' and hold down the mouse button. Drag the mouse pointer across to cell 'E2' and release the button.
18. Point the mouse pointer at the lower-right corner of cell 'E2' until the mouse pointer turns into a small black cross with no arrows.
19. Click and hold the mouse button down and drag the mouse pointer down to cell 'E13' to copy the values of all four columns to each of the months in the list.
20. Click cell 'F2' and click the 'AutoSum' button in the 'Editing' group on the home tab. Press 'Enter' to store the formula.
21. Point the mouse pointer at the lower-right corner of cell 'F2' until the mouse pointer turns into a small black cross with no arrows. Click and hold the mouse button down and drag the mouse pointer down to cell 'F13' to copy the formula for the sums of the rows.