DEV Community

Cover image for Insert Image In The Google Sheets Using 2 Ways
divyanshdoprogramming
divyanshdoprogramming

Posted on

Insert Image In The Google Sheets Using 2 Ways

In this article, I am gonna write about how one can add an image in google sheets using 2 different ways or approaches to insert an image on google sheets

Using Insert Option

Image can be inserted using the “Insert” option available on the top under the document name after clicking on the insert button click on “Image” and choose from the two options available as per the need then it will ask for the image, now one can upload the image, paste the image link, click using the camera, import it from Photos, or do a google image search.

Step 1:

Step 1

Step 2:

Step 2

Step 3:

Step 3

Using INSERT Function

Using the IMAGE function it will take the URL and put the image inside the cell one wants to, After typing IMAGE as a function it will show a few arguments which one can pass, in which URL is mandatory to use so to use the IMAGE function write =IMAGE(“{Image Link}”) Link should be inside “ ” then one can also use different modes which means

Image description

Image description

Resize Image To Fit Inside The Cell :  =IMAGE(“URL”,1)
Enter fullscreen mode Exit fullscreen mode
Image Will Fill The Complete Cell : =IMAGE(“URL”,2)
Enter fullscreen mode Exit fullscreen mode
Original Size : =IMAGE(“URL”,3)
Enter fullscreen mode Exit fullscreen mode

Top comments (0)