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.
Whenever you are about to print a worksheet, it's a good idea to get a preview of it first. I think we have all at one time or another printed some information, we thought we were printing a page and got 85 pages of junk or something like that. We can click the File tab. We can click Print, get a preview off on the right-hand side, that's not so bad, and we might have put in, as I have, in the Quick Access toolbar a Print Preview button, and there we go. That's pretty handy too. But maybe even faster, and we can certainly get to it in a flash at any time, is Ctrl+F2, a relatively new keystroke shortcut introduced in Excel 2007.
Any time you want to get a quick, preview of how this worksheet is about to look if we print it right now, Ctrl+F2, and a quick Escape and we are out of here. And here in there of course, we get surprises. For example in this worksheet, obviously we should adjust our column width first, but even here, Ctrl+F2, there it is, a rough idea of how that's going to look. Of course, we will have to do other things to make it look just great, but no question, this is a good, quick keystroke shortcut. Ctrl+F2, Print Preview.
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.