Related Topics:
	Spreadsheets

Cell References

Two types of cell references are possible when entering a formula: absolute and relative.

• A relative reference points to a cell based on its relative position to the current cell (e.g., A1). When the cell containing the reference is copied, the reference is adjusted to point to a new cell with the same relative offset as the original cell.

• An absolute reference points to a cell at an exact location (e.g., $A$1). When the cell containing the formula is copied, the reference does not change.

Absolute references are designated by placing a dollar sign ($) in front of the row and/or column that is to be absolute. For instance, $A$1 is an absolute reference that points to the cell located in Column A, Row 1 regardless of the position of the cell containing the reference.

Referencing a Cell in a Different Sheet

To reference a cell in a different sheet from the one in which the formula is entered, use an exclamation mark (!) after the sheet name. For instance, =Sheet1!$A$1 is a reference to the cell located in Column A, Row 1 in Sheet 1. When referencing a cell in a different sheet from the one in which the formula is entered, the reference must be absolute. If the reference is not absolute, the calculations will not be carried out properly.

You can only reference sheets in the same analysis workbook, standard folio or DOE++ spreadsheet.