ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to copy the contents into another cell? (https://www.excelbanter.com/excel-worksheet-functions/423857-how-copy-contents-into-another-cell.html)

sumesh56
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.

CNWatsonJr
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 (Post 1512089)
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.

sumesh56
Quote:
Originally Posted by CNWatsonJr (Post 1514140)
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?

Gord Dibben[_2_]
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?


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com