Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
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.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.