How To Crop An Image In Google Sheets

In this tutorial, you will learn how to crop an image in google sheets.

While Google Sheets has made some serious progress over the years, there are still certain pretty basic features that aren’t fully implemented. One of these features is cropping images within Google Sheets. While it’s possible to insert images into Google Sheets, at the time of this writing, there’s no way to crop images actually within Google Sheets. Don’t worry though, this doesn’t mean you need fancy image editing software or a degree in graphic design to get cropped images into Google Sheets. This tutorial will cover a workaround for using Google Docs to get cropped images into Google Sheets

Cropping the Image in Google Docs

The first step is to crop the image in Google Docs. If you already know how to do this, you can skip this step.

Step 1

Open a blank Google Docs file and insert the image by opening the Insert menu, hovering over Image and choosing where to find the image

Step 2

Click on the image once to select it, then double-click to enter cropping mode. Black handles will appear at the corners of the image

Step 3

Grab and drag the handles to crop the image as desired

Step 4

Hit enter to finalize the crop

Adding the Cropped Image to Google Sheets

Once you’ve cropped the image in Google Docs, it’s time to add it to Google Sheets. This is unfortunately not as straightforward as simply copy/pasting the image from one application to the other, but it’s not hard once you know the workaround. Just follow these steps.

Step 1

In Google Docs, select the cropped image and hit CTRL+C on Windows or CMD+C on Mac to copy it

Step 2

Open the Google Sheet you want to add the image to, then open the Insert menu and choose Drawing

Step 3

In the Drawing Editor, hit CTRL+V on Windows or CMD+V on Mac to paste the cropped image

Step 4

Click Save and Close in the upper-right corner

Step 5

The cropped image will be inserted into your spreadsheet. Drag and drop to position it as needed


Example Spreadsheet: Make a copy of the example spreadsheet, and Document

In this tutorial, I covered how to crop an image in google sheets. Want more? Check out all the Google Sheets Tutorials.