You can automatically copy a formula or function to other cells.
To copy (or cut) and paste formulas:
Select the cell(s) that you wish to copy. A heavy border will appear around the cell(s).
Copy the cell contents. Go to the Edit menu and select Copy, or press Ctrl+C on your keyboard.
Select the cell(s) that you wish to paste into.
Paste the formulas. Go to the Edit menu, and select Paste Formulas. Or, press Ctrl+V (note that this keyboard shortcut will also paste any formatting that was applied to the copied cells). For more help on pasting, see Cut, Copy, and Paste.
The formulas will be pasted into the selected cells. If relative cell references were used, the pasted formulas will be adjusted according to the cell locations. See Relative and Absolute Cell References for details.
Copying to Cells in Same Row or Column
To quickly copy the formula from a cell to the cells below or beside it, use AutoFill:
Click on the cell whose formula you want to copy. A heavy border will appear around the cell.
Move your mouse cursor to the small black square in the bottom, right corner of the cell. The regular pointer will change to a small, black plus sign.
With the black plus sign visible, hold down the left mouse button. Do not let go, and move your mouse cursor down to select cells in the same column, or to the right to select cells in the same row. You can select cells in only one of these directions at once. The selected cells will be highlighted and surrounded by a heavy border.
After selecting the cells to copy to, release the mouse button. The formula from the original cell, along with formats, will be pasted into all of the cells that you selected. If relative cell references were used, the pasted formulas will be adjusted according to the cell locations. See Relative and Absolute Cell References for details.
To remove the highlighting, click outside of the highlighted cells.
See Also: