Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
No matter how you've created your tables, adds are pretty good that you're going to need to adjust or modify them at some point. For example, as you begin to enter text, maybe you realize one column is no longer wide enough to accommodate one of your entries. Or maybe you want to make it easier to read by spreading it out a little bit. Let's modify a table that we created earlier. So we'll go to our Open button and give it a click. Now, if you don't have an Open button on your Quick Access toolbar, you have two options. You can go back to the lesson on modifying your Quick Access toolbar or click the Office button and then Open.
Either way make sure you navigate to the Lesson 10 folder, because that's where you're going to find shopping list 5. Give it a click, click the Open button and there you go. All right. This table is created using pretty much the defaults for columns widths and row heights, but we can change that and we can do it in a couple of different ways. First of all, let's just click inside the table. Watch what happens to the ruler when I click anywhere inside this table. A number of markers show up and these are the markers where the columns are, so I can actually change column widths by hovering over these, clicking and dragging.
So let's do that. For example, this first column here is probably wider than it needs to be so I'll go to the marker that's in between column 1 and 2, click and hold my mouse button down and drag over to the left, and do it visually, I'm going to let go right there. Great. Same thing for this column. It looks like it's probably wider than it needs to be under price. So I'm going to go to this marker and I'll push it off to the right. Now notice what happened. I actually only made this one wider and my table got wider on the whole. So there is a marker for the right-hand side as well and I can move that in to make that column a little narrower.
Okay, so that looks pretty good. That's one way to do it. Another way is from right inside the table itself. As you move over a column marker, inside the table you can see your mouse pointer turns to double arrow so you can click and drag that way as well. You don't have to go to the ruler. So I'm going to adjust a just a little bit here and there and you see when I do it from inside the table, it does squish my text together and I need to go to the right-hand border and drag that out a little bit too.
OK. That covers column widths. How about row heights as well? If we go over to the ruler here on the left hand side, you can see there's markers for my different row heights and I can click and drag those to make them taller. Or narrower. And you've got to have the double arrow when you do it. I'll click and drag. So... let's go a little bit of that. We're adjusting, you can see everything we're doing here is manual, and you're going to hope for the best doing it manually, that your rows are going to come out even.
It might be better to, just ensure that they're all can be the same, to change the row heights another way. And here's how we do that. First of all, you want to have the entire table selected. You can click and drag over cells to select the table. But as soon as you click inside a table, you'll notice this little icon shows up in the top left corner. When you hover over it, you get the four-way arrows. Give it a click and your entire table is now selected. So what we can do is actually go up to our Table Tools, click on Layout, and we're going to go to the Cell Size section here.
This group here on the ribbon called Cell Size, and we got two fields here. Well, we've got AutoFit, which is a button, but we've also got a field up here for changing our row height, and we've also got one for our column widths. And we can enter values in here or we can use our little arrows to bump them up. Or down. And you can see as we click the arrow, here we go, our row heights are changing. That's probably too much. The down arrow brings it down and we're going oto go to .4 inches and just leave it there. Now our table's still selected, so we can click inside the table to deselect.
Perfect. Now if we wanted to add another item to the bottom of the list, what would we do? We need a new row. The easiest way to do that is just to click in the last cell here ad hit your Tab key on the keyboard. There we go. So we've got our brand-new row and we're ready to start typing. That's only one way to insert a row or a column and you'll notice that we also have a Rows and Columns group up here on the ribbon and we can insert rows and columns and we can choose where they go, to the left to the right, above or below.
So by going to the last cell and hitting Tab, we automatically tacked one on to the bottom of our table and as you're filling in data that's usually what you are going to do to automatically add new rows on the fly. And let's say we want a new column here at the end that's good to total up our quantities and our prices. So click anywhere in the price column here. We'll go up to the Rows and Columns group and we want to insert a column, but we want to make sure it goes to the right of our price, not to left, so we click this button right here. So we've got our new column, there's nothing in it and you can see, it is selected.
So we can make adjustments to it if we needed to. What we're actually going to do is just type in a label up here at the top, so click in the top cell and type in the word "total". That fits nicely. And down below is where we might want to do some math, for example, where we would take the quantity times the price, just like we did with our spreadsheet in the previous lesson. Now to remove a row or a column is just as easy. Let's say this last row here, we really don't need. Click anywhere in the last row, we're going to go up to our Delete button here and you'll notice it has an arrow pointing down. So when we click on Delete, we have options.
Delete the entire table, not what we want to do. We've got rows and columns and cells as well. We want to get rid of that row. So we click Delete Rows. Gone. Just like that. Now let's talk about splitting and merging cells just to change the look of our table. We need to get that last row back, so I'm going to click in the last cell and just hit my Tab key to get it back. All right. Let's type the word "total" in this cell here. The second last cell. So this is going to be a grand total, what we're looking that here, and we should merge some cells on this last row to avoid any confusion.
So I'm going to click and drag across the entire bottom row here. And now I want to merge these cells together. So again I'm going to have to go up to my ribbon. There is a Merge group right here and I want to merge all those selected cells. So when I click it. I've now got one single cell at the bottom of my table. Well, it's a little bit too far actually, We need an extra cell for the actual number to appear next to total. So now we need to split this one big cell into two.
So make sure that your cursor's flashing in the cell itself and now we are going to go up to Split Cells, we'll give it a click. The number of columns and the number of rows by default is showing up as 2 and 1. So we're going to end up with 2 columns and 1 single row, and that's exactly what we want. But we could do just that if we wanted more columns. But we'll leave it at 2 and 1 row and click OK. You see what happens, it's 2 equal columns so, what I want to do is actually adjust that.
I'm going to move this over to the right so it lines up with my total column. And the word total, well, maybe it should be right aligned. So with it selected, I'm going to change the alignment and there is an Alignment group up here. You can see I've got a number of options, left, center and right alignment, but with the top of the cell, the middle of the cell, and the bottom of the cell. So I'm going to choose top and see what that looks like. How about center, bottom, right down the middle looks good to me.
Perfect. I'll deselect that by clicking anywhere in the table, and I think I've got exactly what I'm looking for. So we're ready now to move on to a formatting and we're going to do that in the next lesson.
Get unlimited access to all courses for just $25/month.Become a member
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.
Your file was successfully uploaded.