Editing a formula with the cell

Shelly68

Board Regular
Joined
Sep 12, 2006
Messages
73
Hi, presently if I want to edit the formula I have to go up to the formula bar to do it (for instance if I want to put a sum in there).

How can I set the sheet up so that all I do is type the = sign and it will work (without having to go click the tick in the formula bar)

Hope this makes sense!!

TIA

Shelly
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Shelly:

I am using EXCEL 97 with Windows XP, and I can write a formula starting with = sign in the cell or in the Formula Bar without having to Click the Tick left of the Formula Bar.
 

McGu

Board Regular
Joined
Oct 10, 2006
Messages
135
I think I understand, but am not sure

If what you are trying to do is enter a formula; just select the cell that you wish to insert a formula in, then hit the "=" and type your formula. Is this what you are asking?

Hope that helps.
 

Shelly68

Board Regular
Joined
Sep 12, 2006
Messages
73
Yes, that's exactly what I mean, (and of course it works on the excel version that we are using at work).

It's the one at home that doesn't work, if I type =2*5 (for eg.) it will leave it as that, it won't put 10. I can remember something from a couple of years ago that was in TOOLS, OPTIONS but I can't find it now. Something that you either ticked or unticked for 'calculate within cell'

I'm not sure which version we're using at home, I'll have a look later on and post (when I get home)

Thanks
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,871
Hi Shelly

Maybe you have View Formulas on? Please try

Tools>Option>View, uncheck Formulas

Hope this helps
PGC
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Or

press the ~ key while holding the CTRL key -- this toggles between displaying the formulas and corresponding results.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,634
Members
410,804
Latest member
bluepinky
Top