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
Summary
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.