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:

**Learn 16 more excel copy pasting tricks today.**

- Last updated on May 27, 2009

Share

Share on facebook

Facebook

Share on twitter

Twitter

Share on linkedin

LinkedIn

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:

**Learn 16 more excel copy pasting tricks today.**

Share on facebook

Facebook

Share on twitter

Twitter

Share on linkedin

LinkedIn

**Share this tip **with your colleagues

Simple, fun and useful emails, once per week.

**Learn & be awesome.**

Thank you so much for visiting. My aim is to make **you awesome in Excel & Power BI. **I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Chandoo is an awesome teacher

*– Jason*

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

**One email per week** with Excel and Power BI goodness. Join 100,000+ others and get it free.

© 2019 All rights reserved

## 16 Responses to “Use Enter to Paste Copied Values in Excel [Quick Tip]”

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?

I'm dying to know the answer too ....

Use Fn + Enter

THANK YOU!

Thanks from me too. I found this answer via a google search. Much quicker using the enter key than Ctrl-v innit?

i want copy the data in various sheet in one at time for all sheet shows me the same data.

can this be turned off?

Seriously, can this annoying "benefitial ability" be turned right the hell off?

That must be a bug. It's so annoying and useless. Whats Ctr + V for if not exactly for that? Can this be turned off? Also, Excel already dumps the "clipboard" in so many unfitting situation since apparently it's not even using the clipboard to copy paste but relies on the "copied" contents to actually remain in the cell and it will loose this content whenever you move focus to a different cell.