{"id":7390,"date":"2017-03-15T12:04:34","date_gmt":"2017-03-15T11:04:34","guid":{"rendered":"http:\/\/blog.presentationload.com\/?p=7390"},"modified":"2023-09-06T12:15:49","modified_gmt":"2023-09-06T10:15:49","slug":"excel-tables-powerpoint-part-1","status":"publish","type":"post","link":"https:\/\/www.presentationload.com\/blog\/excel-tables-powerpoint-part-1\/","title":{"rendered":"Excel in PowerPoint- Part 1"},"content":{"rendered":"

Presenting and discussing data tables during a presentation is par for the course, both for the speaker and attendees alike. In this two-part series, you will learn that tables are relatively simple to design when you consider the following topics:<\/p>\n

1) Creating Tables in PowerPoint<\/p>\n

1.1) Creating a Table on a Slide<\/p>\n

1.2) Transferring Cells from Excel<\/p>\n

1.3) Creating a Table from Slide Layout<\/p>\n

1.4) Importing a Table from Word<\/p>\n

1.5) Working in Excel and Updating a Table in PowerPoint Simultaneously<\/p>\n

Be sure to check back soon for the second part of this article on our blog page.<\/p>\n

1) Creating Tables in PowerPoint<\/p>\n

In principle, you have four options:<\/p>\n

Create a table on a slide
\nTransfer cells from Excel
\nCreate via a slide layout
\nImport a table from Word<\/p>\n

We\u2019ll walk you through these different procedures and show you how changes made in Excel are automatically updated in PowerPoint.<\/p>\n

1.1) Creating a Table on a Slide<\/p>\n

Depending on the size and length, you can quickly create a table using standard PowerPoint tools. Clicking on Insert > Table<\/strong> lets you choose the number of columns and rows your table should have.<\/p>\n

\"1.2_Figure-1\"<\/p>\n

You can always go back and adjust the number of columns and cells at any time.<\/p>\n

Just move the mouse pointer over the grid to highlight some of the cells. These highlighted cells correspond to the number of columns or rows (see next image). As soon as you click the selected cells, the table is displayed directly on the slide. By default, new tables are always set to “Medium Style 2 – Accent 1”.<\/p>\n

Tip: While you are selecting the number of columns and rows, look directly at the slide. The table adjusts while you\u2019re dragging the mouse over the grid. See the image below.<\/p>\n

\"1.1_Figure-2\"<\/p>\n

Tip: If you suddenly need an extra row, click on the last cell (lower right corner) and press Tab. An additional row will be added instantly. For more ways to adjust a table, go to Table Tools > Layout > Rows & Columns<\/strong>.<\/p>\n

You can also enter numeric values directly:<\/p>\n

A) Go to Insert> Table<\/strong>. The drop-down menu will appear.<\/p>\n

B) Below the grid, select Insert Table<\/strong>.<\/p>\n

C) Enter the number of columns and rows in the pop-up window and click OK<\/strong>.<\/p>\n

\"1.1_Figure-1\"\"1.3_Figure-4\"<\/p>\n

In special cases, e.g. scientific presentations, the table isn\u2019t symmetrical with equally sized cells. Go to Insert > Table > Draw Table<\/strong> and design each cell individually.<\/p>\n

After selecting this, the pointer changes to a pencil symbol. Design each cell by clicking and dragging to the desired size.<\/p>\n

\"1.1_Figure-4\"<\/p>\n

This approach requires a certain amount of experience and a bit of finesse. It\u2019s usually easier to insert a standard table, build custom cells separately, and then join them together. Tip: Sketch a rough draft on a sheet of paper before putting it into PowerPoint.<\/p>\n

Take a look at the image below. Custom tables (on the left) function like normal tables (on the right) and can be designed in similar fashion.<\/p>\n

A) Text can be entered into custom tables.B) Regardless of the size, your custom table will automatically adjust to fit any amount of text.<\/p>\n

B) Regardless of the size, your custom table will automatically adjust to fit any amount of text.<\/p>\n

