From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Contrasting uses of borders and gridlines in displays and printouts

Contrasting uses of borders and gridlines in displays and printouts - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Contrasting uses of borders and gridlines in displays and printouts

“

- [Narrator] We're looking at a worksheet that has a number of different border effects. Undoubtedly, in a real life scenario, this would not be appropriate, but we're displaying a capability in Excel, primarily gotten to by way of the home tab. In the font group, there's a drop arrow here, and all different kinds of border selections, some of which you can make from the immediate dropdown menu and some of which you can make by going all the way to the bottom and choosing more borders. And that leads us into a dialogue box with tons of choices. We'll come back and take a look at some of those. You can also, if you're in a hurry, want a simple thin border, apply a border, and we see a border around these cells here, simply enter with the keystroke shortcut control shift seven. Select the data first. I'll do it right here. Control shift seven. When you apply borders, often you don't know whether that's worked or not until you click somewhere else. Click outside of it. Yes, it worked…

Contents