Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Inserting an Excel spreadsheet

From: Word 2007 Essential Training

Video: Inserting an Excel spreadsheet

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.

Inserting an Excel spreadsheet

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.

Show transcript

This video is part of

Image for Word 2007 Essential Training
Word 2007 Essential Training

85 video lessons · 46199 viewers

David Rivers
Author

 
Expand all | Collapse all
  1. 40s
    1. Welcome
      40s
  2. 28m 24s
    1. Getting started with Word
      1m 21s
    2. Understanding the interface
      9m 23s
    3. Navigating the interface
      11m 24s
    4. Navigating documents
      6m 16s
  3. 18m 39s
    1. Creating new documents
      5m 25s
    2. Importing documents
      4m 35s
    3. Saving documents
      5m 41s
    4. Sending documents
      2m 58s
  4. 12m 35s
    1. Using Print Preview
      2m 45s
    2. Using Quick Print
      2m 31s
    3. Setting print options and printing
      7m 19s
  5. 23m 29s
    1. Selecting text
      3m 45s
    2. Formatting text
      5m 2s
    3. Using Find and Replace
      3m 35s
    4. Undo, Redo, and Repeat
      3m 26s
    5. Copying, pasting, and moving text
      4m 37s
    6. Showing formatting
      3m 4s
  6. 20m 30s
    1. Using indents
      3m 52s
    2. Setting justification
      3m 19s
    3. Changing line spacing
      4m 11s
    4. Setting tabs
      6m 10s
    5. Using the Highlighter
      2m 58s
  7. 38m 26s
    1. Changing margins
      5m 54s
    2. Changing orientation
      2m 29s
    3. Page numbering
      5m 41s
    4. Choosing paper size and source
      3m 59s
    5. Headers and footers
      7m 23s
    6. Applying a Page Background
      7m 56s
    7. Using Watermarks
      5m 4s
  8. 20m 10s
    1. Checking spelling and grammar
      4m 54s
    2. Finding synonyms
      3m 37s
    3. Looking up words and translations
      4m 55s
    4. Setting document proofing options
      6m 44s
  9. 23m 19s
    1. Modifying Environment settings
      7m 46s
    2. Modifying Display and Document settings
      6m 47s
    3. Modifying toolbars and keyboards
      8m 46s
  10. 15m 7s
    1. Creating a bulleted list
      7m 27s
    2. Creating a numbered list
      3m 36s
    3. Editing a list
      4m 4s
  11. 55m 28s
    1. Creating tables from scratch
      5m 29s
    2. Creating tables from text
      3m 25s
    3. Inserting an Excel spreadsheet
      5m 3s
    4. Modifying tables
      7m 44s
    5. Formatting tables
      7m 32s
    6. Making calculations in a table
      4m 13s
    7. Creating charts
      5m 44s
    8. Modifying chart data
      2m 8s
    9. Modifying chart appearance
      12m 29s
    10. Creating text from a table
      1m 41s
  12. 10m 18s
    1. Using Styles
      3m 3s
    2. Creating Styles
      3m 38s
    3. Editing and deleting Styles
      3m 37s
  13. 9m 21s
    1. Creating and using Building Blocks
      4m 27s
    2. Editing and organizing Building Blocks
      4m 54s
  14. 26m 23s
    1. Creating a Mail Merge
      13m 27s
    2. Creating a Data Source
      5m 21s
    3. Merging to create envelopes and labels
      7m 35s
  15. 8m 58s
    1. Sorting text
      4m 15s
    2. Sorting numbers
      2m 11s
    3. Sorting in tables
      2m 32s
  16. 10m 36s
    1. Creating Macros
      5m 40s
    2. Playing a Macro
      1m 46s
    3. Editing a Macro
      3m 10s
  17. 10m 13s
    1. Working with Newspaper Columns
      5m 31s
    2. Working with Parallel Columns
      4m 42s
  18. 24m 13s
    1. Working with Pictures and Clip Art
      10m 23s
    2. Working with Shapes
      5m 10s
    3. Working with SmartArt
      8m 40s
  19. 40m 40s
    1. Tracking changes
      7m 40s
    2. Reviewing changes
      3m 42s
    3. Sending and faxing documents
      3m 39s
    4. Password-protecting documents
      3m 4s
    5. Linking and embedding
      10m 7s
    6. Inspecting a document
      2m 43s
    7. Encrypting a document
      2m 45s
    8. Adding a digital signature
      7m 0s
  20. 30m 12s
    1. Creating cross-references
      3m 41s
    2. Creating a table of contents
      4m 8s
    3. Creating an index
      4m 43s
    4. Creating footnotes and endnotes
      7m 17s
    5. Using hyperlinks
      4m 24s
    6. Using bookmarks
      3m 26s
    7. Using a document map or thumbnails
      2m 33s
  21. 29s
    1. Goodbye
      29s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Word 2007 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

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.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.