Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you use Microsoft Excel, then you know all about spreadsheets. If you'd like to use Excel from within a Word document well, no problem. All you really need to do is insert it where you want it. So let's open up a document that's been started for you. We'll go to the Office button and click Open and we'll navigate to the Lesson 10 folder where you'll find inventory 5 right here. So let's open up that one up, and you see, it's just a title and a subtitle and we're going to click down here because this is where we want our spreadsheet to go.
Keep in mind we're inserting a new blank spreadsheet here. So we do is go up to the Insert tab, and like before we go to Table. But this time we choose Excel spreadsheet, and when we click on that. We don't have just a table showing up here, but it's actually a mini spreadsheet that let's you to do everything you can do in Excel, but without leaving Word. So you can see here inside my border I've got my column headers, A, B, C, D, all the way across, my row numbers, just like I would see in Microsoft Excel.
So let's enter some stuff here. In this first cell that selected under column A, row 1, we call that cell A1, we'll just type in QTY, short for quantity, and hit the Tab key on your keyboard to move over to the right. Type in item, type price in the next one and tab over to column D, where we'll type in the word total. OK, what we're going to do now is just adjust a couple of things, like quantity's fine, but we need more room for typing in items so we'll go in between our columns here, you can see in between A and B, when I click I get the double arrow.
Now I can click and drag and as I move to the right you can see how wide I'm going. OK, maybe a little bit wider, we can adjust this after we get our content inside. All right, let's go under cell A2, right into cell A2, and we'll start typing some stuff. Lets type in a quantity of 3 under item, so I'm tabbing over, "stoneware muffins pan". Good. I'm going to tab over, we'll give that a price.
I'm going to type in 17.99 and we're going to tab over to the total column and here's where we're actually going to enter a formula just like we would an Excel. So I'll type in the equal sign to start a formula- and there's a whole title on Microsoft Excel so we won't get too deep into it here. But we want to multiply the contents of A2 times the contents of C2. So that's what we type A2, the asterix is our multiplication symbol, C2. There we go and when we press Enter, we get the results. So we're going a little math in there.
All right, now you can see that our headings over here and our numbers down below don't really line up very nicely. Numbers automatically line up to the right and you can see text here just lines up to the left of the cell. So we can play around with that kind of stuff as well. Remember is a hold title on Microsoft Excel and doing this kind stuff, so we'll just go onto the next row and continue typing. I'm going to type in one more here, so we'll do 4 under the quantity column, tab over to item. Let's make it short, type in "soup ladle".
Give it a price, 6.99, and now instead of entering that formula again we'll just copy this one down. So click on the formula right above. That little box you see in the bottom right corner when you touch it with your mouse as you hover, you see out turns into a kind of a crosshair or a plus sign? Click and drag straight down to copy a formula. There you go. So you've got the results for that particular row. Now we could continue on entering text, numbers, formulas, but like I said, that's all in an Excel title. So let's wrap this up and when we're done working with our worksheet or spreadsheet here all we have to do is click outside the border.
So we come into our document here, and we click, and there's the end result. Now to edit this later, we'd simply goal inside the actual- it looks like a table but it's a spreadsheet- and double click. Let's do that. You see double-clicking now gets me right back where I left off inside the Excel worksheet and you'll notice that the border going around this entire worksheet has little handles. There's one midway on the right-hand side and you can see when I hover over it, I get it double arrow. Same thing over here, only it's diagonal, straight up and down.
I want to resize this because it's kind of flowing off the right-hand side. I'm going to go to the bottom right- hand corner because this way I can adjust the width and the height simultaneously. I'm in a drag over to the right and I'm going to drag up. When I get to the spot where I think a want to let go, I release. I again click outside of the border to deselect it and there we go. Cool. So now that we know how to create tables and even insert a spreadsheet, it's time to explore how we modify these things after they're created.
In the next lesson we'll look at adding and removing rows and columns and adjusting heights and the widths of our rows and columns in a table.
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.