Indezine Logo

  This is the print version of this page. All content is copyright Indezine.com 2000-2020.



Import Excel Content as Tables in PowerPoint 2013 for Windows

Learn importing content from Excel as tables in PowerPoint 2013 for Windows. Many times, this can be easier and quicker than recreating the table in PowerPoint.


Author:

Product/Version: PowerPoint 2013 for Windows

OS: Microsoft Windows 7 and higher






If you want to use a table in your presentation, you can insert a new table on your PowerPoint slide and then enter content within this table as required. However, as it happens frequently, there may be a table already created within Excel or Word, or the table content may already be populated in a bunch of contiguous Excel cells. Whether you have, a ready-made table, or just a group of in contiguous cells in Excel, it is very easy to import it into PowerPoint 2013 for Windows as a table.

Since the Copy and Paste options work similarly for both Excel and Word tables, it really does not matter what your source is, although in this example we are taking a table created within Excel:

  1. Open your Excel sheet that has the required content, as shown in Figure 1. It can be a table as shown towards the top of the Excel sheet shown in Figure 1, or just a group of cells contiguous as you can see below the table.
  2. An Excel Table, or simple content, both are usable
    Figure 1: An Excel Table, or simple content, both are usable
  3. Is Everything in Excel a Table?

  4. Yes, all contiguous Excel cells may look like tables but Excel by itself has a separate definition for a table. While we won't go into what an Excel table is and what it isn't, we just wanted you to be aware that an Excel table has got to do nothing with the resultant PowerPoint table in this tutorial!
  5. Select the set of contiguous cells containing the required content (or the entire table). Then press Crtl + C keyboard shortcut. Alternatively, right-click—and from the contextual menu that appears, select the Copy option as shown in Figure 2.
  6. Copy the required Excel content
    Figure 2: Copy the required Excel content
  7. PowerPoint Keyboard Shortcuts

    PowerPoint Keyboard Shortcuts

    Do you want more keyboard shortcuts?

    Explore our PowerPoint Keyboard Shortcuts and Sequences Ebook that is updated for all PowerPoint versions.

  8. Open your PowerPoint presentation and navigate to the required slide. Then right-click to bring up the five Paste Options as shown in Figure 3 (highlighted in red).
  9. Paste Options for the copied Excel content
    Figure 3: Paste Options for the copied Excel content
  10. Hover your cursor over any of these options and you will see a Live Preview of the table being pasted into the slide. Let us explore these options in the order they are placed, from left to right:
    1. Use Destination Styles (S): Cancels any style and formatting applied to the copied table and pastes it into the active slide as shown in Figure 4. The keystroke S denotes the shortcut for this option.
    2. Use Destination Styles (S) option
      Figure 4: Use Destination Styles (S) option
    3. Keep Source Formatting (K): Retains the style and formatting applied to the copied table and pastes it into the active slide as shown in Figure 5. The keystroke K denotes the shortcut for this option.
    4. Keep Source Formatting (K) option
      Figure 5: Keep Source Formatting (K) option
    5. Embed (E): Embeds the copied table into the active slide as an object, and not as a table, as shown in Figure 6. The keystroke E denotes the shortcut for this option.
    6. Embed (E) option
      Figure 6: Embed (E) option
    7. Picture (U): Inserts the copied table into the active slide as a picture, and not as a table, as shown in Figure 7. The keystroke U denotes the shortcut for this option.
    8. Picture (U) option
      Figure 7: Picture (U) option
    9. Keep Text Only (T): Pastes the content of the copied table into a text-box as plain text, and not as a table, as shown in Figure 8. The keystroke T denotes the shortcut for this option.
    10. Keep Text Only (T) option
      Figure 8: Keep Text Only (T) option
    Tip: Select either the Use Destination Styles (S) or Keep Source Formatting (K) options to paste the copied Excel table (or content) into the PowerPoint slide as a native PowerPoint table.
  11. In Figure 9 below, you can see that we have pasted the Excel table using the Use Destination Styles (S) option. Notice that the two Table Tools contextual tabs (highlighted in red within Figure 9) appear on the Ribbon. Also, the Selection Task Pane displays the name 'Table' (highlighted in blue within Figure 9) to indicate that the copied content has been pasted as a native PowerPoint table.
  12. Excel table pasted as a native PowerPoint table
    Figure 9: Excel table pasted as a native PowerPoint table
  13. Hereafter, you can edit the table attributes and content in PowerPoint. You can also change the style of your new table. Figure 10 shows our PowerPoint table after we resized it larger, and applied a new style.
  14. PowerPoint table applied with a new style
    Figure 10: PowerPoint table applied with a new style
  15. Save your presentation.
Note: If you want to import a table created in a Word document into PowerPoint, select the table in Microsoft Word and follow the same procedure.

See Also:

Import Tables: Import Excel Content as Tables in PowerPoint (Glossary Page)

Import Excel Content as Tables in PowerPoint 2011 for Mac

You May Also Like: Insert Tables in PowerPoint 2013 for Windows | How to Create College Presentations Using These 7 PowerPoint Hacks


Popular Posts

Flowchart Symbols: What They Represent?
Explore various flowchart symbols, and learn about what they represent.

Types of Animation in PowerPoint 2010 for Windows
Learn about different animation types in PowerPoint 2010 for Windows.

Restoring Earlier Versions of Presentations in PowerPoint 2010 for Windows
Learn how to restore earlier versions of your current presentation in PowerPoint 2010.

What is Animation in PowerPoint?
Learn what animations is and how to effectively plan animation for PowerPoint.



Gears for PowerPoint (Series 01)

All these gears are native PowerPoint shapes. You can recolor them, add effects, and do more, all inside PowerPoint. Results which would have taken hours to achieve now take less than a minute! Have fun using the gear graphics, and make your audience take notice! All these gears can be rotated and resized, as required. Since they are essentially pictures, all types of edits that you can do with pictures work with them too!

Get this complete kit now, you’ll save so much time that you can use doing something else!

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Import Excel Content as Tables in PowerPoint 2013 for Windows.


Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2020, Geetesh Bajaj. All rights reserved.