Insert Picture into a Cell in Excel 2007 injust in cell auto fit

Описание: To insert a picture that autofits within an Excel 2007 cell, first go to the Insert tab, click Pictures, and select your image. Then, hold down the Alt key and drag the image's corner to snap its size to the cell's dimensions. Finally, right-click the image, select Size and Properties, and under the Properties section, check the Move and size with cells option.



Step-by-Step Guide

1. Insert the Picture:
Click on the blank cell where you want the picture to be.

Go to the Insert tab on the Excel ribbon.
Click on Pictures.
Browse to your desired image file and click Insert.

2. Resize the Picture to Fit the Cell (Using Alt Key):

After the picture is inserted, it will likely be larger than the cell.

Hold down the Alt key on your keyboard.
Click on the picture and drag its corner handles to resize it so it fits the cell's boundaries. The Alt key allows the picture to snap to the grid lines of the cells.

3. Set Properties for Autofitting:

Right-click on the resized picture and choose Format Picture (or Size and Properties in some versions) from the context menu.

The Format Picture pane will open, likely on the right side of your screen.
Make sure the Properties section is expanded.
Select the option Move and size with cells.
Close the pane.