Absolute References

To indicate an absolute reference, use a dollar sign ($) before the row and the column. For example, to copy the exact contents of cell C5 into an assumption parameter text box, enter the cell reference =$C$5. This causes the value in cell C5 to be used in the assumption cell parameter text box. Later, if you decide to copy and paste this assumption in the worksheet, the cell references in the parameter text box will refer to the contents of cell C5.