Cell Reference
- name of a cell.
- can be used in formulas.
Cell and Range
J1 – single cell
• J7,J14 – cell J7 and cell J14
• J7:J14 – range from J7 to J14 (same col)
• A11:Z11 – range from A7 to Z7 (same row)
• A7:Z17 – range from columns A to Z and
rows 10 through 20
Reference Types
Relative - changes when the
formula is copied down.
Absolute - 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
Walang komento:
Mag-post ng isang Komento