Borders can be used to accent a cell to draw attention to it. We mustn't confuse borders with grid lines. Grid lines, which can be seen on the screen at the moment, are just there to help our eye find certain cells, but they won't be printed. If you go up to the view ribbon and within that uncheck grid lines, we can get rid of those lines. This does make it a little bit easier when applying borders to tell which cells have actually got borders around them. Now, let's go back to the home ribbon and apply some borders.

Your borders are within the font category, and if you click on the dropdown, there are lots of predefined borders available to you. For instance, we could click on outside borders and cell B5 Now has a border around it. If I decide that's wrong, I don't want a border, I go back up to the dropdown, scroll down and select no border.

If I select, say, six cells, and I want just an outside border, I click on the dropdown and select outside borders.

If I want an outside borders as well as the borders within, I click on all borders.

If I find that my predefines aren't giving me enough options, I can click on the dropdown and go all the way to the bottom and click on more borders.

This opens up a dialogue box with lots of options. We can choose our line style. We can decide where we want that applied, so outside, inside, or none, we can choose a color and we see a preview. On the right hand side.

Let's say I want to have a thick line for the outside. So under style, I select the thick line style, and under presets I click on outline and we can see in the preview that has been applied. I now want a dash line inside. So under style, I select the dash line that I want, and under presets, I click on inside.

It may be the case that I don't want one of these lines to appear, so what I can do is I can uncheck It. Let's say maybe the right hand line. If I click on that, once the thick line disappears, if I click on that again, the dash line disappears as well. If I now realize that I do actually want the outside line again, I can go click on the thick line, underline style, click on outline, and that's now back to the way we had it before. Great. Let's click okay, and we can see that has now been applied to those six cells that I selected. Next up, I want to fill the cells with a color, so I click and drag to select the cells, go up to the home ribbon, and next to the full color, I click on the dropdown, and then I can select a predefined color of my choice, let's say yellow.

Alternatively, if I want more options, I can click on the dropdown, scroll down and select more colors.

Here we have some standard colors available, but if I want a very specific color, I can click on custom.

Using the arrow on the right hand side, I can go up and down to change the color. This uses a color model called red, green blue, which uses different degrees of those three colors. If you know the exact code you want for your color, this is where you can input it. We'll cancel that out, and we are now back to the yellow. We had at the beginning.