Excel makes it easy to insert pictures into your spreadsheets. This can be useful for adding visual interest, illustrating data, or creating custom charts and graphs.
Step 1: Insert the Picture
To insert a picture into Excel, follow these steps:
Click the Insert tab.
In the Illustrations group, click Pictures.
Browse to the picture that you want to insert and select it.
Step 2: Format the Picture
Once you have inserted the picture, you can format it to your liking. Here are a few things you can do:
Resize the picture: Click and drag the edges of the picture to resize it.
Note: You don’t have to stretch the cell size if your picture is small. You can therefore skip this step if you don’t need it.
Move the picture: Click and drag the picture to move it to a different location.
Change the picture’s borders: Click the Format Picture button and then click the Border tab. In the Border Style section, select the border style that you want.
Click on the square with four different directional arrows (1), click properties (2), and choose move and size with cells (3).
Resize the picture by clicking on the edge, and finally move it to the cell, where you want it. To move the picture, click on it to select it and drag it to the desired location.
Drag its edges to adjust its size.
Note: No need to alter cell dimensions for small pictures.
Change the picture’s fill color: Click the Format Picture button and then click the Fill tab. In the Fill Color section, select the fill color that you want.