Like and see, form a habit; Quiet to cultivate morality, thrift to raise virtue.
Wechat search [Yixin Excel] to pay attention to this different we-media person.
In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.
I don’t know if you need to insert pictures in batches when dealing with Excel data. For example, when managing employee information, you need to add a picture for each employee. If you insert pictures one by one and then adjust the size and alignment after inserting them, it is too inefficient, and your eyes will become blind. Today I’m here to share with you a small technique for batch insert images.
First, prepare the following image materials:
Then prepare the form:
Enter “in cell C2.
“
Select the C2:C5 cell area and press Ctrl+C to copy the contents. Then open Notepad and press Ctrl+V to copy the contents to Notepad.
Then empty the contents of the C2:C5 cell area and adjust the width of the C2:C5 cell to 150 pixels by 100 pixels. It is important to note that the width and height of the cell here are not exactly the same as the width and height of the image in the path above, so I adjusted the cell here to be 150 pixels wide and 100 pixels high, which corresponds to the image 120 pixels wide and 80 pixels high. Of course, these can be adjusted according to their actual situation.
Then open the notepad, press the shortcut key “Ctrl+A” to select all the contents and press the shortcut key “Ctrl+C” to copy the contents. In Excel, select C2 cell with the mouse, right click to bring up the right menu, and choose “Selective Paste” to bring up the selective paste dialog box.
Select Unicode Text and press ok.
Let’s take a look at the specific demonstration process:
Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.
If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.
This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.