A cell reference in spreadsheet programs such as Excel andGoogle Sheetsidentifies the location of acellin the worksheet.
These references use Autofill to adjust and change information as needed in your spreadsheet.
A dollar sign tells the program to use that value every time it runs a formula.
You’ll typically use an absolute or mixed cell reference if you set up a formula.
A cell reference consists of thecolumnletter and row number that intersect at the cell’s location.
When listing a cell reference, the column letter always appears first.
Cell references appear informulas, functions,charts, and other Excel commands.
You don’t need a sheet notation if you’re referring to a cell in the same worksheet.
A notation referring to another workbook in Excel also includes the name of the book in brackets.
You identify ranges of cells by the starting and ending cells.
To include everything in Column A, the range will be “A:A.”
To use Row 8, you’ll punch in, “8:8.”
Relative cell references change when copied to reflect the new location of the formula.
The namerelativecomes from the fact that they change relative to their location when copied.
At times, cell references need to stay static when formulas are copied.
The values in those references don’t change when you copy them.
In this case, you’ll use a mixed cell reference such as =$A2+A$4.
To convert relative cell references to absolute or mixed cell references:
