Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In cell B2 we see a formula - you can see it in the Formula bar - that takes the information from column A and presents it in a perhaps better way, or at least a way that you want to use. Anytime you have formulas that operate off of other data, you have the possibility of saying in effect I'd like to keep the results or the answers and effectively throw away the formula. In other words, we might want to delete column A, but if we do the formulas in column B have nothing to refer to. And throughout column B here, where you see the information, perhaps the way we want this.
And what we'd really like to do is get rid of column A. So let's highlight this data. We can just double-click here to copy this again, and the standard way to do this is a multi-step process whereby we right-click and copy or do some other method of copying. And then either by using one of the buttons on the Home tab or possibly by right-clicking we need to go into Paste Special, and then Paste Values. And nothing wrong with that, it does work, and if we did that in effect we would have turned these into the results.
The word values by the way might throw you a little bit. Typically in Excel, values refer to numbers, but in this case it means non-formulas. So we've converted these into the results. And that's not a bad process. I am going to press Ctrl+Z though and show a better way to do this. Let's imagine we've selected the data. With the right mouse button either dragging the top edge, left edge, right edge, it doesn't make any difference, what if we were to drag this data into column A? Right mouse button held down, drag it in to column A. When you let go with the right mouse button it reveals this traditional use. There is that shortcut menu.
And what do we want to do here? Copy Here as Values Only. So what we now see in column A is the way the data looks in column B. We're all set. We could now get rid of column B. Now that's just fine. Possibly another way to approach this could be,we've got the data here looking as it was I just did a couple of Undos. How do we take this data and actually copy it on top of itself? After selecting it, point to any edge, and then with the right mouse button drag right-left, right back on top of itself, let go with the right mouse button, Copy Here as Values Only.
I use this feature a lot. I think it's a great shortcut. It'll save you a lot of time whenever you're trying to convert formulas into the results.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 99062 Viewers
80 Video lessons · 141760 Viewers
59 Video lessons · 60130 Viewers
52 Video lessons · 73260 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.