The Border Drawing Tools are back in Excel 2010! Use the border drawing tools to quickly add borders to a cell or range of cells. Learn how to find and use them in Episode #1246, with "MrExcel"
"Excel 2010 In Depth", by Bill Jelen
"Excel 2010 In Depth", by Bill Jelen
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, that 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 all 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 a 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 a border and draw a border grid.
When we draw a order, we can draw single border just by clicking the border.
So, if I wanted to draw in 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, I choose blue.
And...
I do draw a border grid.
Now, draw border grid is a great way.
So, 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 border drop down, but I hardly ever find what I want.
Here, I find that most of time.
I'm heading out to more borders, where I can...
You 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...
Hey! I want to thank you for stopping by.
Will see you next time with another netcast, from MrExcel.
Excel in Depth, chapter 30.
Draw Borders.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Well, that 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 all 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 a 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 a border and draw a border grid.
When we draw a order, we can draw single border just by clicking the border.
So, if I wanted to draw in 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, I choose blue.
And...
I do draw a border grid.
Now, draw border grid is a great way.
So, 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 border drop down, but I hardly ever find what I want.
Here, I find that most of time.
I'm heading out to more borders, where I can...
You 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...
Hey! I want to thank you for stopping by.
Will see you next time with another netcast, from MrExcel.
