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.
If you create a chart in Excel and put it in the same worksheet as the data, sometimes you want certain kind of control over how the chart is placed. If you have worked with charts, you probably know that if you'd like to move a chart, you need to only click just inside the border and drag perhaps in one smooth action here, like that, move it around wherever you want. Sometimes you might have other charts with this, or you just want to move it a little bit. If you hold down the Ctrl key as you click on a chart, you've put it into a certain kind of mode, so that you can nudge the chart by simply pressing arrow keys.
So, I'm pressing the Up Arrow right now and you see how this is moving the chart just slightly upward. Or leftward, or downward. If you work with graphics a lot, either objects or images like this, that might be not too critical. Something else you might want to do though, something different really, is that when you click on a chart, you perhaps recognize that on each midpoint, on the four sides and on the corners, you see little dots. These are sometimes called handles. If you drag one of these corners, of course you can make the chart taller, wider, narrower, whatever.
But if you hold down the Alt key, something special happens. This serves as if to be a magnetic attraction so that the edges line up with cell boundaries. You don't always see this so clearly. So, right now I've got the Alt key held down. You see as I'm dragging here, I'm not jumping to the edges. This happens almost automatically. I'm going to let go of the mouse now. As I click outside, you see how perfect and even that is. So, if you have that sort of special need, if you want these edges to line up just perfectly with the cell boundaries, as you drag a corner or edge, hold down the Alt key, and then let go of the mouse first as you drag these. Just makes it look neater and tidier.
I didn't do on the bottom here. Actually, it works best if you do two opposite corners and then that takes care of two edges at a time. Let's try this again down here, holding down Alt. There we go. Let go of the mouse, and then click away from it to see the effect of it. If you've got some kind of a shadow effect on this, it might not be so obvious. You can quickly do this, and you can do this with most objects as well too. Reposition the chart to make it look the best. Keep in mind too that two of our top ten shortcuts for creating charts, one here, if we want a chart real quickly right here on the worksheet, it's just Alt+F1.
Invariably, that does need repositioning. So, use either of the two tips we've talked about. Either align this with edges, again holding down Alt, or possibly just nudging it by Ctrl+Clicking and using the arrow keys. So, different ways to control the placement of charts on a 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.