Cell Reference

Cell and Range

• A7 – single cell
• A7,A14 – cell A7 and cell A14
• A7:A14 – range from A7 to A14 (same col)
• A7:Z7 – range from A7 to Z7 (same row)
• A7:Z17 – range from columns A to Z and rows 10 through 17

Reference Types

• Relative - automatically changes when the formula is copied down a column or across a row
• Absolute - cell reference is fixed, doesn't change when copied to other cells.
  *Uses $ sign like: $A$1
• Mixed - has either an absolute column and a relative row, or an absolute row and a relative column
  *Like A$1 or $A1 

Referencing from other the sheet

• Same file
  – Manual selection
  – Use a formula
  Ex: Sheet2!A1
• Different file
  – Manual selection
  – Use a formula
  Ex: [File2.xlsx]Sheet1!$A$1
         Absolute by default 

(c) Sir Tom