Copy Formulas

If you have a table of figures and you want the same formula to be copied either down a column or across a row type in the first fomula and press Enter.
Click back on the cell and hover over the bottom right hand corner of the cell. Your mouse pointer will change to a small black cross. This is called a Fill Handle.
Click and hold on this and drag across or down the relevant cells. This is called Relative Cell Addressing.