Forum Discussion

cornucopia's avatar
cornucopia
Copper Contributor
Nov 04, 2021
Solved

SUM!?

Where am I going wrong?  I've used Excel for years.  When it comes to adding up cells in the column above, I've merely inserted = and then clicked on each above cell which highlights in a different c...
Excel on Mac
cornucopia's avatar
cornucopia
Copper Contributor
Nov 04, 2021

SergeiBaklan 

 

Thank you, Sergei.  That solves the problem.  Finally someone understood what I was getting on about!  Why Microsoft would exclude this function is beyond me.  It was ideal.  But then again, I ask myself why Microsoft has so many bells and whistles in everything they create (e.g., this forum!)

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 04, 2021

    cornucopia Not too long ago it popped up again, at least in MS365. Under Excel, Preferences, Edit you can Enable "Click to add mode".

    • cornucopia's avatar
      cornucopia
      Copper Contributor
      Nov 04, 2021

      Riny_van_Eekelen 

       

      Dear Riny, 

       

      Thank you.  

       

      I. sorry but I do not find any "Click to add" in my Preferences or anywhere else in Microsoft Excel for Mac, v. 16.43

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Nov 04, 2021

        cornucopia I'm currently on 16.56 (Insider, Beta). Can't remember when the Click to Add mode appeared, but it was about 6 months ago. Not sure though.

Resources