C) You can change colors and text attributes in both table types.Tip: If you work regularly with custom tables, it might be useful to try out all options once to get well-acquainted with these settings.<\/p>\n

\"1.1_Figure-5\"
\nTip: With the exception of very individualized tables, it is usually a better idea to create custom tables from normal tables. This allows you to make changes and create tables more quickly than those created from scratch.<\/p>\n

A) This graphic was created by the Draw Table<\/strong> option. Each cell has been drawn individually.<\/p>\n

B) Normal tables were inserted here. This graphic took a lot less time to create and make slight alterations.<\/p>\n

\"1.1_Figure-6\"<\/p>\n

1.2) Transferring Cells from Excel<\/p>\n

Most Office users are familiar with inserting Excel spreadsheets in PowerPoint. There are two ways of doing this.<\/p>\n

The first way is by going to the drop-down menu under Insert > Table > Excel Spreadsheet<\/strong>. However, this command doesn\u2019t insert an existing spreadsheet that\u2019s saved on your computer.<\/p>\n

\"1.2_Figure-1\"<\/p>\n

Selecting Excel Spreadsheet<\/strong> gives you the option to create a new table from scratch. This function will change the PowerPoint screen display.<\/p>\n

A) A mini Excel table appears on the slide.<\/p>\n

B) The Excel ribbon opens changing the display screen from PowerPoint to Excel.<\/p>\n

C) As long as you work within this small table, the Excel ribbon will remain. If you click anywhere outside the table, the picture will change back to PowerPoint.<\/p>\n

\"1.2_Figure-2\"
\nBy default, the table is made up of two columns and two rows. Click along the striped border and drag to enlarge the table and create more columns and rows.<\/p>\n

Just a reminder: As long as this table is selected, you are working in Excel, which is embedded directly in PowerPoint.<\/p>\n

\"1.2_Figure-3\"<\/p>\n

You can still insert text into any table cell just like in Excel. Pressing Enter, Right Arrow, or Left Arrow automatically takes you to the next cell.<\/p>\n

Below are a few more tips for this dual activity in PowerPoint and Excel.<\/p>\n

A) Texts have been added in this 2 x 2 table. To enlarge the size but keep the same number of cells, click outside the frame (exiting Excel mode). Then click and drag the border to the desired size.<\/p>\n

B) Double-clicking on the table will reactivate Excel mode.<\/p>\n

C) Once back in Excel mode, click and drag the striped frame to increase the number of cells.<\/p>\n

\"1.2_Figure-4\"<\/p>\n

A) This table is displayed in PowerPoint mode. Any design changes must be made in Excel mode, which can be reactivated any time in case of subsequent changes to the table.<\/p>\n

B) Double-clicking on one of the cells in this table will reactivate Excel mode enabling you to add more content or make changes.<\/p>\n

C) Click outside the table to see the modifications displayed in PowerPoint mode.<\/p>\n

\"1.2_Figure-5\"A) Click the outer border of the table, and click Shape Fill<\/strong> to fill the cells with a desired color.<\/p>\n

B) To change the color of the border, click Shape Outline<\/strong> and choose a color. However, this only changes the outer border and NOT the cell lines within.<\/p>\n

C) Reason: If you just clicked on outer border, the tabs for Drawing Tools<\/strong> appear instead of Table Tools.<\/strong><\/p>\n

D) Therefore, most options will be in gray, and only a few options can be selected.<\/p>\n

\"1.2_Figure-6\"<\/p>\n

Copy cells directly from Excel<\/strong>.<\/p>\n

Many users prefer to copy and paste an Excel table into PowerPoint.<\/p>\n

A) Select an Excel table that has already been created.
\nB) Highlight all cells. Right-click and select Copy<\/strong>.
\nC) The table looks like this after pressing Ctrl + V in PowerPoint.<\/p>\n

\"1.2_Figure-7\"<\/p>\n

You have five different display options in PowerPoint.<\/p>\n

A) Use Destination Styles<\/strong> pastes only the data from Excel to PowerPoint.<\/p>\n

