Cropping images

Once we have added an image to Excel, we will often change its dimensions immediately, which can be done manually or by setting the height and width. It happens that the added image contains some unnecessary details. In that case, we are cropping the image to highlight only those parts of the image that we want to see in the worksheet. In addition to simple cropping, Excel also offers several advanced options for cropping images (fitting into a desired frame) …

Cutting the image is done by selecting one of the options from the Crop menu from the Format ribbon. The first of the menu options offered, the Crop option, serves to independently crop the edges of the image. After its activation, the image will get a temporary “frame”, which indicates that we entered the image modification mode. By dragging the edges of the frame to the inside of the image we select which parts should remain visible after the end of the operation. Clicking the mouse next to the image ends the operation and Excel makes a crop.

Cropping can be done so that the image, after correction, gets a certain shape such as: circle, rectangle, star, heart … In this case, we need to select the Crop to Shape option from the Crop menu. There will be a submenu that offers many forms that exist in Excel. By selecting one of them, the image is cut according to the given shape.

Aspect Ratio is another useful Crop menu option. It allows you to change the image dimension in relation to one of the offered aspects (4: 3, 16: 9, etc.). The Fill and Fit options allow you to change the dimensions of the image so that the whole frame is filled with a certain image, that is, the image is placed in (smaller) frame.