Dragging/Copying Formulas in Excel 2007
Don't bother to hate it.............learn to use it.
A simple search in help on calculation will point you to how to change
calculation mode.
Gord Dibben MS Excel MVP
On Thu, 25 Mar 2010 08:44:01 -0700, DebPgh
wrote:
I'm trying to copy a formula in Excel 2007. When I drag the formula down the
column, the calculation from the first cell is copied, even though the proper
formula shows in each cell.
In Oct 2005, JMB answered this question and said to set caluculation to
automatic versus manual by doing Tools/Options/Calcuation - Automatic. But
how do you do this in Excel 2007 where there is no Tools tab???!!
(I HATE OFFICE 2007!)
|