From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Drawing borders and border grids

Drawing borders and border grids - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Drawing borders and border grids

“

- [Instructor] Excel has a number of different techniques 2 for applying borders, not so well known as the ability 3 to actually draw borders. 4 Let's first of all look at a few standard techniques. 5 In this worksheet right now we see 6 borders on these cells right here. 7 Now, a typical way to apply borders, 8 let's suppose we wanted to do this here. 9 First of all, I could have copied the format over. 10 That would be even simpler. 11 But if we were applying these borders 12 or we wanted to apply the same borders here 13 that we have over here, we could go on the home tab 14 to the drop arrow next to borders, 15 and we could certainly use any 16 of these features if we were interested, like right here, 17 "all borders", that will put borders 18 around every single cell. 19 The outline border, outside borders, 20 maybe that's the one we want. 21 Many times when you apply border features, 22 you can't see the…

Contents