Mixed References
Once you've mastered the concept of relative vs. absolute cell references, consider the third type of reference: a mixed cell reference.
In a mixed cell reference, either the column or row reference is absolute while the other reference remains relative. Thus, you can use cell references like A$1 or $A1. Use this when a column reference must remain constant but a row reference changes or vice versa. Figure 51 shows a good example.
Figure 51. The formula in cell C7 includes two different kinds of mixed references. It can be copied to cells C8 through C10 and C7 through E10 for correct results in all cells. Try it and see for yourself!
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
