MS Excel in this latest version, has some very easy browsing techniques. Having said that, suppose you aren’t exactly sure what you are looking for? Suppose you know what you need but can’t remember the name of the formula? It is easy to become aggravated under these circumstances. Surely there must be a quicker way to find it without going through the Formula Ribbon!
Well I’m here to tell you that there really is an easier way. When you cannot remember an exact formula name, you no longer have to roam around looking for it.
Follow the steps below to find out how:
- Start the formula with the usual equal sign (=) and they type the first couple of letters in the formula that you need.
- MS Excel 2007 will automatically provide you with an alphabetized list of formula names, starting with the letter(s) that you entered. It will even provide you with descriptions when selected.
- Browse through the list to select the correct formula that you need.
Now here is a handy little tip regarding this tip – an extra if you will.
- To select the formula name, use your Tab key or, if you prefer, double click the formula with your mouse.
Great information to have, don’t you agree?