Issues with structured references in single-row tables
Often, I will set up formulas for a table before the raw data is available. During this time, the table has a single, initially empty non-heading row. If I want the year of the Date column, I type =YEAR( and click on the Date cell in the same row as my formula. I end up with =YEAR([Date]) instead of =YEAR([@Date]).
Excel recognized that I selected what happens to be the entire column, and so gave me the whole-column reference [Date]. Excel should look at how the selection was made rather than what was selected.
Excel should instead behave like this: if I click on a cell in the same row, then I should get the [@Date] style of reference, and if I click at the top of the column heading, then I should get the [Date] style of reference.
Currently, I have to resize the table to contain at least 2 non-heading rows to make the referencing by clicking work properly.