Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

Borders can provide a very good way of focusing attention on to the key points of a worksheet and can also help to segregate data and data types. In this video tutorial, you are going to learn more about how to apply borders and some of the border patterns that you can choose from. Learn also how to apply borders when using a touch screen. All these and more in this video.

Get over 70 hours of Microsoft Office 2013 training here course here: http://bit.ly/office-2013-training

Stay in touch:
StreamSKill.com: http://streamskill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Welcome back to our course on Excel 2013. In this section, we’re going to finish off our review of the basics of formatting a worksheet and we’re going to concentrate on Borders in this section. But before we do, there’s just one other little thing I want to cover on Styles. In the previous section, we applied a style to a couple of the heading and a couple of columns on this worksheet and we also applied some direct formatting to the Cost and Recharge columns.

If you want to remove a cell style, it’s pretty straightforward. Let’s take this particular one. We applied a cell style to the category cells here. If I go into the Cell Styles Command in the Styles Group on the Home tab, if at any stage you want to remove the style from a cell, all you have to do is select Normal. And when you select Normal, then the Style selection you previously applied is removed and the cell style, the default cell style is Normal. Pretty much the same as it is in a program like Word. So every cell by default has a format of Normal and you’re applying other than normal styles to achieve the sort of affects that we’ve looked at so far.

The main formatting option I want to look at in this section is the use of borders and borders can provide a very good way of focusing attention on to the key points of a worksheet and also can help to segregate data and data types. If we take this particular expenses sheet that we’ve got here, if I were to select all of the cells that actually have data in them, so I’m going to start at A1, mouse down and drag down to F8. So I’ve got everything selected. I can apply a border very simply. If you look on the Home tab in the Font Group there is here a Bottom Border button or what appears to be a Bottom Border button. But if I click on the drop down, I’ll see that I actually have a whole range of border options. Now the reason that it says Bottom Border there on the button is that when you select one of the border options the one you select becomes the one on that button. It gives you a one click access to one of these many options.

Now let’s look at some of the options. If I’ve got a group of cells selected which at the moment I have and I were to just click, for example, Bottom Border. Let me do that and click away. What you should be able to make out is that there is now a border but only at the bottom of the group of cells that I had selected. Let me select again. Now this time what I’m going to do is I’m going to select All Borders. Now watch what happens this time. Now again I’ll click away and you’ll now see that I have a full set of borders everywhere and this also emphasizes, of course, the merged cell in the first row. So that’s basically how borders work and it shows you how straightforward it is to put borders on a selection.

Now sometimes you may want something other than the default bordering that occurs with Excel 2013 and you can actually change a lot of aspects of the bordering. For example, let’s suppose that I wanted to really emphasize the Cost column here. If I select that column with its heading of Cost and go back into the drop down next to the Borders button note the Borders button is now All Borders because that’s the last Command I executed. Click on there and this time say Thick Box Border, click away. You notice that the outer box border on those selected cells is now thicker than the others.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.