How to Insert an Excel Table into PowerPoint

The quickest way to insert an Excel table into PowerPoint is to copy the cells in Excel, then paste them onto a slide. PowerPoint turns them into a native table you can format and edit. If the numbers will change and you want the slide to keep up, use Paste Special > Paste link instead. To carry a full copy of the worksheet inside the presentation, embed it with Insert > Object. Each method is below, with tips for keeping the table readable on a slide.

Which method should you use?

• Paste as a table: the data won’t change, and you want to restyle it to match your slides.
• Paste link: the spreadsheet is updated regularly and the slide should show the latest numbers.
• Embed: you’ll send the deck to people who don’t have the Excel file, but want to keep spreadsheet editing.
• Picture: you just need a fixed snapshot that can’t be changed by accident.

Method 1: Copy and paste as a PowerPoint table

1. In Excel, select the cells, including headers, and press Ctrl + C.
2. In PowerPoint, click the slide and press Ctrl + V.
3. Click the Paste Options button that appears and choose:
   • Use Destination Styles to match the presentation’s theme.
   • Keep Source Formatting to keep Excel’s look.
   • Picture for an image.
   • Keep Text Only for plain text.

Use the Table Design and Layout tabs to change styles, fonts, and column widths. Formulas are not kept; PowerPoint stores the values.

Method 2: Paste a linked table

1. Save the Excel workbook.
2. Select and copy the cells in Excel.
3. In PowerPoint, click the arrow under Home > Paste and choose Paste Special.
4. Select Paste link, choose Microsoft Excel Worksheet Object, and click OK.

Double-clicking the table opens the source workbook. To update the slide after the data changes, right-click the table and choose Update Link, or use File > Info > Edit Links to Files. Keep the workbook in the same place, or the link breaks. Charts work the same way when you link an Excel chart to PowerPoint.

Method 3: Embed the worksheet

Either use Paste Special > Paste > Microsoft Excel Worksheet Object (without ticking Paste link), or:

1. Go to Insert > Object.
2. Choose Create from file, click Browse, and select the workbook.
3. Leave Link unticked and click OK.

Double-click the embedded table to edit it with Excel’s tools right inside PowerPoint. The whole workbook is stored in the presentation, which can make the file much larger.

Method 4: Create an Excel table from scratch in PowerPoint

Go to Insert > Table > Excel Spreadsheet. A small worksheet appears on the slide with Excel’s ribbon, so you can type data and use formulas without leaving PowerPoint.

Tips for tables on slides

• Show less. A slide table should have only a handful of rows and columns. Summarize in Excel first, or split the table across slides.
• Use a large font. 18 point or more keeps it readable from the back of a room.
• Highlight the point. Bold or color the row or figure you want people to notice.
• Consider a chart. Trends and comparisons are often clearer as a chart than as a table.

Troubleshooting

The pasted table runs off the slide

Drag the corner handles to resize, reduce the font size, or paste fewer rows.

Paste link isn’t available

The workbook hasn’t been saved, or you cut instead of copied. Save it and copy again.

Linked numbers don’t update

Right-click the table and choose Update Link. If PowerPoint can’t find the file, use Edit Links to Files > Change Source.

Frequently asked questions

Can I do this in Word too?

Yes, the same paste options work in Word, whether you link Excel to Word or embed an Excel file in Word.

Does this work in PowerPoint for Mac?

Yes. Paste and Paste Special work the same way; on a Mac, Paste Special is under Edit > Paste Special.

Summary

Copy cells in Excel and paste them into PowerPoint for an editable table. Use Paste Special > Paste link to keep it updated from the workbook, or Insert > Object to embed a self-contained copy.

More PowerPoint tasks: inserting a Word document into PowerPoint and compressing all the pictures in a presentation.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.