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






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Cell Reference
: Range operator produces one reference to all the cells between two references

, Union operator combines multiple references into one reference

(space) Intersection operator produces on reference to cells common to the two references








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