Join Dennis Taylor for an in-depth discussion in this video Drawing borders and border grids, part of Excel Tips Weekly.
- View Offline
- 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.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.