In this tutorial, we will learn How to crop image in google sheets.
How to Crop Image in Google Sheets ( Overview of steps )
- Open Google Docs and upload an image.
- Start the cropping mode.
- Crop the image
- Finalize the crop
- Copy the Cropped image
- Open Google Sheets where you need to insert the image
- Click on the Insert menu and select the Drawing option from the drop-down
- Paste the image into the Drawing Canvas
- Save the image
- Cropped Image inserted into Google Sheet.
To crop an image in Google Sheets, first, upload the image in Google docs, enter the crop mode by selecting the image and clicking on the crop tool from the utility menu. Now Open Google sheets Click on Insert->Drawing and paste the copied cropped image, Click on “Save and Close”
Let’s go through the above steps in detail.
How to Crop Image in Google Sheets: Step by Step Guide
Enclosed are the steps to Crop images in Google Sheets.
Step 1: Open Google Docs and upload an image.
To get started first we need to upload an image in Google Docs.
To Upload an image in google docs follow the below steps.
- Open Google docs
- Click on the insert menu on the Main menu bar
- From the drop-down Select image
- Now Under image select the source from where you need to upload the image. You have various options to upload the image such as “Upload from Computer”,”Search the web”,”Drive”,”Photos”,”By URL” or “Camera.
Step 2: Start the cropping mode.
- Once the image is uploaded, Click on the image to select it.
- Now Navigate to the quick access toolbar and click on the “crop image” icon
You can also enter the crop mode by selecting the image and then double-clicking on it.
Once the crop mode is enabled adjust the image as per your requirement.
Step 3: Crop the image
Crop the image as per your requirement by dragging the corners of the image as shown below.
Step 4: Finalize the crop
Once you are done with cropping to finalize the crop, simply click any outside the image on Google Docs.
Now we will upload this cropped image to Google Sheets. Follow the next steps
Step 5: Copy the Cropped image
Click on the cropped image to Select it, then Right Click and Select Copy
You can also use the keyboard Shortcuts using the key combination CTRL+C on your Keyboard.
Windows : CTRL+C Mac : CMD+C
Step 6: Open Google Sheets where you need to insert the image
Step 7: Click on the Insert menu and select the Drawing option from the drop-down
Insert->Drawing
Step 8: Paste the image into the Drawing Canvas
Once you click on the Drawing option under Insert, a drawing canvas will pop up.
Click anywhere inside the Drawing canvas, right-click and Select
You can also use the keyboard shortcut by using the key combination CTRL+V on windows pc or CMD+V on Mac to paste the image copied from Google docs.
Step 9: Save the image.
Now click on the “Save and Close” button on the top right of the Drawing Canvas to save and close the drawing editor.
Step 10: Cropped Image inserted into Google Sheet.
Once you click on “Save and Close” your cropped image will be inserted into Google Sheets. You can adjust its position by using drag and drop.
How to Crop Image in Google Sheets (Summary)
In the preceding tutorial, we have shown you how easily you can crop an image in Google docs and then insert the cropped image into your Google Sheets.
We hope this tutorial on How to Crop Image in Google Sheets was helpful.
Related articles :
How To Transpose Data in Google Sheets
How to count non-empty cells in google sheets
