SOLVED

Locking a column in a table formula

New Contributor

in a normal excel formula (not in a table), I can lock a cell reference with a $, e.g.  $A$1 locks in the cell to copy the formula.  How do I accomplish this within a table formula to lock in a column, say column A in a table? 

5 Replies

@Timothy_Neumann  You can read more about locking cells here:

$A$1 locks columns and rows

$A1 locks columns only

A$1 locks rows only

best response confirmed by Timothy_Neumann (New Contributor)
Solution

@Timothy_Neumann I believe you can find the answer to your question here:

https://exceloffthegrid.com/excel-tables-absolute-references/ 

@Riny_van_Eekelen 

 

Thanks for that link, exactly what I was looking for, great explanation

@adversi 

 

The $ doesn't work in a table formula, structured reference

 

For anyone reading this: using this trick has massive performance downfalls when used repeatedly in big(-ish) tables. Just spent 2-3 hours fighting performance issues with a file that had a ~500-row table and ~100 columns, where even just opening the file took about 2 min. Removing those "fake range" references eliminated the issue completely.