B) When you select Keep Source Formatting<\/strong>, all attributes such as colors, font, etc. are pasted from Excel to PowerPoint. However, if there are any graphics such as shapes, images, etc. inserted in the Excel table, they won\u2019t carry over to PowerPoint in the same way. The graphic will be pasted as a picture object over the data in the upper left corner of the cell. This can be solved with the next option.<\/p>\n

C) Selecting Embed<\/strong> will carry over all formatting and graphics to PowerPoint. Double-click the table to activate the Excel ribbon, as discussed earlier in this article. This is a real advantage for displaying and editing Excel tables in PowerPoint.<\/p>\n

D) Picture<\/strong> pastes the Excel table as an image or graphic that can be edited with image processing tools \u2013 similar to a photo. However, individual texts cannot be changed.<\/p>\n

E) With Keep Text Only<\/strong>, a text form of the table is created, which can be modified with Drawing Tools<\/strong>. Press Enter to insert a row, and jump from column to column with Tab.<\/p>\n

\"1.2_Figure-8\"<\/p>\n

PLEASE NOTE: Depending on how fast your computer is, how many applications are open, or how large the files are, switching back and forth from PowerPoint to Excel or Word can take a moment. Do not be surprised when the display looks strange when switching between programs.<\/p>\n

1.3) Creating a Table from Slide Layout<\/p>\n

Select a slide on the overview to the left and right-click it to display the pop-up menu. Select Layout > Title and Content<\/strong>. The below image appears on the slide. Clicking on the icon in the upper-left corner will enable you to insert a table directly.<\/p>\n

\"1.3_Figure-1\"
\n\"1.3_Figure-2\"
\nClick the table icon.<\/p>\n

\"1.3_Figure-3\"
\nA pop-up window will appear, where you can manually input the number of columns and rows.<\/p>\n

\"1.3_Figure-4\"<\/p>\n

1.4) Importing a Table from Word<\/p>\n

The procedure for copying and pasting tables from Word to PowerPoint is identical to that of Excel. From embedding it to importing it as a simple graphic, the same options apply. When you double-click the table, the Word ribbon is activated in PowerPoint.<\/p>\n

IMPORTANT: Tables made in older versions of Word (.doc) are also opened in the older version. Tables from newer versions (.docx) can only be opened in PPT 2013.<\/p>\n

1.5) Working in Excel and Updating a Table in PowerPoint Simultaneously
\nIn some presentations, you need to work out and adjust certain numbers with your audience. While you\u2019re making your modifications in Excel, these values should simultaneously be reflected in PowerPoint.<\/p>\n

Embedding an Excel table only inserts the latest saved version but is not linked with Excel.<\/p>\n

See the example below with PowerPoint and Excel.<\/p>\n

On the right is an Excel table that has been selected. On the left is a blank PowerPoint slide.<\/p>\n

\"1.5_Figure-1\"
\nNow the table has been pasted in PowerPoint with the Embed <\/strong>function.<\/p>\n

\"1.5_Figure-2\"
\nPeople make the mistake thinking that changing a value in the Excel table to the right will automatically update the table in PowerPoint. Unfortunately this is not the case.<\/p>\n

On the right, the value in the highlighted cell (C5) has been changed to 9999. On the left, the value has not changed in PowerPoint.<\/p>\n

\"1.5_Figure-3\"
\nEven when you click inside the embedded table in PowerPoint, the Excel ribbon will be activated, but no update will be performed.<\/p>\n

\"1.5_Figure-4\"
\nBut not to worry, there is another way! Save your Excel table to your hard drive. In PowerPoint, select Insert <\/strong>and in the Text<\/strong> group select Object<\/strong>.<\/p>\n

The Insert Object<\/strong> dialog box will appear. Select Create from file<\/strong> and click on Browse<\/strong> to open your file directory. Once you find your saved Excel table, click OK. Then, check the Link<\/strong> box next to Browse<\/strong>.<\/p>\n

\"1.5_Figure-5\"<\/p>\n

