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
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