Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
This worksheet has numbers formatted the way we want. We have dollars, we have percents, we have dates formatted. We're going to apply fonts, background, colors, and borders. But before we do, let's take a look at something. Let's go into the lower right corner of the Excel screen and you see we have these three view buttons. The one that's turned on by default is Normal view. But click the middle one here and this goes to Page Layout view and we can see the actual sheet of paper-- and scroll down, scroll back up. The actual sheet of paper as it will look when printed.
Maybe you want to zoom out a little bit. You can click this minus button here or if you want you can hold the Ctrl key down and roll the wheel on the mouse. If you like formatting in Page Layout view or if you like formatting in Normal view, it works the same either way. So let's begin formatting the document. We have the title Travel Expenses. Let's make this look like a title. Let's select across the first row until we get to Column F, because we have six columns in use and let's give it a background to start and up here and we're in the Home tab and in the Fonts section click the Background Color button and you see there's a little down arrow there.
Click the down arrow and we have colors to choose from. Let's just pick a color from here and notice as I roll the mouse pointer over, it's changing colors so that I can see dynamically what color it is before I pick it. And I'll choose this dark green over here. Black text on the dark green background is kind of hard to see. So over here we have a Font Color button, click that down arrow and also you notice as I roll the mouse pointer over these colors, the title is changing. I still want to make it stand out a little bit, so I'm going to make it bold.
And you can see over here in the Font group we have Bold, Italic, Underlined. And I'll click Bold and also keyboard shortcuts for those, Ctrl+B, Ctrl+I, Ctrl+U and with the toggle I can click the B to turn it off, B to turn it on. Ctrl+B turns it on and off as well. Let's look at the months. So let's drag across the months and our Totals column and let's go back up here to the Fill Color. This time instead of choosing a color that's out of here, go down here where it says More Colors and now you have this color hexagon and I'll choose this green over here and down in the lower right it shows what's the current color, which is white.
Of course, there's nothing applied yet and then shows what the new color is going to be. Then click OK. Now we have the color. Now let's apply a font color. We go up here to the Font Color button and I think I'll choose white as well and maybe also I'll make it bold. I'll press Ctrl+B this time to make them bold. Now down over here we have Totals. So let's selects our Totals. Let's go back to the color chooser and maybe for this I'll chose a shade of gray. Now for the column headers, we want to put some borders in there.
We also want to put a border on the top. So let's choose the top. Now we have it formatted, but we want this Travel Expenses to be centered. We want to turn this, instead of six individual cells, we want one big cell. So once you have the six cells selected, go up here into the Alignment section and click Merge & Center, so it's now one big cell. Now for borders in the Font area you see we have border chooser and click this down arrow and we have a bunch of options. Let's choose a Thick Box Border.
It might be a little hard to see, so you can click off it and now you can see it has a thick black border. Well, maybe I want it to be black. Maybe I want a different color. Click it, go back to the down arrow on the Borders button, and then down at the very bottom choose More Borders. Now we have dialog box that we can format with. This dialog box could be a little confusing and what we do here first let's choose None, so we turn it off. Choose a color, maybe I'll choose dark blue, I'll choose a thick border and then over here I'll click Outline and now you could see it gives a thick outline.
If you ever wanted to turn off part of this, you can click to turn part of the border off. Click to turn that part of the border on. Click OK and again you might need to deselect it. Now you can see it has a thick dark blue border around it. Let's select the column headers, go back to Borders and choose All Borders, click to deselect. This puts borders around all cells instead of one big cell, because they're not merged. So now we have the beginning of a formatted worksheet, but you might want to change the column widths, you might want to change the row heights and there's other formatting that you can apply as well, but this is a good first step to formatting.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90743 Viewers
80 Video lessons · 137991 Viewers
59 Video lessons · 56782 Viewers
52 Video lessons · 70400 Viewers
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.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.