How to add pictures in batches in Excel? How to batch import pictures into Excel

　When many users use Excel to edit tables, they need to add pictures in some places, but the speed of adding them one by one is too slow, but they don’t know how to import them in batches. To solve this problem, today’s software tutorial is here for all users Answer and let’s take a look at the detailed operation method.

　The operation method is as follows:

　1. Double-click to open the software and click "DIY Toolbox" in the upper toolbar.

<code><p><img src="https://img.php.cn/upload/article/000/000/000/172241910546739.png" alt="How to add pictures in batches in Excel? How to batch import pictures into Excel"></p>
</code>

　 2. Then click the "Picture" option in the menu bar below.

<code><p><img src="https://img.php.cn/upload/article/000/000/000/172241910729540.png" alt="How to add pictures in batches in Excel? How to batch import pictures into Excel"></p>
</code>

　 3. Then click "Import Pictures".

<code><p><img src="https://img.php.cn/upload/article/000/000/000/172241911094576.png" alt="How to add pictures in batches in Excel? How to batch import pictures into Excel"></p>
</code>

　　4. Then in the window interface that opens, find "Annotate Simultaneously" and check the small box.

<code><p><img src="https://img.php.cn/upload/article/000/000/000/172241911275460.png" alt="How to add pictures in batches in Excel? How to batch import pictures into Excel"></p>
</code>

　5. Finally, set the "Picture Size" to "Scale by Cell Height"

<code><p><img src="https://img.php.cn/upload/article/000/000/000/172241911471202.png" alt="How to add pictures in batches in Excel? How to batch import pictures into Excel"></p>
</code>

　　6. In this way, the pictures are successfully inserted in batches.

<code><p><img src="https://img.php.cn/upload/article/000/000/000/172241911777286.png" alt="How to add pictures in batches in Excel? How to batch import pictures into Excel"></p>
                        </code>

The above is the detailed content of How to add pictures in batches in Excel? How to batch import pictures into Excel. For more information, please follow other related articles on the PHP Chinese website!