Knowing when to use mixed references

Book cover This article is an excerpt from John Walkenbach's Favorite Excel 2007 Tips & Tricks by John Walkenbach. A.k.a. Mr. Spreadsheet, John is arguably the foremost authority on Excel. His forty-plus books include Excel 2007 Power Programming with VBA, Excel 2007 Formulas, and the bestselling Excel 2007 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pack. Visit to learn more about this book.

In a mixed cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.), either the column or the row is absolute (and therefore doesn’t change when the formula is copied and pasted). Mixed cell references aren’t used often, but in some situations, using mixed references makes your job much easier, as you can see in the following article.

Read Article button

Applies to:
Excel 2007