Excel organize pictures with one click? This is the easiest way. 80% of people don't know.

Hello, everyone!

I am Chang Xiaoan, a classmate who likes to eat snacks and learn Excel.

Two days ago, I saw a hot search # only to know that Excel can organize pictures at once #, that is to say, as a qualified Exceller, how can I not know this trick?

Well, it just so happens that I got an assignment from my boss:

There are many names in the form, and their photos are all in the same folder.

Before I get off work, I will insert all these photos into the table and arrange them one by one.

Then I'll use this as an example to show you how to insert pictures in batches.

This tip mainly takes advantage of typesetting features: left alignment and vertical distribution.

Let's take a look at the following detailed picture and text analysis!

👉 procedure:

❶ select the "name" column, click the "data" tab-Select "Ascending" sort, and adjust the width and height of the cells in the right column to fit the image size.

❷ Click the insert tab-Select Illustration-Select Picture-from this device.

❸ under the picture directory with the left mouse button, select all the pictures-click [insert]-resize the pictures appropriately.

❹ moves the last picture to the corresponding cell-[Ctrl+A] all selected pictures-Click [format] tab-[arrange]-alignment Select [left alignment]-alignment Select [Longitudinal Distribution].

In this way, the pictures will be arranged easily, isn't it very simple?

You may have such a doubt: why can the pictures correspond to the names in ascending order?

Because in the folder, the photos are sorted by name by default in ascending order (increasing is ascending order).

So in the table, sort the names first, and the pictures can correspond one by one.

How's it going? have you learned?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Chang Xiaoan, Editor: Yedong