Excel 2007

[Cash]

How do I set the calculations to update automatically?
I have checked the settings have been set to update automatically.
(no need for F9)

 

[Fred Smith]

Office button>Excel Options>Formulas>Calculation Options>Automatic

Regards
Fred

 

[david d]

i want to start in g26 enter data then be able to press enter and go 70 cells
down in the g column to g96 and enter data then press enter and go to cell
g166 so on and so forth. how do i write this formula

 

[Jim Cone]

A formula cannot be used to select cells.
Helpful posting advice here...
http://www.cpearson.com/excel/newposte.htm

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"david d"
wrote in message
i want to start in g26 enter data then be able to press enter and go 70 cells
down in the g column to g96 and enter data then press enter and go to cell
g166 so on and so forth. how do i write this formula

 

[Roger Govier]

Hi

In addition to Fred's suggestion, if you look at the far right of the
Formulas tab, there is an option to Calculate Now, and to set the
Calculation mode Options.