What is Cell reference?
The address of a spreadsheet cell, such as B2, used in formulas.
A dollar sign makes part of it absolute so it does not shift when the formula is copied.
Learn more
- Formulas and cell references in Excel and Google Sheets formulas
- IF, SUMIF and COUNTIF in Excel and Google Sheets formulas
- Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH in Excel and Google Sheets formulas
- Text, dates and pivot tables in Excel and Google Sheets formulas