It is easy to insert pictures into Excel worksheets. In this article, we will show you how to embed pictures into cells.
In general, you cannot insert an image into a cell directly. But with additional settings, the image can stay in the designated cell.
Insert Pictures into Worksheets
Here we will demonstrate the steps to insert an image into the worksheet.
- Click the tab “Insert” in the ribbon.
- Next click the button “Picture” in the toolbar.
- In the “Insert Picture” window, choose the image that you need.
- And then click the button “Insert”.
Thus, you have inserted the image into the worksheet.
Keep the Image in a Cell
Now follow the steps below and make the image stay in the cell. In this example, suppose we need to put the picture in cell A1.
- Right click the image.
- And then in the new menu, choose the last option “Format Picture”.
- In the “Format Picture” window, select the option “Properties” on the left.
- And then in the “Object positioning” area, choose the first option “Move and size with cells”.
- After that, click the button “Close” to close the window.
- Now move the image to the position of the cell A1.
- And then resize the image to make it fit the size of cell A1. If you find that the size of the cell is too small to manipulate, you can also change the size of A1. You can refer to the image below to see the result.
Now you have finished all the settings. The image is in the designated cell. When you change the size of the cell, the image size will also change synchronously. For example, now we change the size of cell A1 into the default size. The column width is 8.43 and the row height is 15. The image size will also change accordingly.
Therefore, if the next time you need to insert pictures into cells, you can also use this method.
Identify Malicious Plug-ins in Excel
Excel itself is already a powerful tool for users. With some plug-ins, it can fulfill even more tasks easily. Therefore, many people have devoted themselves to developing plug-ins for Excel. However, some malicious hackers will also release vicious plug-ins. If you use those plug-ins in your Excel, your data and information will be in danger. Your data will be destroyed or other people can get access to your confidential files. To avoid those accidents, you need a third party tool at hand. Once you find there is something wrong with your files, you can use this tool to recover Excel immediately. If you need to use the features of plug-ins, you need to be more careful.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com