Shulou(Shulou.com)11/24 Report--

The original title: "the boss gave me 1 day to finish the task, I only took 3 minutes!" "

The leader gave me one day to use Excel to make a product quotation table with pictures. It would take a lot of time for someone else to type in the product name one by one, and then insert the photo, and I did it in minutes!

Prepare the picture to prepare the product picture, here the product picture has been named, put the picture under a separate folder.

Definition name in Excel, click "Formula"-"definition name"-"definition name"; set a name; then enter "= FILES (" D:\ picture\ * .jpg ")" in "reference location".

Description:

"D:\ picture\ * .jpg"

The folder where the "D:\ pictures\" pictures are stored.

"*" all; the ".jpg" after it is the picture with the JPG suffix.

All my pictures here are suffixed with ".jpg" if you are ".PNG." Or the ".gif" suffix can be modified by yourself. If you have all these image formats, you can change it to "= FILES (" D:\ picture\ *. * ")".

The build name is entered in F1

= INDEX (Word Union ROW (F1)) fill down to get the name of the product picture and delete the unnecessary and useless. Then copy all the names, select cell B2, "right"-"paste options"-"value".

Batch delete suffixes select column A, and then enter "data"-"data tools"-"separate", next, check "other", enter ".", then next, select all suffixes, click "do not import this column", and finally "finish" to delete the suffix.

Set the picture size to enter in cell C2.

= "

"then fill it down.

Description:

"D:\ picture\" is the picture folder

"A2" refers to the product picture name

Width and height are the width and height of the picture, which can be set by yourself.

Insert a batch of pictures to copy the C column code, then create a new "text document" and paste it in. Then copy the contents of the "text document", go back to the Excel table, select cell C2, "right"-"paste selectively"-"Unicode text" to determine, OK, now the pictures have all been inserted into the Excel table.

Batch adjust the cell in Excel, select the whole row, the whole column and resize the cell at the same time, at this time, all our pictures will be displayed.

Set automatic line wrapping select column A, "right"-"format cells"-"align"-"text control"-check "automatic line wrapping", OK, and then adjust the width of column A.

Finally, adjust the details, and then enter the product price, how about it!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.