You can now insert a picture in Excel, but the problem of it moving remains.
- Right-click on the picture and select the “Size and Properties” option from the context menu.
- Here you will find the “Properties” tab and the object positioning at the top.
- Directly below is the option “Move and size with cells”. Select this option.
If you make any modifications to the table now, the picture in Excel will be adjusted to the formatting and will remain locked to the corresponding cell. If you re-sort the table now, the picture and cell will remain locked to each other. So if you change the size of the cell, for example, the picture will change with it. If you do not want this to happen, select the option “Move but don’t size with cells”. With this option, the picture in Excel is locked to the cell position but will not be affected by any changes made to the size of the cell. The third option, “Don’t move or size with cells”, means that the picture will not be locked to a cell.