When a Name Box Isn’t a Name Box
Did you know that MS Excel’s Name box isn’t always the Name box (the box to the left of the Formula bar?)
I know it sounds crazy, but it’s true!
Pay attention when you type in an equal sign (=) to start a formula.
Did you see what happened?
The Function box first displays the last used function.
If that’s not what you’re looking for, click on the down arrow to the right of the function name.
Is the function you need still not there?
If so, click on More Functions (at the bottom) and you’ll be taken to the usual Insert Function window, where you can proceed as normal!