Borders and gridlines: Exploring variations, options, and differences

- [Instructor] There are two formatting features in Excel…that sometimes are mistakenly used interchangeably,…one's called borders, one's called gridlines.…Most Excel users, when they work with the data,…have gridlines on the worksheet,…that's the default setting in Excel.…There's a border around this merged cell up top.…That's a little bit different.…On the worksheet to the left here,…there are no gridlines showing at all,…but there are border features in effect…in a number of different locations.…I want to go back to that other worksheet first,…suppose I wanted to print this.…

I'm going to press Control + P,…I'll get a quick print preview here.…Now, as I see this, I could be thinking well,…where are those lines that I saw…as I've been working with the data?…I don't see them here.…I guess I have to add them.…So, press Escape, let's go back into Excel,…and let's add borders.…How can we do that?…Very quickly, within the font group on the Home tab,…there's a drop arrow, and we could apply all borders,…we've got lots of different choices here, too,…