To Copy a Formula from a Single Cell or Range

To copy a formula from a single cell or range of cells down a column or across a row, first , click and hold the mouse on the small square in the lower right-hand corner of the cell, and drag the formula to the "target" cells which you wish to copy.

A) press Ctrl-C
B) select the cell or range
C) press Ctrl-Enter
D) select the whole spreadsheet