ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shorcut to put the value of one cell into another in the same work (https://www.excelbanter.com/excel-discussion-misc-queries/88179-shorcut-put-value-one-cell-into-another-same-work.html)

Christopher ATC

Shorcut to put the value of one cell into another in the same work
 
Can anyone tell me how to shift-click or whatever the shorcut is to put the
value of one cell in the same workbook in to another cell on a different
sheet in the workbook please? Thank you.

Peo Sjoblom

Shorcut to put the value of one cell into another in the same work
 
Ctrl + C, right click the cell where you want it and select paste special
and link

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Christopher ATC" <Christopher wrote in
message ...
Can anyone tell me how to shift-click or whatever the shorcut is to put
the
value of one cell in the same workbook in to another cell on a different
sheet in the workbook please? Thank you.




Christopher ATC

Shorcut to put the value of one cell into another in the same
 
Thank you for responding, but there is another way to do it without having to
right click it is something like double clicking the destination cell then
shift clicking the source. I still need to figure this out!

"Peo Sjoblom" wrote:

Ctrl + C, right click the cell where you want it and select paste special
and link

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Christopher ATC" <Christopher wrote in
message ...
Can anyone tell me how to shift-click or whatever the shorcut is to put
the
value of one cell in the same workbook in to another cell on a different
sheet in the workbook please? Thank you.





David Biddulph

Shorcut to put the value of one cell into another in the same
 
"Christopher ATC" wrote in
message ...

"Peo Sjoblom" wrote:


"Christopher ATC" <Christopher wrote in
message ...
Can anyone tell me how to shift-click or whatever the shorcut is to put
the
value of one cell in the same workbook in to another cell on a
different
sheet in the workbook please? Thank you.


Ctrl + C, right click the cell where you want it and select paste special
and link


Thank you for responding, but there is another way to do it without having
to
right click it is something like double clicking the destination cell then
shift clicking the source. I still need to figure this out!


= in the destination cell, then click in the source?
--
David Biddulph




All times are GMT +1. The time now is 09:15 AM.

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