Absolute Cells.

1. In cell A1, type 5.
2. In cell A2, type 10.
3. In cell A3, type =A1+A2 (Press Enter)
4. Click cell A3 so that it is active.
5. Select the Edit Menu. Choose Copy.
6. Highlight cells A4 through A14.
7. Select the Edit Menu. Choose Paste.
8. In cell B1, type 5.
9. In cell B2, type 10.
10. In cell B3, type =$B$1+B2 (Press Enter)
11. Click cell B3 so that it is active.
12. Select the Edit Menu. Choose Copy.
13. Highlight cells B4 through B14.
14. Select the Edit Menu. Choose Paste.


Notes are located at at http://excel.schtuff.com/excel_absolute_doc
.