Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Here are a few formatting tips you might find handy. In this database list, when someone leaves the organization, rather than deleting the record right away, what you prefer to do is to make a change to the display of the data. For example, Timothy Tanner here has just left. You want to leave the data here, but what you'd like to put in is strikethrough. And you can probably figure how to get there by way of Format > Cells, but Ctrl+5 is certainly is fast. It applies strikethrough formatting. Ctrl+5. Click it again. It disappears.
It's a toggle button. By the way, you may notice also that in the last entry here under Job Rating, the 4 actually has a strikethrough, but it's real subtle. You're probably not going to notice that at all, but you can certainly see it in the other cells. Only when we zoom way in might you see that, but that's handy, and that's fast. It's Ctrl+5 for strikethrough, apply it or take off. Now, border feature sometimes make sense in worksheets and a lot of times you might apply this manually. For example, maybe these cells should stand out because they're the only really pure numbers in this worksheet.
So we might in the Font group on the Home tab, click the drop arrow, tons of choices here. If that's not enough, we'll be going to more borders. Maybe we want to use this choice. Now, one border style has its own keystroke shortcut. And we might try it here. These are the percentages. We want make them stand out for whatever reason. It's Ctrl+Shift+Ampersand. That's the symbol above the number 7 key or if you want to say it that way, Ctrl+Shift+7, and you don't see the real effect of this until you click outside of this, but that applied a thin border.
Ctrl+Shift+7. Try it again down here, and again, click away from it to see how that's applied. Those are certainly fast and easy tools to use here. Now, you may want to get rid of borders and whether it's in this range or that range, select the cells that surround this. Maybe we want to get rid of the borders down here. Maybe all of them. Highlight the data first. I always think it's best to pick up the data that surrounds it as well, then you'll see immediately whether this is working or not. But to remove borders, it's Ctrl+Shift+Underscore. That's one key of the right of the 0 key.
That removes all borders within the selected area. And in certain worksheets, if you've got borders- let me press Ctrl+Z here. If you have borders in a lot of different locations, you might as well click in the upper left-hand corner and then simply Ctrl+Shift+_ to remove all border features in that worksheet.
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.