April 1, 2008

Excel – 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?

generic viagra usa src=”http://imgsrv.worldstart.com/mso-images/name-box-as-formula-box.gif” border=”1″ width=”283″ height=”57″ />

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, click on 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?

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!