Wednesday

Excel 2003 and 2007 -- Edit formulas

Did you know...

You can edit formulas in 2 different places?

Anything you enter into a cell will show up not only in the cell, but also in the formula bar. Here is a picture of a formula entered into a cell and showing in both the cell and the formula bar. The result is in the cell the formula is in the formula bar.


If you look at the formula bar (next to the fx) you will see the actual formula. If you look in the cell you see the results.

Now, if you double click in the cell you will get a blinking cursor and be able to edit your formula right in the cell. It will look like this:


If you double click in the formula bar (next to the x √ fx) you will get a blinking cursor there and you will be able to edit in that box as well.

Give it a try.

Doesn't work for you? Email me at grandberry@gmail.com

We help you like your computer.
Comments welcome.