And column coordinates makes an absolute cell reference that won't. Get the insight into Excel absolute and relative cell references, and find.
When the formula is copied or dragged across rows/column, the cell reference will not change.
This add-in will save you time when writing formulas with structured references (table syntax), and it's FREE! Video Overview Cell References When creating formulas with cell references, we can simply but a $ symbol in front of the column letter or row number to lock or anchor the cell reference.
This post explains how to quickly create absolute references for table formulas using the Absolute References Add-in.
