"pumper" wrote
One more question...if I want Column C, i.e., C3 downward all the way (all
the way down, say I have a long spreadsheet) to have the same formula as
in
cell reference C2, how do I do that

Just copy C2 down

Point the cursor at the bottom right corner of C2
(the cursor will change to a "black cross")

Now just left-click and drag down to copy C2 to C3, C4 ... C200 etc

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----