Insert a Table in PowerPoint from Excel?

One of the conveniences that PowerPoint presentations provide is the ability to insert tables and make them dynamic in nature from any source, particularly Excel.

This allows presenters to continue in the flow of their presentations without having to shuffle through multiple open windows.

[{"selector":"#anim-5ccdf9a0-ab59-499c-adfd-7b8fddd17f68","keyframes":{"opacity":[0,1]},"delay":600,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Learn more

Method 1 – Using Copy and Paste

[{"selector":"#anim-a78cf576-9f04-46d0-85c0-182796d4e045","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7dd6c3fa-86cb-4df2-886c-f8ec6fb89d63","keyframes":{"transform":["translate3d(-114.86069%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-aa18fe0d-74dd-43e1-8a7f-d7ff5b6cfadc","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c7cc208e-8653-40a6-93d7-ebe740332347","keyframes":{"transform":["translate3d(-114.50152%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5fe15cba-a048-431a-b665-5c1174c99a5e","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9b92fcbe-ea60-4a0c-9fc6-5038b31dd5f3","keyframes":{"transform":["translate3d(-99.52718%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Step-1: The first step is to open the Microsoft Excel worksheet from where you want to copy the table. Learn more

[{"selector":"#anim-ac039950-1142-412f-a1a8-d891df858660","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c0553f19-f9c9-42a9-a57f-45c1ef672070","keyframes":{"transform":["translate3d(-117.37705%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5c3f3e77-04e9-466b-8ac5-4fbdcf495b3a","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f0f9cc7b-e9f7-4aa2-960b-f4de7e2f23bd","keyframes":{"transform":["translate3d(-99.52718%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Then select the preferred columns and rows to highlight them. “Right Click” on it and click on the “Copy” option. Learn more

[{"selector":"#anim-a4034987-6712-41df-b5a8-143bdb09d0b3","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6aacbc75-ac17-436a-a70d-993a4614d942","keyframes":{"transform":["translate3d(-118.18181%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-068d230d-97d4-40d0-85f0-932107e8caf6","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f29d1f7d-e141-45f3-811e-aae0925b56a7","keyframes":{"transform":["translate3d(-99.52718%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bf264870-5b37-4e86-baca-29df8cdb5121","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-80182ecd-7276-47f2-bfd7-c39a63b46114","keyframes":{"transform":["translate3d(-118.18181%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] “Right Click” on the PowerPoint slide where you want to add the table. In the right-click menu, click on your preferred option under “Paste Options” . Step-2: Learn more

[{"selector":"#anim-85e3b7d5-9356-4c45-a3fb-83e1c8ae9c5b","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-397f69ba-1c88-4c5f-bcaa-9aa3cdb92b1f","keyframes":{"transform":["translate3d(-121.21212%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f0203d5d-957e-4295-bf9a-7373cd685bfd","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c87e92c7-52f9-496c-9621-49afc0454d35","keyframes":{"transform":["translate3d(-100%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] You can alternatively press the “Ctrl+V” keys on your keyboard to paste the Excel table to your slide. Learn more

[{"selector":"#anim-21d629ab-aa0c-470d-8a81-0e56909fd63a","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b62195fe-b319-4975-9017-4e4da0e79aa9","keyframes":{"transform":["translate3d(-117.02899%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-47b6687c-1503-4541-8776-ecfdc3a47171","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e9131976-1697-4e8f-af17-28f568f64aeb","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1399f4be-8565-4a81-a746-38ceda3458bd","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1e5c86fd-1984-4475-8061-c93a996b1a16","keyframes":{"transform":["translate3d(-98.58156%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Method 2 – Using Paste Special Step-1: In the “Paste” group of the “Home” tab, click on the down arrow under the “Paste” icon that looks like a clipboard. Learn more

Then click on the “Paste Special” option from the dropdown menu to launch a dialog.

[{"selector":"#anim-9fc5b8c0-fff2-49e9-a65d-13562be99b55","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ebd7ed2b-521c-4cd0-9ad6-243989e6c531","keyframes":{"transform":["translate3d(-116.66667%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8d3a8bc7-cf4e-4c68-817d-40396b76c8a9","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8db97d84-dffc-46a0-8d94-77da79a60f93","keyframes":{"transform":["translate3d(-100%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

Swipe up to learn more!

[{"selector":"#anim-cf56b330-d8c3-489c-b064-9b5c2ee1643d","keyframes":{"opacity":[0,1]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-98c5eebc-923e-4109-b866-c8d16f0a478b","keyframes":{"transform":["translate3d(-139.39394%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":250,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

MORE POSTS

[{"selector":"#anim-6c464331-922e-4c9d-ab55-51449e83c671","keyframes":{"transform":["translate3d(-201.46342%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-458bbc17-dc4d-417d-8513-3d11996bd1f7","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fc9b5edf-37ca-462f-8bff-41b881555700","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-993e3850-3daa-4530-80b9-5b12fe190e30","keyframes":{"transform":["translate3d(-202.451%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-185a77ea-a472-4266-818a-dc120bc713f8","keyframes":{"opacity":[0,1]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-92f9db6a-2e00-436d-a73d-646da6ba63a7","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-d2cb9317-337f-467d-9ea9-4f6b0b119181","keyframes":{"transform":["translate3d(-233.53293%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ea795b64-cf5a-43e4-bb5c-19e77621a72f","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f1489a78-ee66-4aab-bdd9-fe19d55fdfc2","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-4f503837-bff0-4e48-93f1-39325bf1f42a","keyframes":{"transform":["translate3d(-246.71053%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":700,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-28930eea-1041-4a3d-83a5-32917362b937","keyframes":{"opacity":[0,1]},"delay":700,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ebb389a3-7fff-4dc5-9dc3-3d95e9552e1d","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":700,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-69519997-fb43-462f-bfca-852cf61c0286","keyframes":{"transform":["translate3d(-233.53293%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-64e806ef-8969-477f-a609-c13b064637e7","keyframes":{"opacity":[0,1]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3e66799e-bd63-4c26-8ca0-544db36b3f86","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-5045ba17-1c05-453c-bb2b-e5e39470e93a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-36e6d514-66c0-4ef8-aca3-d56358934192","keyframes":{"transform":["translate3d(-117.36335%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] How to Add Tables in PowerPoint? [Complete Guide!] How to Move or Resize Tables in PowerPoint? [An EASY Way!] How to Format a Table in PowerPoint? [The ULTIMATE Guide!]