{"id":636,"date":"2022-05-18T19:13:11","date_gmt":"2022-05-18T13:43:11","guid":{"rendered":"https:\/\/sheetstips.com\/?p=636"},"modified":"2022-05-21T12:44:30","modified_gmt":"2022-05-21T07:14:30","slug":"insert-image-cell-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/insert-image-cell-google-sheets\/","title":{"rendered":"How to Insert an Image in a Cell in Google Sheets (Add\/Customize\/Delete)"},"content":{"rendered":"<p>There are multiple methods with the help of which one can insert an image in a Cell. In this article, let&#8217;s discuss Layman&#8217;s method as well as the Image function method to insert an image in the Google Sheets. Along with this, we will also discuss <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheet tips<\/a><\/strong> on how to replace, resize and move an inserted image. Read on to find more.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#How-to-Add-an-Image-to-a-Google-Spreadsheet?\">How to Add an Image to a Google Spreadsheet? (Easy Method)<\/a><\/li>\n<li><a href=\"#Using-Function-to-Add-an-Image-Syntax\">Using Function to Add an Image &#8211; Syntax<\/a><\/li>\n<li><a href=\"#How-to-Add-an-Image-using-Image-Function?\">How to Add an Image using Image Function?<\/a><\/li>\n<li><a href=\"#How-to-Move-an-Image-on-Google-Sheets?\">How to Move an Image on Google Sheets?<\/a><\/li>\n<li><a href=\"#How-to-Add-Alternative-Text-and-Description-to-an-Image?\">How to Add Alternative Text and Description to an Image?<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"How-to-Add-an-Image-to-a-Google-Spreadsheet?\">How to Add an Image to a Google Spreadsheet? (Layman&#8217;s Method)<\/h2>\n<p>Follow the steps as listed below to add an image to the Google Sheets:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet where you would like to insert an image.<\/li>\n<li><strong>Step 2:<\/strong> Move to the cell where you would like to insert an image.<\/li>\n<li><strong>Step 3:<\/strong> Now move to the menubar and click on the &#8220;<strong>Insert<\/strong>&#8221; tab.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-641 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets2.png\" alt=\"insert-image-cell-google-sheets\" width=\"908\" height=\"511\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets2.png 908w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets2-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets2-768x432.png 768w\" sizes=\"(max-width: 908px) 100vw, 908px\" \/><\/p>\n<ul>\n<li><strong>Step 4:<\/strong> Place your image in the cell or on top of the cells by clicking the provided important. Cells having an image cannot also have text in them, and the reverse is likewise true.<\/li>\n<li><strong>Step 5:<\/strong> Choose the image from your device.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-640 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets3.png\" alt=\"insert-image-cell-google-sheets\" width=\"785\" height=\"481\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets3.png 785w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets3-300x184.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets3-768x471.png 768w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/p>\n<ul>\n<li><strong>Step 6:<\/strong> Click on &#8220;<strong>Open<\/strong>&#8221; and &#8220;<strong>Select<\/strong>&#8220;. The image will be inserted into the device.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-639 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets4.png\" alt=\"insert-image-cell-google-sheets\" width=\"275\" height=\"147\" \/><\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-indents-in-google-sheets\/\">How To Insert Indents in Google Sheets? \u2013 Know How to Tab Down in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-bullets-in-google-sheets\/\">How to Insert Bullets in Google Sheets: Adding Bullets in MAC, IOS, Android<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-extract-year-from-google-sheets\/\">How to Extract the Year from Google Sheets-YEAR Function in Google Sheets<\/a><\/li>\n<\/ul>\n<h3 id=\"Using-Function-to-Add-an-Image-Syntax\">Using Function to Add an Image &#8211; Syntax<\/h3>\n<p>We can also add an image to the required cell in Google Sheets by using the Image function. The syntax for adding the Image function is explained below:<\/p>\n<blockquote><p><strong><em><span style=\"color: #ff0000;\">IMAGE(url, [mode], [height], [width])<\/span><\/em><\/strong><\/p><\/blockquote>\n<p>There are two optional arguments: URL and Mode.<\/p>\n<ul>\n<li><strong>URL:<\/strong> The URL specifies the URL of the picture to be entered in the cell. In this case, there are four numbers that can be used:<\/li>\n<li><strong>Mode:<\/strong> This method reduces the size of the image such that it will fit in the cell while keeping its aspect ratio.\n<ul>\n<li><strong>Mode [1] Size to Fit:<\/strong> 1 maintains the aspect ratio while resizing the image to fit inside the cell. If you leave the mode argument blank, it defaults to 1.<\/li>\n<li><strong>Mode [2] Stretch to Fit:<\/strong> 2 ignores aspect ratio and extends or compresses the image to fit inside the cell.<\/li>\n<li><strong>Mode [3] Original Size:<\/strong> 3 keeps the image at its original dimensions, which may result in cropping.<\/li>\n<li><strong>Mode [4] Custom Size:<\/strong> Custom size can be specified in version 4.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Height<\/strong> \u2013 If the mode parameter is set to 4, you can use this argument to indicate the image&#8217;s height in pixels.<\/li>\n<li><strong>Width<\/strong> \u2013 If the mode parameter is 4, this argument can be used to indicate the image&#8217;s width in pixels.<\/li>\n<\/ul>\n<h3 id=\"How-to-Add-an-Image-using-Image-Function?\">How to Add an Image using Image Function?<\/h3>\n<p>Follow the steps listed below to add the images using the image function.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet where you would like to insert an image.<\/li>\n<li><strong>Step 2:<\/strong> Then move to the cell where you would like to insert an image. Make sure you are having the URL of the image which needs to be pasted.<\/li>\n<li><strong>Step 3:<\/strong> Now enter the formula =&#8221;<strong><em><span style=\"color: #ff0000;\">IMAGE(url, [mode], [height], [width])<\/span><\/em><\/strong><em><span style=\"color: #ff0000;\"><span style=\"color: #000000;\">&#8220;.\u00a0<\/span><\/span><\/em><span style=\"color: #ff0000;\"><span style=\"color: #000000;\">In our case the formula is <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">IMAGE<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" string \" dir=\"auto\">&#8220;https:\/\/www.google.com\/logos\/doodles\/2016\/first-day-of-school-2016-5187470943584256-hp2x.jpg&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">1&#8243;<\/span>).<\/span><\/span><\/li>\n<li><strong>Step 4:<\/strong> Press the &#8220;<strong>Enter<\/strong>&#8221; button. You will see the results.<\/li>\n<li><strong>Step 5:<\/strong> Now to change the Mod of the image, use different types of modes as mentioned above in the syntax.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-637 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets.png\" alt=\"insert-image-cell-google-sheets\" width=\"849\" height=\"141\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets.png 849w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets-300x50.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets-768x128.png 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/p>\n<h3 id=\"How-to-Move-an-Image-on-Google-Sheets?\">How to Move an Image on Google Sheets?<\/h3>\n<p>The steps to move an image on Google Sheets are explained below:<\/p>\n<ul>\n<li>Use cut and paste to move an image from one cell to another.<\/li>\n<li>Click and drag an image that is over the cells to move it.<\/li>\n<li>To move an image from within a cell to outside of the cells, right-click the image and select Put Image over cells.<\/li>\n<li>To move an image from above the cells to inside a cell, do the following:\n<ul>\n<li>Click in the cell where you want the image to go.<\/li>\n<li>Click the image, then More \u2192 and finally Place the image in the selected cell.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 id=\"How-to-Add-Alternative-Text-and-Description-to-an-Image?\">How to Add Alternative Text and Description to an Image?<\/h3>\n<p>Follow the steps as listed below to add the Alternative text and description to an Image in the Google Sheets:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet where you would like to insert the Alt text and Description for an image.<\/li>\n<li><strong>Step 2:<\/strong> Now Right-click on the Image. Then select Alt text from the drop-down menu.<\/li>\n<li><strong>Step 3:<\/strong> Then add the Alternative text.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-638 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets5.png\" alt=\"insert-image-cell-google-sheets\" width=\"916\" height=\"516\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets5.png 916w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets5-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/insert-an-image-in-google-sheets5-768x433.png 768w\" sizes=\"(max-width: 916px) 100vw, 916px\" \/><\/p>\n<p>You can also right-click the image and select the More option to add an alternative text to the image.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are multiple methods with the help of which one can insert an image in a Cell. In this article, let&#8217;s discuss Layman&#8217;s method as well as the Image function method to insert an image in the Google Sheets. Along with this, we will also discuss Google Sheet tips on how to replace, resize and &#8230; <a title=\"How to Insert an Image in a Cell in Google Sheets (Add\/Customize\/Delete)\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/insert-image-cell-google-sheets\/\" aria-label=\"More on How to Insert an Image in a Cell in Google Sheets (Add\/Customize\/Delete)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[138],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":2333,"url":"https:\/\/sheetstips.com\/how-to-insert-indents-in-google-sheets\/","url_meta":{"origin":636,"position":0},"title":"How To Insert Indents in Google Sheets? &#8211; Know How to Tab Down in Google Sheets","author":"Varsha","date":"May 16, 2022","format":false,"excerpt":"Formatting is equally essential as the data presented in a spreadsheet. Bad formatting with useful data may not attract users since bad formatting makes users difficult to read. Thus, formatting plays a major role in presenting data to users. Though there are multiple in-built format options available in Google Sheets,\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"How To Insert Indents in Google Sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/How-To-Insert-Indents-in-Google-Sheets7.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3438,"url":"https:\/\/sheetstips.com\/insert-line-break-in-google-sheets\/","url_meta":{"origin":636,"position":1},"title":"How To Insert Line Break in Google Sheets? &#8211; Create New Line in Same Cell","author":"Varsha","date":"June 16, 2022","format":false,"excerpt":"Inserting a line break in Google Sheets is quite tricky since it doesn't have any inbuilt feature or function for the same. However, with the help of various functions and keyboard shortcuts, we can easily make text go to the next line in Google Sheets. There are\u00a0multiple methods with the\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"insert-line-breaks3","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/insert-line-breaks1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2130,"url":"https:\/\/sheetstips.com\/how-to-repeat-images-with-an-array-formula-in-google-sheets\/","url_meta":{"origin":636,"position":2},"title":"How to Repeat Images With an Array Formula in Google Sheets? Repeating Images with a Single Formula","author":"Varsha","date":"December 5, 2022","format":false,"excerpt":"With the help of Google Sheets, one of the great collaboration tools, we can perform marvelous operations. The spreadsheet software developed by Google comes in really handy when we want to perform complicated operations. For example, let's assume that we want to insert an image into Google Sheets, which should\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3676,"url":"https:\/\/sheetstips.com\/insert-sheets-in-google-sheets\/","url_meta":{"origin":636,"position":3},"title":"How To Insert Sheets in Google Sheets? &#8211; 6 Ways to Insert a Sheet in Google Sheets","author":"Varsha","date":"June 27, 2022","format":false,"excerpt":"Google Sheets can have 200 sheets per workbook. So if you have fewer than 200 sheets, then you can easily insert sheets into the spreadsheet.\u00a0Inserting sheets into the existing spreadsheet is one of the most common tasks with which a user will deal. Ranging from keyboard shortcuts to Apps Script,\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"insert sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/insert-sheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1340,"url":"https:\/\/sheetstips.com\/create-a-star-rating-system-in-google-sheets\/","url_meta":{"origin":636,"position":4},"title":"How To Create Star Rating System in Google Sheets? (With Example)","author":"Varsha","date":"December 5, 2022","format":false,"excerpt":"Google Sheets is one of the great tools that is used by all types of firms right from small-scale traders to large-scale businesses. Thus Google Sheets is one of the most widely used spreadsheet software, where we can various kinds of mathematical operations, organize and store data, and much more.\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"create-a-star-rating-system-in-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/10\/create-a-star-rating-system-in-google-sheets1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":192,"url":"https:\/\/sheetstips.com\/how-to-insert-bullets-in-google-sheets\/","url_meta":{"origin":636,"position":5},"title":"How to Insert Bullets in Google Sheets: Adding Bullets in MAC, IOS, Android","author":"Varsha","date":"May 21, 2022","format":false,"excerpt":"Adding Bullets in Google Sheets: Bullets are usually a type of symbol used to highlight the items in the list. Though Google sheets come with hundreds of features, the Bullets or numbering feature is missing out. Thus one needs to add the bullets manually in order to insert bullets in\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how to add bullets in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/how-to-add-bullets-in-google-sheets-5.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/636"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=636"}],"version-history":[{"count":1,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/636\/revisions"}],"predecessor-version":[{"id":2450,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/636\/revisions\/2450"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}