Excel in Depth 30 - Border Drawing
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 30 - Draw Borders!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, the Draw Borders tools are back in Excel 2010, they're here in this drop-down on the Home tab.
Although I move the drop-down up to the Quick Access Toolbar, so we’ll fit in our screen.
What I'm really interested in here are these five new tools, they are not new, they were here in Excel 2003, then they went away.
So we can choose a Line Style, and also a Line Color.
Now choosing either one of these automatically puts me in Draw Border mode, you can see that the dots are appearing, and I have the pencil now.
We want to check, there's two different modes, Draw Border, and Draw Border Grid.
When we're in Draw Border, we can draw single borders just by clicking the border.
So if I wanted to draw in a few borders, I could do that.
If I would draw a range, I'm going to draw a box around the entire range that I select.
I can also come in here, let's change to a different Line Color, choose blue, do Draw Border Grid.
Now Draw Border Grid is a great way to say “Hey, I want the grid to appear from here to here”, so it fills in the grid the whole time.
Now there's lots of different settings in the Borders drop-down, but I hardly ever find what I want here.
I find that most of the time I'm heading out to More Borders, where I can, you know, actually achieve all the things we have been able to do in the dialog box.
However, with these new tools, pretty clever that you can use either Erase, Draw Grid, or Draw Borders, and probably get away with what you want to do without ever going out to the Format Cells dialog box.
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel In Depth chapter 30 - Draw Borders!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, the Draw Borders tools are back in Excel 2010, they're here in this drop-down on the Home tab.
Although I move the drop-down up to the Quick Access Toolbar, so we’ll fit in our screen.
What I'm really interested in here are these five new tools, they are not new, they were here in Excel 2003, then they went away.
So we can choose a Line Style, and also a Line Color.
Now choosing either one of these automatically puts me in Draw Border mode, you can see that the dots are appearing, and I have the pencil now.
We want to check, there's two different modes, Draw Border, and Draw Border Grid.
When we're in Draw Border, we can draw single borders just by clicking the border.
So if I wanted to draw in a few borders, I could do that.
If I would draw a range, I'm going to draw a box around the entire range that I select.
I can also come in here, let's change to a different Line Color, choose blue, do Draw Border Grid.
Now Draw Border Grid is a great way to say “Hey, I want the grid to appear from here to here”, so it fills in the grid the whole time.
Now there's lots of different settings in the Borders drop-down, but I hardly ever find what I want here.
I find that most of the time I'm heading out to More Borders, where I can, you know, actually achieve all the things we have been able to do in the dialog box.
However, with these new tools, pretty clever that you can use either Erase, Draw Grid, or Draw Borders, and probably get away with what you want to do without ever going out to the Format Cells dialog box.
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
