Dragging/Copying Formulas in Excel 2007

D

DebPgh

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!)
 
E

Eduardo

Hi,
Go to the microsoft icon at the top left,then Excel options at the right
bottom, formulas 2nd option, there you have calculation in first place
 
M

Mike H

Hi,

Yet another person praising e2007!!

Formula Tab|Calculation group|Calculation options and select automatic

If that doesn't work ensure your cells are formatted as general before
entering the formula
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top