When you create a worksheet, you will often need to use data or formulas that you used elsewhere in your worksheet. EXCEL allows you to copy formulas or data. Again, there is more than one way to do this:
Using the tool bar
· Select the range of the formula or the data to be copied.
· Click the copy toolbutton .
· Move the cursor to the location where you want to copy the information. You can click on a cell or on a range of cells by using the CRTL or SHIFT keys.
· Click this button (paste) to reproduce the data or formula in the selected location.
Using the mouse (to copy to an adjacent cell) 
· Select the range of the formula or the data to be copied.
· Move the pointer to the inside right corner of the selected cell. Note that the cursor changes shape when you point to the inside right corner of a selected range.
· Click and hold the left mouse button when the pointer is positioned in the inside right corner of the cell. Drag the cursor to the location to which you wish to copy the data or formula. The cell which you are copying and the cells which are about to receive the copy should be outlined by dotted lines.
· Release the mouse button.
Using the mouse (to copy to a non-adjacent cell)
· Click the range of the formula or data to be copied.
· Press and hold the CTRL key.
· Move the pointer to the bottom line of the selected range; the pointer should display a white arrow and a small black cross.
· Click the bottom line of the selected range and hold down the left mouse button. Move the cursor to indicate the location to which you want to copy the data or formula. Unlike in the previous method, only the destination is marked by dotted lines.
· Release the mouse button when the pointer is in the location to which you want to copy the information.
Note: This method is useful when copying to a single cell.
Using the menus
· Click the range of the formula or data to be copied.
· Click the Edit menu, then Copy. The selected range is then surrounded by a flashing dotted line.
· Move the cursor to the location to which you want to copy the information. You can click a cell or range of cells using the CTRL or SHIFT keys.
· Click the Edit menu, then Paste.