newbie Create new column question

B

brucer

Hello,

I want to create a new column "D" which is column "C" + 100.

I can enter in cell D1 the forumla : =C1+100
which does the trick for D1.

But how do I propagate that for all column "C" cells?

Thanks,
bruce
 
S

Salmon Egg

brucer said:
Hello,

I want to create a new column "D" which is column "C" + 100.

I can enter in cell D1 the forumla : =C1+100
which does the trick for D1.

But how do I propagate that for all column "C" cells?

Thanks,
bruce
Click to expand...

Copy D1. Select asmuch of column D as you wish and paste.

Bill
 
B

Bob Phillips

Go to the bottom right of cell C1, until the cursor changes to a thick black
cross, and mouse-down double-click and it will fill-down.
 
Top