50 likes | 274 Views
Excel Cell References. Types of Cell References. Relative Cell References Default Excel behavior Cells change relative to new location Absolute Cell References Cells stay the same, regardless of new location Indicated by $ symbol Mixed Cell References
E N D
Types of Cell References • Relative Cell References • Default Excel behavior • Cells change relative to new location • Absolute Cell References • Cells stay the same, regardless of new location • Indicated by $ symbol • Mixed Cell References • Either the column or row changes based on new location
A B C D E F G H 1 2 3 4 5 4 2 =A$1+5