You might be wondering if there is an option to add any image or photo into the excel spreadsheet cell? Well, most users are not knowing how to do it or if there is any feature as such. But after adding or inserting an image into the spreadsheet, it is not so easy to fit into the cell.
Even after adding an image, it becomes a problem if there is any manipulation needed which involves that particular cell in a row or column. If you are also finding it difficult to add or insert an image into the spreadsheet cell or use it while using any formula or operation, then this post will guide you on how you can do it quite easily with the steps below.
How to Add a Picture into Excel Sheet Cell
Step 1: Press the Windows key first on the keyboard and type excel.
Step 2: After that, select the Excel app from the search results to open the Excel app on your system as shown in the below screenshot.
Step 3: Next you can click Blank workbook or open any other existing saved excel sheet from your computer by browsing as shown below.
Step 4: Once the spreadsheet is open, in order to add an image to the sheet, you need to go to the Insert tab on the top bar.
Step 5: Then, click the Pictures option in the Illustrations section and select This Device from the dropdown menu as shown in the below screenshot.
Step 6: In the Insert Picture window, browse to the folder which contains the images and select any number of images you want and click Insert at the bottom as shown below.
NOTE: In this example, we have selected two images, you can select one or more you want.
Step 7: After the images are added to the sheet, to fit an image into a particular cell, you need to drag the image edges while pressing and holding the ALT key on your keyboard.
NOTE: Below screenshot shows what it looks like after inserting an image into the cell.
Step 8: Now select any row which contains the image that you had inserted just now.
Step 9: Right-click on the row and click the Hide option from the context menu as shown below.
Step 10: If you observe that the row is hidden but the image does not get hidden along with the row.
Step 11: So in order to make the image move with the cells, first only select the image of a particular row.
Step 12: Then, right-click on the image and click Format Picture from the menu as shown below.
Step 13: On the right side, Format Picture a small window appears.
Step 14: Go to the Size & Properties icon on the top menu as shown below.
Step 15: Then, click on Properties to expand so that you can view the options.
Step 16: Now select the Move and size with cells radio button from the list and simply close the Format Picture window as shown.
Step 17: Now if you try to hide that row, you can see that the entire is hidden along with the image inserted into a cell from that row.
Step 18: Now you need to do the same for all the images one by one that was inserted into the cell of your excel sheet.
Hope this was informative and please let us know in the comments area.