Forum Discussion
For Formula Editing, mouse input to modify argument to refer another Table Cell same row?
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
- sunnyschindlerBrass ContributorI now learned instead of clicking, use structured reference by typing in following order
[
@
select column
]
Thanks for your help! - sunnyschindlerBrass Contributor
I now learned instead of clicking, use structured reference by typing in following order
[
@
select column
]
Thanks for your help!
- sunnyschindlerBrass Contributor
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.
- sunnyschindlerBrass ContributorI meant is there quick step with mouse input (not keyboard)?
You can point with the mouse to a cell in a table while creating a formula.
Or to a data column:
- sunnyschindlerBrass ContributorThanks for prompt response, would you mind sharing how to point from a Table Cell? Your screenshot shows pointing from a non-Table Cell.
Cheers!