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.
Quote:
Originally Posted by sumesh56
i have some data on cell c3 ,say "data"
i want to copy paste the information on c3 to cells c4,c5,c6.
now i tried = c3 in cell c4 by clicking on cell c3(didnot type c3).but instead of getting the information on c4 , i get =c4
what is wrong. kindly help, thanks and have a nice day.
|