Section 5 - Filling Data

AutoFill allows you to automatically copy a cell and fill its data into adjacent cells. Filling data into a spreadsheet is similar in Excel XP, 2007 (Windows OS), and Excel 2004 ( MAC OS X).

To perform an Auto Fill:

• To fill across or down, move the mouse pointer to the bottom right-hand corner of the cell you want to copy, the pointer will change to a black cross called the fill handle.

• Next drag the mouse to fill the cells adjacent to the active cell.

To fill a series:

• Type the first data set in the first cell of the series.

• Click and drag the Fill Handle from this first cell to the cell where you want the series to end.
• Release the mouse button.

When you fill a series, the information proceeds consecutively.