Excel - Pasting from Cell Copied to Clipboard, the Clipboard Value Can Change - Episode 1582
Microsoft Excel Tutorial: Copy a Cell and Paste Multiple Times - the Clipboard Value can Change.
Welcome to another episode of the MrExcel podcast. In today's episode, we're going to dive into a little Excel mystery that I like to call the "Paste Surprise". I stumbled upon this while working on a spreadsheet and I couldn't believe what I discovered. So, I wanted to share it with all of you.
First, let's take a look at the clipboard. I have some numbers and a formula that gives us a result of 3. I copy that 3 to the clipboard and then paste it as a value, adding it to the existing numbers. As expected, we get a result of 9. But here's where things get interesting. The numbers and the formula are being averaged in another cell, and now the cell with the formula has a value of 2 instead of 3. But wait, the clipboard still shows a 3. What's going on here?
I was under the impression that once I copied something to the clipboard, it would stay there until I pressed escape. But that's not the case. When I paste the value and add it, Excel goes back and re-evaluates the formula, resulting in a different value. This was a shock to me, as I had never encountered this before. In fact, I had a similar situation where I was adding 3 years to a date and copying it down a column, only to find out that the values were incorrect. It turns out, the same "Paste Surprise" was at play.
So, I want to hear from all of you. Did you know about this "Paste Surprise" or were you just as surprised as I was? Leave a comment on Lipson or YouTube and let me know your thoughts. And don't forget to hit that like button and subscribe for more Excel tips and tricks. Thanks for tuning in and I'll see you next time for another episode of the MrExcel podcast.
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(00:00) Surprising Feature when Pasting
(00:14) Display the Clipboard
(00:26) Copy cell with 3 to clipboard
(00:39) Paste Values Add
(00:59) The value on the clipboard updates!
(01:29) Do you expect 9 or 10?
(01:59) Are you as surprised as I am?
(02:21) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelclipboard
This video answers these common search terms:
how to open clipboard in excel
how to use microsoft clipboard in excel
how to copy formula in clipboard in excel
how to access clipboard in excell
what is clipboard in excel
It's like the Shell Game...but perhaps more intriguing. Using Paste Special in combination with an Operation [available in the Paste Special Dialogue] Bill is working between Excel and the Clipboard to make changes in his Worksheet. What Bill discovers is an odd disconnect between Excel and the Clipboard once the first operator and Paste operation is completed... Follow Bill in Episode #1582 as he describes and models this odd phenomenon and maybe you can keep it from affecting you!
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Watch video Excel - Pasting from Cell Copied to Clipboard, the Clipboard Value Can Change - Episode 1582 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 09 August 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,536 once and liked it 10 people.