How to fix the insert image in Excel

Images when inserted into Excel data tables may change depending on the data table processing requirements. Images can change position or any size. Or when we change the size of the columns and rows on the Excel spreadsheet, the images in those columns and rows will also be changed in position and size. However, many people do not want images inserted in Exel cells to be changed when sending files to others, even if they adjust the columns and rows. Just like fixed columns and rows in Excel, users can permanently fix cells in Excel. Previously, Network Administrator once instructed you to read how to fix shapes in Excel. The following article will show you how to fix images in Excel.

1. How to format borders and background colors for Excel tables
2. How to set Excel password to secure data file
3. How to create a password protection for Excel sheets
4. How to automatically highlight rows and columns in Excel

Instructions for fixing images in Excel cells

Step 1:

In the box to insert the image, we click Insert and select Picture to select the image to insert. Then we adjust the image in the cell accordingly.

How to fix the insert image in Excel Picture 1

Step 2:

Click the right mouse button on the image and then select Size and Properties . in the displayed list.

How to fix the insert image in Excel Picture 2

Step 3:

Then on the right side of the interface displays an image editing frame. We clicked on the Properties to adjust the image inserted in the Excel cell

How to fix the insert image in Excel Picture 3

Then there are 3 fixed options for inserting images in Excel, including:

1. Move and size with Cells: images or frames can be moved, resized when users change row and column sizes.
2. Move but don't size with Cells: images can be moved but cannot be resized when resizing rows and columns.
3. Don't move or size with Cells: images cannot be moved and cannot be resized when you change the size of rows and columns.

We choose the type of fixed image in the Excel cell we want to use, depending on the need to be fixed.

How to fix the insert image in Excel Picture 4

Only with a very simple setting, the image inserted in the Excel cell is not changed in size, nor is it moved if you change the row or column. The image will be fixed in the correct position that you insert in the data sheet.

I wish you all success!