Copying formulas by scrolling
 

When I attempt to copy formulas by scrolling down, I the formula appears to
copy correctly, but the value in each cell remains the same. For example,
when I scroll formula A2-A1 and scroll down, the formula increases by 1 in
each cell. However, the value appearing in each cell remains the same
number--almost as if ignorning the formula! What is going on?

THANKS!!!

Copying formulas by scrolling
 

ToolsOptionsCalculation.

Check Automatic.


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 14:43:01 -0800, skluck
wrote:

When I attempt to copy formulas by scrolling down, I the formula appears to
copy correctly, but the value in each cell remains the same. For example,
when I scroll formula A2-A1 and scroll down, the formula increases by 1 in
each cell. However, the value appearing in each cell remains the same
number--almost as if ignorning the formula! What is going on?

THANKS!!!