Forum Discussion

sunnyschindler's avatar
sunnyschindler
Brass Contributor
Jul 24, 2023

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

steps recorder

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

    Thanks for your help!
  • I now learned instead of clicking, use structured reference by typing in following order

    1. [

    2. @

    3. select column

    4. ]

    Thanks for your help!

  • 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.

      • sunnyschindler's avatar
        sunnyschindler
        Brass Contributor
        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!

Resources