Link to home
Start Free TrialLog in
Avatar of Jegajothy vythilingam
Jegajothy vythilingamFlag for United States of America

asked on

Excel 2007

My OS is windows 7.  Is there a function to do a paste.
I would like to copy a cell using Control + C, and then hit a function key to do the pasting to another cel.  Is this possible, if yes how. thank u.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Ctrl+V is already mapped to paste
Ctrl+C is still available.
And in Excel, you can go to the Home tab, Clipboard group (first box) and click on the clipboard picture to paste.
Were you looking for something else?
You do realize that you can record and playback this behavior for these methods in Excel?

HTH,

Kent
ASKER CERTIFIED SOLUTION
Avatar of softpro2k
softpro2k

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jegajothy vythilingam

ASKER

in response to all the suggestions, as u age, u get lazier!  While all the above suggestions are doable, but I am thinking of a lazy man's approach, that is after copying using Control + C, when I am in another cell, just to hit a Function key, to paste (that was copied) to the new cell.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
in response to rspahitz, I think u got my idea.
I would like F-key paste function to be available to all workbooks.  When I hit a Control + C, it should be copied to the F key.   And when I move to any cell, and hit the F key, it should paste the contents.  When I do another new copy command, the new copy should replace the old one in the F key.  
BUT not to apply outside of Excel, as I use so many other softwares, it is not worth my effort to research each and every software whether there will be a conflict.
So it will only be limited to all workbooks in Excel 2007 - any F key which is not in use.
In response to matthewspatrick, your suggestion works, however, it will only do the job,  for one cell.  I would like this function  to repeat for multiple cells when I move to another cell.
thank u everyone.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
good effort. thank u.