MS Excel TUTORIAL/REVIEW

Back | Back To Start | Next

5 Sorting and Filling

Sorting

To sort means to alphabetize.

The Sort Buttons

Autofill

The Autofill feature allows you to quickly fill cells with data such as months or numbers, and repeated text.

1. Type the beginning number or date of a series or the text that will be repeated into a cell.
2. Select the handle at the bottom, right corner of the cell with the left mouse button and drag it down as many cells as you want to fill.
3. Release the mouse button.

Autofill Functions

Autofill can also be used to copy functions.

In the example, column A and column B each contain lists of numbers and column C contains the sums of columns A and B for each row.

The function in cell C2 would be "=SUM(A2:B2)".

To copy this function:

1. Select the handle at the bottom, right corner of the cell.
2. Hold down the left mouse button.
3. Drag down as many cells as you want to fill.

Spreadsheet 123 Spreadsheet Software Development