How to insert a fixed image into a cell in excel

Through a post on how to insert pictures into excel comments on the TipsMake's fanpage, the admin of the fanpage promised to make a video on how to insert pictures into a cell in excel. Therefore, the following TipsMake will guide you on the trick of inserting an image into a cell in excel so that when CHANGING SIZE OF CELL (CELL), SIZE OF PHOTO ALSO CHANGED BY. The procedure is quite simple, no need to spend on VBA or anything sublime.

This procedure will apply to cases where the number of images is not large. But for you to work with a large amount of data and a lot of photos, it is recommended that you do not use excel, or if required, you must use VBA or add-in.

Video:

Step 1: Insert pictures into cells (cell) in excel

Insert pictures as usual, select the cell you want to insert the image -> Insert -> Picture -> select -> Insert

Step 2: Resize the image to fit the cell size

To adjust the image size so that reasonable, you can not use the normal way of holding the mouse just dragged dragged.You need:

- Click on the image you have just selected,

- Then hold down the ALT key,

- Continue dragging the 4 directions of the cell with the 4 arrow keys moving through 4 directions to fit the border of the cell.Remember to pull so smart offline

Step 3: Format the size of the photo in the Properties status card

Now notice that even though you have manually adjusted the image to fit the box, but if you do nothing next, but simply DRAG FOR WIDE OR LONG, the size of the image DO NOT CHANGE, but remain in the same position.So what do you guys do?

-> You need:

- Right-click on the image that fits in an excel cell, select Format Picture -> then select Properties -> finally select Move and size with cells -> Close

-> Now try to CHANGE THE SIZE OF THE BOX to see if the image size has changed.Good luck!