Results 1 to 3 of 3
  1. #1
    Lightbulb Excel Feature That I Can't Believe I'm Just Now Noticing
    I use MS Excel nearly every day of my life and have for many years. How am I just now noticing that when you select multiple cells (contiguous or not), that Excel conveniently shows you the average, count, and sum at the bottom right of the window (to the left of the zoom slider)? This is really nice! Not sure if this is a new feature or if it's been there for years, but in either case, just thought I'd mention this in case others didn't realize this.

    Screen Shot 2020-02-02 at 3.10.28 PM.jpg
    -Jonathan
    iMac (27-inch, Late 2012) - 2.9 GHz Intel Core i5
    MacBook Air (13-inch, Mid 2012) - 1.8 GHz Intel Core i5

  2. #2
    Excel Feature That I Can't Believe I'm Just Now Noticing
    krs's Avatar
    Member Since
    Sep 16, 2008
    Posts
    1,397
    Rep Power
    12
    In the older version of MS Excel (2011) it will show one of the following, selected in a drop down menu:
    None
    Average
    Count
    Count Number
    Max
    Min
    Sum

  3. #3
    Quote Originally Posted by krs View Post
    In the older version of MS Excel (2011) it will show one of the following, selected in a drop down menu:
    None
    Average
    Count
    Count Number
    Max
    Min
    Sum
    I just right-clicked and those other options are there too. I guess I just never paid attention or felt enough "need" for this functionality that I went looking for it. Now that I know it's there, though, it's a great time-saver.
    -Jonathan
    iMac (27-inch, Late 2012) - 2.9 GHz Intel Core i5
    MacBook Air (13-inch, Mid 2012) - 1.8 GHz Intel Core i5

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find feature in Excel not working
    By staygood in forum Switcher Hangout
    Replies: 5
    Last Post: 11-09-2013, 06:21 PM
  2. Anyone Noticing A Problem With Safari?
    By Syze in forum macOS - Operating System
    Replies: 9
    Last Post: 03-29-2011, 10:54 PM
  3. Excel Mac 2008 - AutoComplete feature
    By tiger roach in forum macOS - Apps and Games
    Replies: 5
    Last Post: 05-21-2009, 06:12 PM
  4. I've been noticing an error in posts.
    By milessthomas in forum Community Suggestions and Feedback
    Replies: 2
    Last Post: 09-11-2007, 05:45 PM
  5. Im noticing a trend.
    By DavisCollins in forum Schweb's Lounge
    Replies: 3
    Last Post: 12-13-2006, 11:51 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •