Home | Products | PowerPoint | PowerPoint Tutorials | Tables

Use Excel Content as Tables in PowerPoint 2011 for Mac

Learn how to use content from your Excel sheet as tables in PowerPoint 2011 for Mac.


Author:

Product/Version: Microsoft PowerPoint 2011
OS: Mac OS X







It's easy to insert a new table on your PowerPoint slide and then enter content within this table as required. However, as it happens in most offices or other work places, 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 use it in PowerPoint as a table. Follow these steps to learn more:

  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 as you can see below the table.

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

    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 + C keyboard shortcut. Alternatively, right-click (or Ctrl+Click) -- 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 more keyboard shortcuts for PowerPoint 2011? Refer to our Keyboard Shortcuts: PowerPoint 2011 for Mac page.


  3. Open your PowerPoint presentation and navigate to the required slide. Then press +V keyboard shortcut. Alternatively, right-click (or Ctrl+Click) -- from the contextual menu that appears, select the Paste option as shown in Figure 3.

    Excel table (or content) being pasted into PowerPoint slide
    Figure 3: Excel table (or content) being pasted into PowerPoint slide

  4. This will paste the Excel content into the PowerPoint slide as a native PowerPoint table, as shown in Figure 4. Notice that the Table Layout tab (highlighted in red within Figure 4) appears on the Ribbon to indicate that the content has been pasted as a native PowerPoint table.

    Excel content pasted as a native PowerPoint table
    Figure 4: Excel content pasted as a native PowerPoint table

    Note: Since we copied plain content within Excel, the pasted table in PowerPoint is also showing plain content. If you copy a formatted table within Excel, the pasted table in PowerPoint will show the same formatting as visible within the original Excel table.


  5. Hereafter, you can edit the table attributes and content in PowerPoint. You can also change the style of your new table. Figure 5 shows our PowerPoint table after we resized it larger, and applied a new style.

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

  6. Save your presentation.

See Also: Import Tables in PowerPoint 2013 for Windows

 

Office 2008 for Mac All-in-One For Dummies Office 2011 for Mac All-in-One For Dummies

If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon.

This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.

Check the book on Amazon.com...




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