Excel in Depth 30 - Border Drawing

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 Jul 14, 2010.
Excel in Depth 30 - Border Drawing
maxresdefault.jpg


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!
 

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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