Now you will see the same table in both PowerPoint and Excel. The table in PPT is also linked to the one in Excel. When you make any changes to values or design in Excel, these are simultaneously displayed in PowerPoint after pressing ENTER, e.g. cell C8 (88888; fill, text color and size have been changed).<\/p>\n

\"1.5_Figure-6\"<\/p>\n

TIP: Are you familiar with “Presenter View” in PowerPoint? You can set it up so that the audience only sees the PowerPoint presentation while you work in Excel on your computer at the same time.<\/p>\n

And just like the saying “all roads lead to Rome,” there is another, quicker way of linking an Excel table to PowerPoint.<\/p>\n

1. Select all cells in Excel and right-click > Copy<\/strong>.
\n2. Switch to PowerPoint.
\n3. WAIT: Do NOT right-click and select any of the previous paste options!
\n4. Instead, in the ribbon, select Home<\/strong>> Paste<\/strong>> Paste Special<\/strong>.<\/p>\n

\"1.5_Figure-7\"<\/p>\n

    \n
  1. Another window will appear. Click Paste Link<\/strong> and select (if not already) Microsoft Excel Worksheet Object<\/strong>.<\/li>\n
  2. Now you can make changes in Excel, which will immediately update in PowerPoint.\"1.5_Figure-8\"<\/li>\n<\/ol>\n

    Good luck! We hope you enjoyed reading this article.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Presenting and discussing data tables during a presentation is par for the course, both for the speaker and attendees alike. In this two-part series, you will learn that tables are relatively simple to design when you consider the following topics: 1) Creating Tables in PowerPoint 1.1) Creating a Table on a Slide 1.2) Transferring Cells…<\/p>\n","protected":false},"author":10,"featured_media":7423,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[91],"tags":[],"class_list":["post-7390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-c_powerpoint-tipps"],"acf":[],"taxonomy_info":{"category":[{"value":91,"label":"PowerPoint Tips"}]},"featured_image_src_large":["https:\/\/www.presentationload.com\/blog\/wp-content\/uploads\/Excel_PPT.jpg",842,570,false],"author_info":{"display_name":"Tom Becker","author_link":"https:\/\/www.presentationload.com\/blog\/author\/tom\/"},"comment_info":0,"category_info":[{"term_id":91,"name":"PowerPoint Tips","slug":"c_powerpoint-tipps","term_group":0,"term_taxonomy_id":91,"taxonomy":"category","description":"Professional PowerPoint tips on how to use PowerPoint, functions, features and application examples. Save time and learn to create your presentations more effectively. With over 25 years of experience, we know exactly what is important when using PowerPoint in everyday business. Achieve your goals faster and work more productively with Microsoft PowerPoint. <\/strong>\r\n\r\nUse the many different editing options in PowerPoint for your (business) presentations. Take advantage of the simple user interface, edit, and enhance your presentations in a timesaving and skillful way. Put together your presentation professionally with PowerPoint tips\u00a0and stay in your listeners\u2019 minds after the presentation.","parent":0,"count":61,"filter":"raw","cat_ID":91,"category_count":61,"category_description":"Professional PowerPoint tips on how to use PowerPoint, functions, features and application examples. Save time and learn to create your presentations more effectively. With over 25 years of experience, we know exactly what is important when using PowerPoint in everyday business. Achieve your goals faster and work more productively with Microsoft PowerPoint. <\/strong>\r\n\r\nUse the many different editing options in PowerPoint for your (business) presentations. Take advantage of the simple user interface, edit, and enhance your presentations in a timesaving and skillful way. Put together your presentation professionally with PowerPoint tips\u00a0and stay in your listeners\u2019 minds after the presentation.","cat_name":"PowerPoint Tips","category_nicename":"c_powerpoint-tipps","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/posts\/7390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/comments?post=7390"}],"version-history":[{"count":0,"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/posts\/7390\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/media\/7423"}],"wp:attachment":[{"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/media?parent=7390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/categories?post=7390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.presentationload.com\/blog\/wp-json\/wp\/v2\/tags?post=7390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}