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.
For any number of different reasons you sometimes need to view your data up-close, you want to see it larger. Now there is much data perhaps, but you want to see it very clearly, maybe someone is looking over your shoulder, maybe you're using a projector so that others can view the data. And at other times you want to step way back to sense the layout of a worksheet. There certainly are some standard ways to approach these different views, and of course one is the View tab in the menu, or we could certainly could choose Zoom here. And a dialog box out of the past, we could make a choice here. 200% possibly, something like that, easy to use. That's fine.
Not exactly fast, but it's there. And for a variety of different reasons we can type in our own number here too, any number from 10 to 400 if we wish. Obviously, we can't read this so well, but we are sensing the layout of this worksheet. You'll also notice a button here for a 100% zoom. There we go. That's fast. That's easy. And even in some situations you can highlight data and simply Zoom to Selection, in other words use the available screen space to show just this data, something like that. Now, in Excel 2007 we saw introduced in the lower right-hand corner of the screen a slider bar, and we can simply slide this to zoom back and forth.
That's certainly fast and handy. But I think better yet is the time- honored, and I say time-honored-- It's been around in Excel since Excel 2000. Before that it was somewhat limited. We can zoom in and out quickly by holding down the Ctrl key and moving the mouse wheel. Zoom in and out, as needed. I use this a lot because I do a lot of live teaching and I want things to be large and clear on the screen. And of course, at other times we zoom back. This by the way also works beautifully in Microsoft Word as well. So easy-to-use feature.
It clarifies things, it gives you a better handle. I also think it's a good idea when you're editing yourself for example that has a formula, say this one here, zoom in on it, make it big and clear. And then if you want to edit, perhaps double-click, you don't have any difficulties seeing that. You can see the commas versus the periods clearly and easily. So an easy to use tool. Ctrl with the mouse wheel to zoom in and out.
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.