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.
You can create shapes quickly and easily in Excel by going to the Insert tab and choosing Shapes. Bigger question might be, why do you want these? Well, you might be creating a flowchart. You might be creating a logo perhaps, just a little bit of design. You might want to put arrows on a worksheet to point to certain cells, a variety of reasons. Many of these shapes also certainly can include text for labeling. Sometimes you're doing it just to add a bit of flair to a worksheet, but a couple of approaches to these. General approach toward any of these shapes is if you want to draw one of them, you click the button here, you find the shape you want and maybe it's a hexagon, maybe it's an octagon, whatever. Here's a hexagon.
We draw it, wide, tall, narrow, however, but if you are drawing any shape, if you hold down the Shift key, things change a little bit. I'm still holding Shift. We're about to create a perfect hexagon or better stated, maybe a regular hexagon with equilateral sides and equilateral angles. Sometimes we want to do this. Hold down Shift, be sure to let go off the mouse first. Now, this is an oval. What if we want a circle here? Back to Insert, Shapes, here's an Oval. As we drag this, it could be very large, it could be very wide, it could be very tall, but if we hold down the Shift key, it's a perfect circle.
Let go off the mouse at some point. There we go. Same thing with rectangle. This was drawn as a rectangle. So, that's the way it looks, but if we wanted a square, we'd click the rectangle button, drag, and as we drag, we hold down Shift to get a perfect square. That's true of all the shapes here and there's a ton of them of course and we got all of these here and a variety of them, same general approach. Some of these shapes, for example this one and maybe you're going to use this for a particular purpose. I'm just going to drag it. I'm not holding down Shift necessarily, but let go.
You will see yellow diamonds from time to time, and it's hard to describe these except by example, but they usually affect the inner lines. Here it isn't even quite accurate, but drag this around a little bit and you see what's happening. We're not changing the overall frame, but we're certainly changing the way this looks. You are going to be approaching a rectangle at some point. You'll learn to be attuned to those. And here's our good old friend in here, smiley face, and that's there too. So, there's smiley face looking like Friday, and there's smiley face looking like frown-face Monday, whatever.
You drag this around as you wish and that could have been a circle, but I didn't bother holding down the Shift key. Once a shape has been created, for example this one, if you'd like to make it larger or smaller and keep the same aspect ratio, that's the ratio of height to width, as you drag any corner-- now remember it could go wide, tall, whatever. But if you hold down the Shift key, you'll be keeping that same aspect ratio. Do that. If you want to make an object larger or smaller but keep the same center, you want to hold down the Control key as I'm doing here.
Now, if I drag the right edge here, this is making it wider or narrower as you can see. I'm holding down the Control key, and maybe I'll let go and do a Ctrl+Z here. What if I wanted to make this larger around the same center, but keep all the sides equidistant from the center? Instead of just doing this, what happens if I hold down the Control key? This. So, I'm holding down Control now. I could do this. I'm holding Control, and what if I hold down Control and Shift? We're making it bigger.
Now, you can imagine, don't write any of this down. You just have to try this and in all cases here when you're trying these variations using the Control or the Shift key or both together, be sure if you want to keep the effect to let go off the mouse first then the keys. And so I think we all wished we had something like this back in the fourth grade, but it's a great fun sometimes, and of course, the real purpose probably in many cases is to apply some text here, and we can just right-click and choose Edit Text or if the text is already there, or to add text as well, but some ideas on creating these.
Sometimes you also want to create a series of objects that are the same. So, sometimes you have an object already created. If you press Ctrl+D, think of D for duplicate. We've duplicated this, and we will move one around and so on, as for design or flowcharts or whatever. So, Ctrl+D will duplicate a shape. Also, when you're creating a shape, and you know that you have to create a series of shapes and maybe they're not all going to be exactly of the same dimensions. Suppose you wanted to create a series of rectangles. Maybe this one doesn't exist.
On the Insert tab, when you choose Shapes, and you're about to choose Rectangle, you can right-click the choice and lock the Drawing mode, meaning I'll drag a rectangle. Now, this rectangle has to be somewhat wide and not so tall. I need another rectangle down here. It's going to be substantially larger. In other words, I don't want to duplicate the first one. I want a different rectangle, and notice that I'm still in Drawing mode. I need another rectangle here. By locking the Drawing mode, you allow yourself to create this shape indefinitely until you press Escape, and we're out of that mode now.
So, a couple of different approaches here for creating these shapes and making it a bit faster. There's a lot more to do with these, and this is not really a course on manipulating shapes, but just a couple of quick ideas for controlling the look of shapes and their placement and fast ways to get there.
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.