For Formula Editing, mouse input to modify argument to refer another Table Cell same row?

[sunnyschindler]

For Desktop App, I need help to change an argument from text to reference cell in same row.

It is not referencing cell (working same way as a non-Table Cell).

Windows 10 Enterprise 19041.1.amd64fre.vb_release.191206-1406 10.0.0.0.2.4
Microsoft Excel, 16.0.15601.20680

steps recorder

[#2]

I now learned instead of clicking, use structured reference by typing in following order
[
@
select column
]

Thanks for your help!

[#3]

I now learned instead of clicking, use structured reference by typing in following order

1. [

2. @

3. select column

4. ]

Thanks for your help!

[#4]

Please correct me if wrong, Feature of mouse selection of a cell is now lost for formula editing when it comes to Table reference. Instead of a simple single click (as for a non-Table cell), I now have to keyboard the structured reference to a Table Cell; IMHO this requires extra effort of knowing names (Table and Column). If there is a quicker step, I would appreciate the help.

[#5]

I meant is there quick step with mouse input (not keyboard)?

[#6]

@sunnyschindler 

You can point with the mouse to a cell in a table while creating a formula.

Or to a data column:

[#7]

Thanks for prompt response, would you mind sharing how to point from a Table Cell? Your screenshot shows pointing from a non-Table Cell.
Cheers!

[#8]

@sunnyschindler 

Here you go: