MrExcel's Learn Excel #960 - Formula Tooltip

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Feb 27, 2009.
Paul sends in a few tricks to help deal with the Function Tooltip that appears when you edit a cell. Episode 960 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Basically, we start out with massive amounts of data.
How we're gonna analyze this. Well, let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
This is episode 964, February,27 2009.
I'm gonna be out at Microsoft on Monday taking a look at the new Excel 2010.
So hey, here's an invitation if anyone has any complaints, suggestions tips or anything like that.
Drop me a note, bill@mrexcel.com and I can get those directly out to the product design team the folks that design Excel.
Of course all the features for Excel 2010, are already locked down, but soon they're gonna start to think about the next version of Excel.
They'll come out in a couple years.
So let me have it pass those on.
Have a great tip today send in by Paul Leonard.
Paul is talking about feature, how they actually started Excel 2003.
If you would edit a cell, that has a function.
For example, this cell and you click inside the function, interesting thing happens the tooltip appears, the tooltip appears.
Now, the tooltip sometimes gets in the way, you can't see the adjacent cells and if this form had been pointing down to the row below, it would be very annoying.
Well, Microsoft thought of this and you can actually go to the edge of that tooltip and drag the tooltip somewhere else.
Very cool to get that out of the way, another thing is great with this tooltip is.
If you need to figure out how something is working, hover over the function name, and it is a great way to get to help for that function.
All right so, someone send you a worksheet, get quite figure out how the formulas working you can get to help very quickly just basically press F2, click inside the function name, and then click on the function name in the tooltip, and you'll get directly to help for that particular function.
Great tip from Paul.
So, if you have any things, that are just driving crazy about Excel drop me a note and I'll be with the folks next week who can actually do something about it.
Now, of course you're saying well hey, what you are gonna be able to tell us about Excel 2010, and everything's under non-disclosure, so we're gonna have to come up with some sort of a code system.
Maybe if I start winking with my right eye means, they're getting rid of the ribbon and bringing back the old menus.
All right, that's the code anyway.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
Well, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top