Home | Products | PowerPoint | PowerPoint Tutorials | Tables

Import Tables in PowerPoint 2013 for Windows

Learn how to import tables that are created in Excel or Word into PowerPoint 2013 for Windows.


Author:

Product/Version: Microsoft PowerPoint 2013
OS: Windows 7 and 8







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 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.

    An Excel Table, or simple content, both are usable
    Figure 1: An Excel Table, or simple content, both are usable

    Note: 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!


  2. 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.

    Copy the required Excel content
    Figure 2: Copy the required Excel content

    Tip: Want keyboard shortcuts for PowerPoint 2013? Refer to our Keyboard Shortcuts: PowerPoint 2013 for Windows page.


  3. 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).

    Paste Options for the copied Excel content
    Figure 3: Paste Options for the copied Excel content

    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.

      Use Destination Styles (S) option
      Figure 4: Use Destination Styles (S) option

    2. 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.

      Keep Source Formatting (K) option
      Figure 5: Keep Source Formatting (K) option

    3. 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.

      Embed (E) option
      Figure 6: Embed (E) option

    4. 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.

      Picture (U) option
      Figure 7: Picture (U) option

    5. 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.

      Keep Text Only (T) option
      Figure 8: Keep Text Only (T) option

      Tip: Select either Use Destination Styles (S) or Keep Source Formatting (K) option to paste the copied Excel table (or content) into the PowerPoint slide as a native PowerPoint table.


  4. In Figure 9 below, you can see that we have pasted the Excel table using the Use Destination Styles (S) option. Notice that the Table Tools contextual tabs (highlighted in red within Figure 9) appear on the Ribbon, and 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.

    Excel table pasted as a native PowerPoint table
    Figure 9: Excel table pasted as a native PowerPoint table

  5. 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.

    PowerPoint table applied with a new style
    Figure 10: PowerPoint table applied with a new style

  6. 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:

Use Excel Content as Tables in PowerPoint 2011 for Mac
Use Word Table Content within Tables in PowerPoint 2011 for Mac

 

PowerPoint Keyboard Shortcuts PowerPoint Keyboard Shortcuts and Sequences:
PowerPoint 2013, 2011, 2010, 2007 and 2003

Have your ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?

Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences E-Book.

PowerPoint Keyboard Shortcuts and Sequences E-book

 



comments powered by Disqus




Subscribe to Indezine
Follow Indezine

Follow Indezine on Pinterest
Share This Page
Bookmark and Share
Translate Page


Like This Page
Like This Site



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-2016, Geetesh Bajaj. All rights reserved.

since November 02, 2000