Copy a cell to a range of cells in Excel 2007

To copy a cell to a range of cells, perform the following:
1. Click the source cell.
2. On the Home tab, in the Clipboard group, click Copy.
3. Select the range of cells.
4. On the Home tab, in the Clipboard group, click Paste.

You will see the marching ants around the source cell. When you see this, you can continue to paste data in other cells by clicking Paste from the Clipboard group.

To do a one time copy and paste, perform the following:
1. Click the source cell.
2. On the Home tab, in the Clipboard group, click Copy.
3. Select the range of cells and press the ENTER key.