Did you know…
… that Excel’s Name box isn’t always the Name box? (The box to the left of the Formula bar.)
Sounds crazy—I know—but it’s true.
Pay attention when you type in an equal sign (=) to start a formula.
Did you notice what happened?
A Function box replaces the Name box.
The Function box first displays the last used function.
If that’s not what you’re looking for then click the down arrow to the right of the function name.
A small list of functions will appear.
Is the function you need still not there?
Then click More Functions (at the bottom) and you’ll be taken to your normal everyday Insert Function window where you can proceed as normal.