Excel batch insert picture sharing skills

Original title: "batch insertion of pictures is super easy, teaching you 30 seconds to get it done!" "

When you insert a picture in Excel, your first reaction is not [insert]-[picture]-select a picture-[OK].

One by one, take your time, look up, it's time to get off work.

There's a lot more. QAQ

Want to get it done quickly, get off work soon?

Today I'm going to teach you how to insert pictures in bulk!

Before inserting a picture, make preparations: sort, adjust the width of the rows and rows.

For specific methods, see ↓↓↓ here.

❶ sorts the names of the pictures in ascending order.

Select the name column, select the data tab, and click

After the pop-up window, click "sort" directly.

❷ adjusts row and column width.

👉 adjusts the line width:

Select the second row and press the shortcut key [Ctrl+Shift+ ↓] to select other areas of the table

Move the mouse over the line mark junction and change to

Drag to adjust the row height.

👉 adjusts the column width:

Select column B to adjust.

The preparatory work is done, and then, the show begins!

Insert Picture ❶ Click "insert"-"Picture"

❷ select the folder where the pictures are located and press [Ctrl+A] to select all pictures-[insert].

Set the height of the image. Set the height of the image uniformly in [Image tool]-[format]. Here, set it to 3cm.

Adjust the picture position ❶ select the last picture and put it on the last line

❷ then [Ctrl+A] select all the pictures, under the "Picture tools"-"format" tab, find "align", and select "align left".

❸ open "align" again, select "Longitudinal Distribution", and adjust the position of the image.

Isn't it easy?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E