Home  >  Article  >  Software Tutorial  >  How to set up synchronized display of Excel tables inserted into PPT

How to set up synchronized display of Excel tables inserted into PPT

王林
王林forward
2024-03-26 14:56:38821browse

php editor Zimo will introduce you to the operation method of inserting PPT into Excel table and setting up synchronous display. When making PPT, inserting Excel tables can make the data more intuitive and clear, but how to keep it displayed synchronously with Excel is the key. Through simple operations, you can realize real-time updates of Excel tables in PPT, making your presentation more professional and efficient. Next, let’s learn about the specific steps!

1. Create a new PowerPoint or Excel file in the folder.

How to set up synchronized display of Excel tables inserted into PPT

2. Enter the data that needs to be displayed in Excel, or ignore the previous step of creating a new Excel file and prepare an Excel table that needs to display the data.

How to set up synchronized display of Excel tables inserted into PPT

3. Open PowerPoint, click Insert - Object, and the Insert Object dialog box will pop up.

How to set up synchronized display of Excel tables inserted into PPT

4. In the Insert Object dialog box, click Create from file and click Browse. Find the prepared Excel data sheet and confirm.

How to set up synchronized display of Excel tables inserted into PPT

5. Return to the Insert Object dialog box, check the link option, and confirm. Then the data table is inserted.

How to set up synchronized display of Excel tables inserted into PPT

6. Double-click the inserted table in PowerPoint to open the called Excel table for editing.

How to set up synchronized display of Excel tables inserted into PPT

7. After opening the called Excel table, you can modify the data and format of the table. This will be synchronized in PowerPoint and there is no need to insert it again.

How to set up synchronized display of Excel tables inserted into PPT

Note: Check the link option in the Insert Object dialog box.

The above is the detailed content of How to set up synchronized display of Excel tables inserted into PPT. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete