Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to copy the contents into another cell?
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. |
#2
|
|||
|
|||
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:
Last edited by CNWatsonJr : March 2nd 12 at 05:04 AM |
#3
|
|||
|
|||
Quote:
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy the contents into another cell?
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell contents with VB | Excel Discussion (Misc queries) | |||
Copy Contents from Cell | Excel Programming | |||
how to copy the contents from last cell | Excel Discussion (Misc queries) | |||
Copy cell contents? | Excel Programming | |||
copy cell value not contents | Excel Discussion (Misc queries) |