Use the drawing tools to highlight data on your worksheet. Episode 366 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.
Today we’re going to start to talk about the Drawing toolbar, the Drawing toolbar is a really powerful, but usually overlooked, set on Excel.
If we go to View, Toolbars, and turn on the Drawing toolbar, it generally will put the Drawing toolbar at the bottom of the screen.
Again, I've moved mine to the top of the screen in order that we can see it on the podcast, today let's just take a look at the Drawing toolbar.
If I want to draw an arrow on the worksheet, basically, click where we want the arrow to start, and drag until you want the arrow to end and let go, and it draws a really basic, boring arrow.
But we can use all of the buttons on the Drawing toolbar to really kind of improve the arrow.
So, for example, if we needed a green arrow, and we wanted to change the width there, we go to 3 point, or maybe 4 1/2 point.
There's also a setting here if we wanted to create a dashed arrow, we can create a dashed arrow or something like that.
And if those settings aren't enough, you can right-click and choose Format, AutoShape, where we can choose a different arrow style at the beginning or the end, and literally control everything.
The one other setting that we want to do here is, we want to make sure to, say, that we move in size with cells.
That way if you make one of the intervening columns wider, the AutoShape will automatically extend to fit the area.
A great way to kind of jazz up your spreadsheets, call attention to certain cells, to add new items to the drawing layer of the spreadsheet.
The first step for that is to use a View, Toolbars, Drawing, to get the great Drawing toolbar on our screen.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel!
Today we’re going to start to talk about the Drawing toolbar, the Drawing toolbar is a really powerful, but usually overlooked, set on Excel.
If we go to View, Toolbars, and turn on the Drawing toolbar, it generally will put the Drawing toolbar at the bottom of the screen.
Again, I've moved mine to the top of the screen in order that we can see it on the podcast, today let's just take a look at the Drawing toolbar.
If I want to draw an arrow on the worksheet, basically, click where we want the arrow to start, and drag until you want the arrow to end and let go, and it draws a really basic, boring arrow.
But we can use all of the buttons on the Drawing toolbar to really kind of improve the arrow.
So, for example, if we needed a green arrow, and we wanted to change the width there, we go to 3 point, or maybe 4 1/2 point.
There's also a setting here if we wanted to create a dashed arrow, we can create a dashed arrow or something like that.
And if those settings aren't enough, you can right-click and choose Format, AutoShape, where we can choose a different arrow style at the beginning or the end, and literally control everything.
The one other setting that we want to do here is, we want to make sure to, say, that we move in size with cells.
That way if you make one of the intervening columns wider, the AutoShape will automatically extend to fit the area.
A great way to kind of jazz up your spreadsheets, call attention to certain cells, to add new items to the drawing layer of the spreadsheet.
The first step for that is to use a View, Toolbars, Drawing, to get the great Drawing toolbar on our screen.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel!
