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

Pasting a table from Excel

From: PowerPoint for Mac 2011 Essential Training

Video: Pasting a table from Excel

On occasion, you may find that when you want to add content to a table on a slide in a presentation, that content already exists somewhere else, such as a spreadsheet in Microsoft Excel, for example. Well, in those cases, you can actually go into Excel and copy that info over to your slide in PowerPoint, and there are number of different formats to choose from. So let's check it out, using our TwoTreesTale presentation. You should be on slide 13, because we are going to insert a new slide to display our sales results. To do that, we'll go up to the New Slide dropdown button, and all we really need is a title.

Pasting a table from Excel

On occasion, you may find that when you want to add content to a table on a slide in a presentation, that content already exists somewhere else, such as a spreadsheet in Microsoft Excel, for example. Well, in those cases, you can actually go into Excel and copy that info over to your slide in PowerPoint, and there are number of different formats to choose from. So let's check it out, using our TwoTreesTale presentation. You should be on slide 13, because we are going to insert a new slide to display our sales results. To do that, we'll go up to the New Slide dropdown button, and all we really need is a title.

We'll take the Title, and then down below we'll have an empty space for the content we are about to copy. So we'll choose Title Only, and where it says Click to add title, we'll just click there, and type in 'Sales Results,' And now we can just click on the slide, anywhere on the slide, to deselect that textbox. We are ready to copy the content over. So we'll go over to Microsoft Excel. If you have got the exercise files, we are going to work with our Quarterly Sales Results spreadsheet here. And the first step is to select the content we want to bring over to our slide; in this case, it's all of the content we see on the sheet.

So I'll just click and drag across and down, from cell A1 to F5. We have now got our range. It's highlighted. We just need to copy it. So we'll go up to the Edit menu and select Copy, or Command+C on your keyboard. Now it's time to go back to PowerPoint, and we are at our slide. We are ready to paste. When we go up to the Edit menu, you may already know the keyboard shortcut is Command+V. That's going to paste our content in the default format, which is a Microsoft Excel Object, meaning you'll be able to edit that content in Microsoft Excel.

If you want to see a list of the other formats, select Paste Special. So there is the default right at the top, Microsoft Excel Worksheet Object, meaning you'll be able to double- click the object and use Excel to make changes to the content. Sometimes though, you don't want to be able to change to the content; maybe it's better to paste it as a picture. So an image has taken of that content, and then the end result is you are working with the picture on your slide, as opposed to the actual data. The same thing goes for a Portable Document Format, or PDF.

You could also choose just to bring it in as text, Rich Text Format, or Unformatted Text. So if you choose Formatted Text, any formatting applied in Excel will also be applied to it here in PowerPoint; Unformatted Text, you'll get just plain old text, and you can do the formatting yourself. So let's try the default, which is Microsoft Excel Worksheet Object, and click OK. So there it is. It kind of looks like a table in PowerPoint, but really it's an object. It's an Excel object. We can go to the corners and stretch it out if we want to make it a little bit bigger.

We can manipulate it that way. But if you click inside, you'll notice you don't actually click in the cells, and you can't make changes to the borders, and so on. If you want it wider or more narrow columns, you can't do any of that. If you want to make changes to this content, you have to double-click, and that's going to flip you back to Microsoft Excel, where you have access to the content. Any changes you make here will be shown on your slide in PowerPoint. Let's flip back over to PowerPoint without making any changes, and take a look at the end result here.

Maybe we should just drag that down towards the center of our slide and deselect to see the end result. It looks pretty good. So you have got all of the content from Excel into our PowerPoint presentation, and the format we use allows us to go into Excel and make changes to that content if we need to. Let's select it one more time. You'll notice what happens up here next to the Home tab: a Format tab appears. We can click that, if we want to spice it up a little bit now. Notice, for example, we have Shape Styles. Now these are all dimmed out, so we can't make changes to the style, because it's not really a shape, but we can make changes to the fill and Line style.

Let's go to the Line dropdown, and if we want to choose a nice dark green, for example, and then go back to the Line dropdown and go down to Weights, and make a little bit thicker, like 41/2 points, now deselect to see the end result: you've got that nice border around the outside. So that's one of the formatting changes we can make to this object. Click it again to select it, and click Format if you have to, to see the formatting options. There is also Effects that appear to be available, until we click the button.

