Cell Reference Examples : Cell Reference « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Cell Reference

A1 is Cell in column A and row 1

A1:A10 is the Range of cells in column A and rows 1 through 10

A1:F1 is the Range of cells in row 1 and columns A through F

1:1 is the All cells in row 1

1:5 is All cells in rows 5 through 10

A:A is All cells in column A

A:F is All cells in columns A through F

Summary!A1:A10 is the Range of cells in column A and rows 1 through 10 in worksheet named Summary









6.3.Cell Reference
6.3.1.Cell Reference Examples
6.3.2.Reference Operator
6.3.3.Relative Cell ReferencesRelative Cell References
6.3.4.Absolute Cell ReferencesAbsolute Cell References
6.3.5.Mixed Cell ReferencesMixed Cell References
6.3.6.Create an Absolute ReferenceCreate an Absolute Reference
6.3.7.Change an absolute reference back to a relative referenceChange an absolute reference back to a relative reference
6.3.8.Create a 3-D Cell ReferenceCreate a 3-D Cell Reference
6.3.9.Reference all values in a columnReference all values in a column