You missed this part..............

In C4 enter =$C$3

Copy to C5 and C6


Gord

On Sun, 11 Mar 2012 00:54:33 +0000, sumesh56
wrote:


CNWatsonJr;1514140 Wrote:
Does C3 have a value or a formula in it? If it is a value, click on C3
and then press CNTRL-C (if you are on a PC or Command-C on a Mac) and
then click on C4, C5 and C6 (by either holding the Shift or Control key
down) and then press CNTRL-V (or Command-V on a Mac).

If C3 has a formula and you haven't locked the cell reference with $
($C$3) then the cells you copy into will self adjust the formula. If C3
is a formula and you want to copy the value, then press CNTRL-C and then
highlight the cells you want to copy into, right-click and then choose
Paste Special / Values.

You can also put the formula =C3 in the cells C4, C5 and C6 and that
will place the data that is in C3 in the selected cells.

Hope this helps you some.

sorry, i want the data which i am going to type on c3 should
automatically come to c4,c5,and c6 cells. for that i have to format the
said cells. how can it be accomplished?