older version of Excel quirk

A

alenhart

This morning I was teaching a basic excel class using an older version
of Excel (probably 2000?)and had an embarrassing incident.
We were discussing how to use the fill handle to update formulas. The
exact example is as follows:

First Name Last Name Column C
Anne Lenhart =B2&", "A2
Julie Jones
Sarah Evans

After we entered the formula in column c, I pulled the formula down
through the remainder of the column and although the formulas updated,
the values did not unless I went back and manually selected each cell.
Here I was, teaching, and I didn't know what was wrong!

Can anyone tell me how to fix this so next time I am in this situation
I don't embarrass myself?
Thank you,
Anne
 
R

Ron Rosenfeld

This morning I was teaching a basic excel class using an older version
of Excel (probably 2000?)and had an embarrassing incident.
We were discussing how to use the fill handle to update formulas. The
exact example is as follows:

First Name Last Name Column C
Anne Lenhart =B2&", "A2
Julie Jones
Sarah Evans

After we entered the formula in column c, I pulled the formula down
through the remainder of the column and although the formulas updated,
the values did not unless I went back and manually selected each cell.
Here I was, teaching, and I didn't know what was wrong!

Can anyone tell me how to fix this so next time I am in this situation
I don't embarrass myself?
Thank you,
Anne
Click to expand...

Probably need to set calculation to automatic:

Tools/Options/Calculation Calculation Automatic
--ron
 
Top