Inserting pictures in Excel cells
Excel is an important and helpful program that you can use to list complicated information in a clear way and present it in an organized table. If you want to insert a picture in Excel, size and line spacing can cause problems. In this article, you will learn how to insert a picture in Excel and lock it to a cell correctly.
$1 Domain Names
Register great TLDs for less than $1 for the first year.
Why wait? Grab your favorite domain name today!
What to do if the picture in Excel moves?
Would you like to upgrade a long table with a photograph? Or perhaps a chart or graph is essential to make your table understandable? With Excel, you can integrate pictures into your document. However, once the picture has been integrated, it often does not stay in the intended place. As soon as you insert lines or re-sort the table, the inserted picture moves and then has to be repositioned manually. By taking the right steps beforehand, you can prevent this problem and ensure that all your pictures in Excel stay in the right place.
Inserting a picture freely in Excel
First, select the picture that you want to use and save it as usual. Then proceed as follows:
- Open the corresponding Excel document.
- Click on Menu and then on “Insert”. Select “Illustrations”, click on “Pictures” and search for the picture that you want to insert. Alternatively, you can search for the picture in Explorer or Finder, copy it by right-clicking or by clicking on shortcut and then inserting it in the Excel document.
The corresponding picture is now in the table, but it is neither the right size nor in the right place.
With Microsoft 365, you can use the latest versions of Excel, Word and all other Office applications on up to five different devices. 1 TB cloud storage provides the necessary space needed for all your documents.
Positioning a picture in Excel
For the next step, you will position the picture and make sure that it fits in well. To do this, click on the picture and drag the corners until it fits into the cell that you want it to. If you want to keep the picture in its original size, change the size of the lines and columns instead. You can also move and adjust the picture as you like. If you keep the “Alt” button pressed during the positioning, the picture will automatically be aligned with the table lines and will no longer hover over the table.
Excel: Lock the picture to a cell
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.
If you want to save Excel documents in a central and secure location, HiDrive Cloud Storage is the best option. With it, you can share and edit your documents in a secure online cloud.
Free or locked picture? You can choose!
You can insert a picture in Excel and choose whether it should be locked or remain freely movable. The modifications in Excel are retained, even if you convert the document from Excel to PDF. Most Excel alternatives also give you the option to insert the picture in a cell and lock it, just like in Excel.
Professional Email Address & Personal Domain Name
Get an email address as professional and unique as you are including a free matching domain!