Tuesday, November 16, 2010

Mixed cell reference

A mixed cell reference is either an absolute row and relative column or absolute column and
relative row. You add the $ before the column letter to create an absolute column or before the
row number to create an absolute row. ex: $A1 is absolute for column A and relative for row 1

No comments:

Post a Comment