Use the AutoShapes to draw any of 70 different shapes to your workbook. Episode 368 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
In yesterday's netcast we talked about how to use the Oval tool to highlight data on your spreadsheet.
Now, we're not just limited to ovals or squares that are here in the toolbar, on the AutoShapes drop-down there are dozens and dozens of different AutoShapes.
You can go to the Basic Shapes and choose anything, you know, even squares, rectangles, even the lightning bolt, just click and drag in your spreadsheet to create the shape.
Now once you have the shape there, there's a couple of options on the Drawing toolbar.
The first one is the paint bucket that will let you basically add a fill to the object.
You can also change the Line Color to a different line color, which makes sense if you've gone through and changed the fill to basically No fill, then you can create an outline.
Now once you have the shape, you'll notice that there is the green rotation handle, that green rotation handle basically allows you to take the shape and rotate it in any direction, all around.
So if you need to create a different shape than the one that's on the AutoShapes drop-down, you're good to go.
Using AutoShapes is a great way to add visual interest to your spreadsheet.
Thanks for stopping by, we'll see you tomorrow for another netcast from MrExcel!
In yesterday's netcast we talked about how to use the Oval tool to highlight data on your spreadsheet.
Now, we're not just limited to ovals or squares that are here in the toolbar, on the AutoShapes drop-down there are dozens and dozens of different AutoShapes.
You can go to the Basic Shapes and choose anything, you know, even squares, rectangles, even the lightning bolt, just click and drag in your spreadsheet to create the shape.
Now once you have the shape there, there's a couple of options on the Drawing toolbar.
The first one is the paint bucket that will let you basically add a fill to the object.
You can also change the Line Color to a different line color, which makes sense if you've gone through and changed the fill to basically No fill, then you can create an outline.
Now once you have the shape, you'll notice that there is the green rotation handle, that green rotation handle basically allows you to take the shape and rotate it in any direction, all around.
So if you need to create a different shape than the one that's on the AutoShapes drop-down, you're good to go.
Using AutoShapes is a great way to add visual interest to your spreadsheet.
Thanks for stopping by, we'll see you tomorrow for another netcast from MrExcel!
