When inserting an image into a cell in Excel, you can usually go to “Pictures” > “Place in cell” in the “Insert” tab. However, when you paste an image into Excel, the image will float above the cells, and it won’t be positioned inside. To resolve that problem, we can use the “Move and size with cells” option. In this Excel training video, we’ll show you how to do that.
Resources
Access the Move and size with cells option:
- Paste and select the image.
- Click the “Picture Format” tab.
- Select “Format Pane” in the ribbon.
- Click the size icon.
- Select “Properties.”
- Choose “Move and size with cells.”
Alternative method:
- Right-click the pasted image.
- Select “Format picture” from the popup menu.
- Click the size icon.
- Select “Properties.”
- Choose “Move and size with cells.”