Viewers: in countries Watching now:
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
Adding borders to a group of cells is another way to give emphasis to a particular part of a worksheet. In this worksheet here called Borders, highlighting these numbers here maybe is being done because, these are pure values, we want them to stand out a little bit differently than the other numbers. There are two ways to get to this capability. On the Home Tab, we can use the Border button right here. Click the drop arrow, tons of choices. We might just want a "thick box border", and there it is, but a little tricky to see while they're still highlighted.
Many, many times when you're applying border features, you want to click elsewhere and then see the effect of what occurred. Also of help here, particularly if you're using even lighter borders than this, you might want to turn off or inhibit the display of gridlines as you work with the data. Remember, that's independent of working with the data when you're printing it. On the View Tab, you can uncheck the box for Gridlines. That will just allow us to see these a little more clearly. Another possibility here, we can do this, maybe we want to highlight these for one particular reason or another, here too, we could, and this time, by way of right-click, use the mini pop-up toolbar right here.
We've got the same choices here and we'll just use outside Borders. That's tricky to see too, until we click outside of it, but there it is as well. Now, if you're interested in different kinds of borders, sometimes what you might want to do is right-click and go to Format cells or if you're on the Home tab, you can right-click either this button here for Alignment or Number--that doesn't sound exactly relevant, but you can use those--or you press Ctrl+1. Right clicking format cells Ctrl+1 or any of these buttons and I'll press Ctrl+1.
Any of those choices will take you to the Format Cells Dialog Box, and a border isn't selected, click it, and we got some choices here. The case could be that you wanted to use color. Here's a color choice. Maybe we want to use a dark red border or something like that. It could be a thick border, it could be one of these kinds of designs, and while we're here, we could have an Outline Border as well as an Inside Border, and there are even oddities like these here, which I think most of the time we are not interested in. Once again, OK to get that effect.
If that were not enough, there are other techniques here too, and obviously, it would be overkill for me to put borders on this part of the worksheet, but once again, on the Home tab, clicking the drop arrow, there's even a choice here for Drawing a Border or Drawing a Border Grid. Draw Border Grid, we'll just drag across these, like that. May be we don't' like the color, go back up here and pick a Line Color and so on. You could spend a lot of time out here, fine-tuning this to fit your needs. At times, you don't want any borders.
You want to get rid of them possibly or maybe these were sent to you and you don't like them. A quick fix here by way of a keystroke shortcut is to select the data in question, maybe even the whole worksheet, but let's say we get rid of--how about the lower ones here-- We don't want any borders there, it's Ctrl+Shift+Underscore. That will get rid of them. A more logical way would be, highlight the data or possibly by clicking the upper left hand corner, using the entire worksheet. Go to the button right here on the Font Tab and choose No Border, and all borders will be gone. But I think there's no question, that in some worksheets, putting a border around certain groups of cells does give greater emphasis to the data that you've selected.
There are currently no FAQs about Excel 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.