When using Insert Image, the most common questions are about image size, image attachment behavior, and the difference between picture types; this FAQ covers 3 common questions and practical answers.
FAQ
How do I resize an inserted picture if it looks too large or too small?
- If it is a floating picture, select the image first.
- Drag the corner handles to adjust the display size.
- If it is a picture in a cell, adjust the row height and column width of the cell to change the displayed size.
How do I change a picture in a cell into a freely movable picture?
- Select the picture that is already inserted in the cell.
- Open the picture shortcut menu.
- Choose the option related to picture type switching, then change it to a floating picture before moving it.
What is the difference between a floating picture and a picture in a cell?
- A floating picture appears over cells and can be moved and resized independently.
- A picture in a cell is embedded inside a cell and changes with the cell size.
- Use a picture in a cell when the image should stay aligned with a data row, and use a floating picture when you need flexible layout control.
Glossary
| Term | Definition |
|---|---|
| Floating Picture | An image object displayed over cells that can be moved and resized freely. |
| Picture in Cell | An image embedded in a cell, with display behavior that changes with the cell size. |
| Default External Paste Mode | The insertion type used by default when you paste a copied image into the worksheet from another source. |