Excel Tip: Copy Excel cells to text box table in PowerPoint to animate by row

I often get asked how to copy a table of cells from Excel onto a PowerPoint slide and animate the table by row. The default paste of cells results in a PowerPoint table, which can’t be animated by row. In this video I show you how to paste the cells as a text box table that retains the formatting from Excel and allows you to use tab stops to create the columns. Because text boxes can be animated by paragraph, you can animate the text box table row by row. As a bonus, you can use this to round-trip a PowerPoint table to Excel and back to PowerPoint as a text box table.

By Dave Paradi

Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 4.8 million times and liked over 17,000 times on YouTube.