If you’ve ever copied something in Excel and ended up with a completely different result than you expected, you’ve probably fallen foul of one of Excel’s little quirks. The good news is that once you understand Excel Paste Values, you’ll know exactly how to handle it – and it only takes a couple of extra clicks.
What’s Actually Happening When You Copy and Paste?
Here’s the thing. When you copy a cell in Excel, you’re not copying what you see – you’re copying the cell contents. Now, that can be exactly what you can see. If a cell contains a formula (and that’s the point of a spreadsheet) that formula is what gets copied.
Most of the time, that’s exactly what you want. Formulas are what make spreadsheets so powerful, after all. But sometimes you just want the displayed information, not the calculation behind it.
What Goes Going on With a Standard Paste
Let’s say you’ve got a column of totals calculated by a formula, and you want to copy those totals somewhere else. You copy, you paste – and instead of your expected numbers, you get zeros or completely wrong figures.
That’s because Excel has moved the underlying formula, and in its new location it’s looking at the wrong cells. Nothing’s broken – it’s just doing exactly what you told it to do.
This is where Paste Values comes in.
Where does Paste Special fit in?
When you need to copy and paste something different, that’s where the ‘special’ options come in.
There are a few different options, but ‘Special Values’ is one that you might find especially useful.
It will paste in what you see when you look at the spreadsheet, and nothing else.
When you need to copy the results of a formula, it’s the go-to option.
How to Use Paste Values
Instead of reaching for Ctrl+V as usual, go to the Paste button on the Home tab in the ribbon. You’ll notice it has two parts – the icon at the top for the default paste, but click the little arrow underneath and a menu opens up.
You’ll see quite a few options in there. Under the Paste Values section, click the first icon.
That’s it. Your data will paste across exactly as it appears on screen – no formula, no formatting carried over, just the values.
The Keyboard Shortcut
If you’re a fan of keeping your hands on the keyboard, there’s a shortcut worth knowing. Copy your data as normal with Ctrl+C, then instead of Ctrl+V, use Ctrl+Shift+V to paste values only.
It’s a small variation but it saves you reaching for the mouse every time.
A Quick Note About Dates
One thing to be aware of – if you paste values from a cell that contains a date, it might look a bit odd at first. You could see a number rather than an actual date.
Don’t panic! Excel stores dates as numbers behind the scenes. All you need to do is format that cell as a date, and it’ll display properly.
It Works in Excel on the Web Too
If you use Excel in your browser rather than the desktop app, you’re not missing out. The same option is available there – look for Values Only in the paste menu. It works in exactly the same way.
A Small Trick, a Big Difference
Paste Values is one of those features that feels almost too simple once you know it’s there. It won’t change your life, but it will save you a fair bit of head-scratching – and that’s always worth knowing about.
Created with the help of Claude AI from an original transcript.
YouTube Videos
Excel Flash Fill – Split Names, Create Emails & More in Seconds
How to Use Excel Sparklines to Spot Trends at a Glance
Excel Paste Special Values – Copy Exactly What You See on Screen
Already Colour Code Your Excel Data? Here’s How to Filter by Colour
Related Excel Tips Posts
Do You Know All the Excel Flash Fill Tricks?
Excel Sparklines: The Tiny Charts Making a Big Difference
Excel Paste Values – Get Exactly What You See, Every Time (current post)
Why Your Colour-Coded Excel Data Deserves a Better Filter
Recent Posts
- Copilot Knows Less About You Than You’d Think
Copilot work account data is the handful of details from your Microsoft account that Copilot uses to personalise answers. It’s far less than you might expect. On the Copilot Basic licence that comes with a business plan, mine showed my office location and nothing else. The paid Premium licence adds a little more, but not… Read more: Copilot Knows Less About You Than You’d Think - 3 Quick Ways to Take Control of Copilot Memory
Copilot memory is the set of details Copilot automatically saves from your conversations, and there are three quick ways to take control of it: ask what it knows about you, tell it what to remember, and delete anything that’s wrong or out of date. It takes a couple of minutes, and it’s worth doing every… Read more: 3 Quick Ways to Take Control of Copilot Memory - Copilot Custom Instructions: Say It Once, Get Better Answers
If you keep typing the same things into Copilot every time (make it shorter, make it friendly, use UK spelling), there’s a setting that does it for you. It’s called Copilot custom instructions. You save details about yourself and how you like responses written, and Copilot applies them to every new chat. It takes about… Read more: Copilot Custom Instructions: Say It Once, Get Better Answers - What’s Actually in Your Microsoft 365 App Launcher?
Open your Microsoft 365 app launcher and you’ll find more than 20 apps staring back at you. You’ll only use a small handful of them regularly. The rest fall into “useful sometimes” or “you’ll probably never touch this” territory. This post has Microsoft 365 apps explained in plain English. Each one is grouped by how… Read more: What’s Actually in Your Microsoft 365 App Launcher? - The OneNote Feature I Rely On More Than Any Other
If you’ve ever typed a search word into OneNote, you’ll know the feeling. Every relevant note appears, no matter which notebook it was buried in. That’s why so many people ask how to search across notebooks in OneNote in the first place. Being able to search across notebooks in OneNote is, for me, the single… Read more: The OneNote Feature I Rely On More Than Any Other
excel paste values, excel paste values only, paste values not formulas