MrExcel's Learn Excel #366 - Arrows

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Nov 4, 2009.
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!
maxresdefault.jpg


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!
 

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top