This Excel tip blew my mind!

Think of some of the infomercials you’ve seen such as the Snuggie or Ginsu Knives or that spray on hair or the Magic Bullet. They all try to make you think you have a problem that only their product can solve. Chances are, it’s not a real problem. I just had the opposite experience with Excel. I had a real problem that I assumed was just part of life. I learned out of the blue that there was an answer that would make work just a little easier. A big thank you to the ministry of Leila Gharani for sharing this tip.

So, here was my problem. I work in Excel almost every day, and several times a month I will need the sum of numbers in one spreadsheet for an email or message or even another spreadsheet. I thought there were only two ways to solve this:

  1. Use a Formula: I could enter the sum formula (e.g., =SUM(A2:A25)). I could then Copy and Paste Values to where I wanted the number. I never liked this method and rarely ever used it.
  2. Rely on Short-Term Memory: Highlight all the numbers you want the sum for. On the bottom right, you can see the sum. Quickly repeat that number over and over, and then write it down in the next location. Then you need to double check the number. Although this sounds horrible now that I’m writing it out, it’s the method I have preferred.

Here’s the tip I learned: Just click the sum on the bottom right to copy the number to the clipboard. It is that easy. I’m not sure how long this functionality has been available. I’m hoping it is brand new for the sake of my pride. I show you exactly how in the video. Enjoy!

  4 comments for “This Excel tip blew my mind!

  1. Jennifer Erickson
    August 12, 2022 at 7:41 am

    You’re the best!!! Good luck this fall professor Jeff (you’re not going to make them attempt your last name, are you?) 😉

    Jennifer Erickson Remote Accounting Services 605-254-5780


    • August 12, 2022 at 7:55 am

      Ha ha ha! Thanks, Jennifer! Perhaps the name pronunciation should be on the Final? 😉

  2. Marilyn Perry
    August 12, 2022 at 9:46 am

    Dear Jeff,

    WOW! Wow! Wow! I didn’t know this either! And I watch lots of Leila’s presentations!

    Thank you! Keep these coming!

    Best Wishes to you, Jeff! Marilyn (763) 427-6080

    • August 12, 2022 at 9:58 am

      I know! I was afraid I had missed something for the last 20 years, but it looks like this was added to Excel within the last year.

Leave a Reply

%d bloggers like this: