Step-by-Step Instruction:

Formulas can be copied into multiple cells at a time by using the autofill feature. Consider the spreadsheet below. Column B can be filled with formulas to perform the same calculation on each cell in column A using a fill down operation.

For example, to make each cell in column B equal twice the corresponding cell in column A, perform the following steps.

- Enter the formula “=2*A1” into cell B1.
- Select cell B1.
- Use the fill down operation.

*This can be done more than one way:*

### Using the mouse

- Click and hold on the small box at the bottom right corner of the border on B1.
- Drag down until the dashed box contains cells B1:B4.
- Release the mouse button.

### Using the keyboard, if accessibility is enabled

- Press and hold the shift key and use the down arrow to highlight cells B1:B4.
- Release the shift key and press control D.

The result of this operation will be a spreadsheet with similar formulas in cells B1:B4, as shown below.

A similar process can be used to fill to the right. The keyboard shortcut is control R.