Formula showing column heading instead of cell reference.
When I click on a cell to add it to a formula I get a column title instead of a cell reference and it only happens on this cell, why is that happening and how do I fix it?
iMac, macOS 10.13
Question marked as
Top-ranking reply
That is a cell reference. It is "using the header names as labels" to create a cell reference that some might find more meaningful than the standard "A1" kind of reference. I personally don't use it. It can only do it if the header names are unique. In your screenshot there is only one 6/20/2021 but several of the other dates.
Numbers/Preferences/General
Uncheck "use header names as labels"