Hi,

I have entered a small formula in a cell =A1+B1 the result is also fine but
if i have edit the formula i have to again type the entire thing.
Is there a shortcut to this where i can easily do the editing of the
formula, i guess i am missing something out here.

Hi,

I guess you are not able to see the formula in the formula bar if it is so
then go to Tools|Options|View|check the formula bar check box|ok
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Niroo" wrote:

Hi,

I have entered a small formula in a cell =A1+B1 the result is also fine but
if i have edit the formula i have to again type the entire thing.
Is there a shortcut to this where i can easily do the editing of the
formula, i guess i am missing something out here.

Double click the cell; you should see the word "Edit" in the status bar. Now
you can edit the formula.
Alternatively, select the cell and press F2 to open Edit mode
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Niroo" wrote in message
...
Hi,

I have entered a small formula in a cell =A1+B1 the result is also fine
but
if i have edit the formula i have to again type the entire thing.
Is there a shortcut to this where i can easily do the editing of the
formula, i guess i am missing something out here.