Drawing borders and border grids

- Excel has a number of different techniques…for applying borders.…Not so well known is the ability…to actually draw borders.…Let's first of all look at a few standard techniques.…In this worksheet right now, we see borders…on these cells right here.…Now, a typical way to apply borders,…let's suppose we wanted to do this here.…First of all, I could have copied the format over.…That would be even simpler.…But if we were applying these borders…or we wanted to apply the same borders here…that we have over here,…we could go on the Home tab…to the drop arrow next to Borders.…

And we could certainly use any of these features…if we were interested.…Like right here, All Borders.…That will put borders around every single cell.…The Outline Border, Outside Borders,…maybe that's the one we want.…Many times when you apply border features,…you can't see the effect of it…until you clicked outside of it.…Let me press Control+Z to undo that.…If you would like to use a simple outline border…like that, there is a keystroke shortcut.…