Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Quick Data on the Selected Data Range

Monday, February 16th, 2009 by | Filed Under: MS Excel, MS Office Help
 
Loading...


Quick Data on the Selected Data Range

Do you ever find that you need a quick piece of information? You know, a sum, average or a minimum or maximum value on a range of MS Excel data.

What did you do?

Did you write a formula in a cell?

Well, if you want to keep the information in the worksheet, that’s an excellent plan. But what if all you need to know is one or two pieces of information and you don’t want them to stick around?

If that’s the case, you have to wonder if there’s any way to quickly see the information in Excel, without all the hassle of formulas.

It’s a good thought and I’m happy to report there’s a quick and easy way to accomplish just that!

The information you seek is all on the Status Bar.

Yep, you may have never noticed it before, but there’s useful information about a selected data range just sitting there waiting for you.

Let’s take a look!

As always, you have to go through a couple different sets of directions, depending on the version of Excel you’re using.

We’ll start with the older versions of Excel.

With the data highlighted, you’ll find the information in the bottom right hand corner of the Status Bar.



Right now, it shows a sum, but you have a few other choices as well. Right click on the Status Bar and you’ll see that there are several different functions to choose from.



Unfortunately, you can only display one at a time, but it’s still faster than a formula and whichever one is currently chosen will automatically be displayed all the time.

Now, for those of you using Excel 2007, things are pretty much the same, but with a few “perks!”

The highlighted range data is displayed in the bottom right hand corner of the Status Bar, just like the other versions.



However, you may notice that you’re seeing more than one piece of information about the highlighted data. That’s definitely what I’d consider an improvement over the older versions!

In addition, you can still right click on the Status Bar and add even more data.



Again, the added advantage is Excel 2007 will display all of them at once, should you choose it to be that way.

I’d say that’s a lot of information for very little hassle. Just the way I like it!

~ April

Comments are closed.

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: