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

Resources