Using the circle tools on the Drawing toolbar to call attention to a cell. Episode 367 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 podcast we started talking about how to use the tools on the Drawing toolbar.
So again, that was View, Toolbars, Drawing, to turn that on, and normally it appears at the bottom of the screen, but in the podcast I'm going to keep it up here at the top.
The Drawing toolbar is great if you need to draw a square or a circle, to kind of highlight some of your numbers in Excel.
I'm going to click on the Oval tool here, and you kind of have to click in the upper-left hand corner of the circle, which makes no sense at all, I realize, so you kind of click and drag to surround the data.
Now, the problem is, once you put the circle in, it becomes completely opaque, you can't see through it.
You need to right-click and choose Format, AutoShape, and then you can say for the fill we want to have No Fill.
Also while you're here, you can go ahead and make the line a little bit thicker, change the line color from black to something more interesting.
Click OK, and now you've essentially circled a cell.
now you'll notice that I'm drawing an oval.
What if you need to create a perfect circle?
Well we can do that with the Drawing toolbar, if you hold down the Shift key while you draw, Excel will draw a perfect circle out of your oval.
There you have it, using the AutoShape Circle tool in order to highlight certain texts on your spreadsheet.
We'll see you next time for another netcast from MrExcel!
In yesterday's podcast we started talking about how to use the tools on the Drawing toolbar.
So again, that was View, Toolbars, Drawing, to turn that on, and normally it appears at the bottom of the screen, but in the podcast I'm going to keep it up here at the top.
The Drawing toolbar is great if you need to draw a square or a circle, to kind of highlight some of your numbers in Excel.
I'm going to click on the Oval tool here, and you kind of have to click in the upper-left hand corner of the circle, which makes no sense at all, I realize, so you kind of click and drag to surround the data.
Now, the problem is, once you put the circle in, it becomes completely opaque, you can't see through it.
You need to right-click and choose Format, AutoShape, and then you can say for the fill we want to have No Fill.
Also while you're here, you can go ahead and make the line a little bit thicker, change the line color from black to something more interesting.
Click OK, and now you've essentially circled a cell.
now you'll notice that I'm drawing an oval.
What if you need to create a perfect circle?
Well we can do that with the Drawing toolbar, if you hold down the Shift key while you draw, Excel will draw a perfect circle out of your oval.
There you have it, using the AutoShape Circle tool in order to highlight certain texts on your spreadsheet.
We'll see you next time for another netcast from MrExcel!
