SubscribeUse Enter to Paste Copied Values in Excel [Quick Tip]
Posted on October 17th, 2008 in Learn Excel - 8 comments
Here is a simple copy pasting tip. Next time when you want to paste a set of copied cells to another area, instead of using CTRL+V, just use ENTER. See this:
![Use Enter to Paste Copied Values in Excel [Quick Tip]](http://chandoo.org/wp/wp-content/uploads/2008/10/copy-paste-tip-excel.png "copy-paste-tip-excel")
Learn 16 more excel copy pasting tricks today.
|
Comments
RSS feed for comments on this post. TrackBack URI
Leave a comment
If you have a question, please ask in the forums
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. 
That’s good, I guess. The thing is that ctrl+V is really easy if you’ve already used ctrl+C to do the copy. This option is useful if you’re the kind of person that finds ctrl+C & ctrl+V difficult, and uses the mouse to copy.
Dude, I think this thing has been around for as long as Excel has lived. What’s new?
And how does it improve efficiency? I already have Ctrl depressed (remember I did a Ctrl-X/C?), and V lies only next to X/C. How’d pressing Enter instead of Ctrl+V help improve anything at all?
Oh, and BTW it’s a bad habit, since it does not work in OpenOffice – so it gets you addicted to a proprietary software
Happy Birthday dude!!!
May your blog surpass Google in fame
@Lincoln: I agree that ctrl+v is extremely easy and you shouldn’t probably change that habit at all.
@Amit: thanks for the wishes
This is not *new*. I just posted about something that I feel can make you fast in doing something. btw, I dont think you will always have ctrl depressed. using enter to paste works well in other ms apps like command console. but again, this is just another harmless tip meant to be useful if needed.
What strikes me about pasting with the Enter key is that Excel then drops the item from the clipboard and it can not be pasted again. Using Ctrl-V instead, I can paste repeatedly into different ranges if I want.
Never figured out the logic behind that.
Teylyn
@Teyln.. you are right.. excel drops the copied stuff from clip board when you press enter.
You might want to drop things from the clipboard. I use Ctrl-V as a habit, and eventually Excel complains that I’ve overloaded the clipboard, then dumps a completely unwanted clipboard menu in my menu bar, displacing my existing menus down a whole row and taking up space. If I can remember to use Enter, I’ll avoid that annoyance.
This does function on my windows PC but not on my Mac?