Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
This worksheet is partially formatted and you can see we have our header formatted, we have our column headers formatted, and we have our Total in addition to the numbers. But there's some additional formatting that we need to do. We want to talk about column widths and row height, maybe text alignment. Let's start at the top. Now Row 1, our report header, should be maybe a little taller. When your mouse becomes two-headed arrow here, it has to be on the border between the Row 1 and Row 2 header and click and drag down to make the header a little taller. Click the header so it's selected and it looks great, but it's down on the bottom.
We want this to be vertically centered. So make sure you're on the Home tab and in the Alignment section these three buttons deal with Vertical Alignment. Click the middle one and now it's aligned to the middle. Now we have some room. We could make it a little bigger. Choose a bigger font, if you want. Maybe you choose a different file altogether if you like and keep in mind the fonts on this computer may be different from the fonts that are in your computer. Now that looks a lot more like a report header. Let's deal with the column headers for the months and the Total. Drag across these cells and again on Home tab in the Alignment section, you can click this button over here and that will align them to the center.
Well, this Column F is a little too narrow. So if you put your mouse pointer here on the border between the Column F and the Column G header, when your mouse pointer becomes that two-headed arrow, you could drag to make it wider, but you might have to guess how wide that's supposed to be. I'll just press Ctrl+Z to undo. When you get that two-headed arrow mouse pointer, double-click the mouse and now that will automatically adjust that column so it's as wide as the widest item in that column, which happens to be the Percent of Total header.
Now the columns here B, C, D, and E are all a little different. Maybe you want to make them the same. Put your mouse pointer here on the header for Column B and just drag across to Column E. We want to leave Column E alone. When you put your mouse pointer here on the border between any two column headers, you could drag one way or the other. Now these columns are all the same width, but we want to make sure that we don't have any data cut off. When you scroll down here, you can see this date is cut off. That's what those pound signs mean. It's not an error. It just means there's not enough room to display that data.
Well, we can select a few cells here and then in the Alignment section click Merge & Center and then click that Left Align button. So we don't have to worry about that too much and let's just scroll up. Let me just show you another way that you can choose column width. Let's select these column headers. Just drag across. One way is right-click and you can choose column width and type in a number, cancel out, or again in the Home tab go over here to the Cells section, click Format, and here we can choose Row Height or we can choose Column Width and it's the same dialog box.
So whichever way you want to get it is fine. Well, let's take a look at the names of the cities here. And I'll scroll down a little bit. Let's say that we didn't just go to San Francisco, we went to San Francisco and Silicon Valley and we went to Los Angeles and Orange County and we want to specify that in those cells. We want to add the text here. Put your mouse pointer after San Francisco and double-click to insert the cursor. Now what happens if we simply type, when we say San Francisco and Silicon Valley and press Enter? Well, it's cut off, because there's no room for that.
So again I'll just press Ctrl+Z to undo. Again, click over here after San Francisco and we want to press Alt+Enter. That is hold down the Alt key and press Enter. That's how you can force a line break in a cell. Now we can type 'and Silicon Valley,' press Enter and that also applies a text wrap. So, this Column A is still a little too narrow, so let's make that column just a little bit wider so it fits. Great. It fits horizontally, but we have little bit of extra space on the top.
So put your mouse pointer here on the border between the Row 6 and Row 7 header, when your mouse pointer becomes a two-headed arrow, double-click and now Excel automatically adjusts that row height. Let's try this again for LA. Double-click after Los Angeles, space, and then we'll press Alt+Enter and we'll type Orange County, press Enter, and there we go. So now we've forced a text wrap in that cell. Now I just want to show you one other place where you can put in text wrapping and you have a few other alignment options, but let's select both of these cells.
If you go up here back in the home tab in the Alignment section, click this little button here and this brings you into the Alignment tab of the Format Cells dialog box. Now you could see Wrap text is turned on and we can see what the horizontal and vertical alignment is and we can see that the cells are not merged and over here we can see that the text is going straight across and not on an angle. So you might like to use the dialog box instead of the Ribbon. It really depends on which way you like it. I'll just cancel out. Now we have a worksheet that has a much better look to it.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90743 Viewers
80 Video lessons · 137992 Viewers
59 Video lessons · 56783 Viewers
52 Video lessons · 70403 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.