Notice that these are effects that might be applied to shapes, for example, or pictures. They are not available here when working with an Excel object. So that's one of the drawbacks to choosing the Excel Object Format. If we were to choose Picture, you'd be able to make changes to the shape styles, the effects and so on. The same thing goes for fills and lines, if they are using text effects in there. So we'll just deselect by clicking anywhere off to the edge of the slide, and there is our end result. So keep in mind, if you don't want to have to create a table from scratch and retype all of this data into that table, go into Excel, if it's already there, copy it, paste it; you'll save yourself a lot of time.

Show transcript

This video is part of

Image for PowerPoint for Mac 2011 Essential Training
PowerPoint for Mac 2011 Essential Training

63 video lessons · 21432 viewers

David Rivers
Author

 
Expand all | Collapse all
  1. 4m 11s
    1. Welcome
      1m 20s
    2. Understanding PowerPoint
      2m 4s
    3. Using the exercise files
      47s
  2. 15m 58s
    1. Exploring the Presentation gallery
      4m 17s
    2. Understanding the Ribbon interface
      6m 7s
    3. Navigating presentations
      2m 56s
    4. Customizing the UI layout
      2m 38s
  3. 32m 42s
    1. Creating new presentations
      2m 56s
    2. Adding, removing, and arranging slides
      7m 5s
    3. Saving time with Outline mode
      5m 15s
    4. Separating slides into sections
      8m 37s
    5. Checking compatibility
      3m 15s
    6. Saving your presentations
      5m 34s
  4. 35m 23s
    1. Using themes
      4m 58s
    2. Creating your own themes
      2m 42s
    3. Changing the background
      5m 33s
    4. Designing slides
      3m 12s
    5. Working with slide layouts
      3m 58s
    6. Working with slide masters
      5m 51s
    7. Using headers and footers
      4m 25s
    8. Using and creating templates
      4m 44s
  5. 30m 14s
    1. Adding text with text slides and boxes
      3m 37s
    2. Adding text to a shape
      2m 16s
    3. Formatting text on a slide
      5m 42s
    4. Changing character direction
      4m 11s
    5. Creating lists using bullets and numbering
      5m 25s
    6. Changing spacing and indents
      4m 17s
    7. Finding and replacing content
      4m 46s
  6. 25m 28s
    1. Adding a table to a slide
      4m 47s
    2. Editing and formatting tables
      4m 25s
    3. Pasting a table from Excel
      5m 11s
    4. Inserting a chart
      5m 42s
    5. Pasting a chart from Excel
      5m 23s
  7. 26m 40s
    1. Inserting pictures and clip art
      2m 18s
    2. Replacing and adjusting pictures
      6m 40s
    3. Drawings and SmartArt
      6m 29s
    4. Adding video to a slide
      5m 53s
    5. Adding sound to a presentation
      5m 20s
  8. 18m 7s
    1. Using a template with animation
      5m 35s
    2. Animating objects on a slide
      6m 1s
    3. Using slide transition effects
      6m 31s
  9. 15m 7s
    1. Checking spelling
      5m 25s
    2. Finding synonyms, definitions, and translations
      4m 23s
    3. Setting AutoCorrect options
      5m 19s
  10. 40m 53s
    1. Using speaker notes
      3m 50s
    2. Showing and navigating a presentation
      4m 56s
    3. Using pointer options
      3m 59s
    4. Using presenter tools with two screens
      3m 44s
    5. Creating a self-running slideshow
      6m 40s
    6. Playing a self-running slideshow
      3m 44s
    7. Adding hyperlinks to a presentation
      5m 7s
    8. Using action buttons
      8m 53s
  11. 28m 5s
    1. Using comments
      3m 58s
    2. Printing notes, handouts, and slides
      4m 17s
    3. Sending a slideshow to iPhoto
      2m 57s
    4. Creating PowerPoint pictures
      2m 43s
    5. Creating a PowerPoint movie
      3m 56s
    6. Creating a PDF presentation
      1m 49s
    7. Creating custom slideshows
      3m 57s
    8. Broadcasting a presentation over the web
      4m 28s
  12. 8m 52s
    1. Changing PowerPoint preferences
      3m 29s
    2. Customizing the Ribbon and toolbars
      5m 23s
  13. 22s
    1. Goodbye
      22s

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 PowerPoint for Mac 2011 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 preferencesfrom 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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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.