{"id":268175,"date":"2021-06-06T17:24:44","date_gmt":"2021-06-06T14:24:44","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-insert-an-image-in-a-cell-in-google-sheets\/"},"modified":"2021-06-06T17:24:44","modified_gmt":"2021-06-06T14:24:44","slug":"how-to-insert-an-image-in-a-cell-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-insert-an-image-in-a-cell-in-google-sheets\/","title":{"rendered":"#How to Insert an Image in a Cell in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a27ebcb4b234\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a27ebcb4b234\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-an-image-in-a-cell-in-google-sheets\/#Quickly_Insert_an_Image_in_a_Cell\" >Quickly Insert an Image in a Cell<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-an-image-in-a-cell-in-google-sheets\/#Use_the_Image_Function_to_Add_an_Image_to_a_Cell\" >Use the Image Function to Add an Image to a Cell<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Insert an Image in a Cell in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-730939\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-logo-blue-gradient-hero.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets logo against a blue gradient background.\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Spreadsheets don\u2019t always have to look like a solid wall of text. You can break that monotony by adding some images to your cells in Google Sheets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Quickly_Insert_an_Image_in_a_Cell\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_QuickInsertImage\">Quickly Insert an Image in a Cell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Google Sheets has a really simple way to insert an image in a cell. First, go to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">https:\/\/docs.google.com\/spreadsheets\/<\/a> and open any spreadsheet.\u00a0Now, click any blank cell in the spreadsheet and go to Insert &gt; Image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730912\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-insert-menu-image.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click any blank cell in the spreadsheet and go to Insert &gt; Image.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Since our goal is to add a picture inside the selected cell, let\u2019s select \u201cImage in Cell.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730913\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-insert-image-in-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Image in Cell&quot; after you go to Insert &gt; Image in Google Sheets.\" width=\"650\" height=\"200\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This opens an image selection pop-up with a lot of options. We\u2019ll quickly walk you through all of these so that you can pick the one that\u2019s best for you. To upload a file from your computer, click the \u201cUpload\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730922\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-upload-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;Upload&quot; tab in Google Sheets.\" width=\"650\" height=\"200\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now, click the blue \u201cBrowse\u201d button that appears once you select the \u201cUpload\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-730919 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-click-browse.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the browse button on the Upload tab\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can now easily navigate to any file on your computer and double-click to upload it to the selected cell in Google Sheets.<\/p>\n<p>To take a picture using a webcam, click \u201cCamera.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-730921 alignnone\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-click-camera.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;Camera&quot; tab to take a photo in Google Sheets.\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Hit the yellow camera icon in the \u201cCamera\u201d tab when you\u2019re ready to take a picture.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730920\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-click-camera-icon.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, you can click \u201cInsert,\u201d which is located to the right of the camera icon, to add the image to your spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730918\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-camera-click-insert.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Insert&quot; to add a picture inside a cell in Google Sheets.\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the \u201cBy URL\u201d tab to import an image using its URL.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730917\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-by-url.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;By URL&quot; to add an image using its link in Google Sheets.\" width=\"650\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Paste the link in the text box in the \u201cBy URL\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730916\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-by-url-paste-link.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Paste the Image URL in Google Sheets.\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you\u2019ve done that, click \u201cInsert Image\u201d to add it to your sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730915\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-by-url-insert-image.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Insert Image&quot; to add a picture inside a cell in Google Sheets.\" width=\"650\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The \u201cPhotos\u201d tab lets you select images saved to Google Photos. When you click \u201cPhotos,\u201d you will quickly see a list of all the photos stored in your Google Photos.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730927\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-photos-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;Photos&quot; tab in Google Sheets.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click any picture to select it from the \u201cPhotos\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730926\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-photos-tab-select-photo.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select an image from Google Photos inside Google Sheets.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, click the blue \u201cInsert\u201d button near the bottom of the pop-up to add it to the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730925\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-photos-tab-select-photo-click-insert.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Insert&quot; to add the image to a cell in Google Sheets.\" width=\"650\" height=\"100\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also navigate to the \u201cGoogle Drive\u201d tab to select images from your cloud storage account. When you click \u201cGoogle Drive,\u201d you\u2019ll have to select the folder where you\u2019ve stored all images.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730931\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-insert-image-google-drive.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Google Drive&quot; to select images from there for Google Sheets.\" width=\"650\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you\u2019ve done that, click any photo to select it, and then hit \u201cInsert\u201d to add it to the selected cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730930\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-image-google-drive-click-insert.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the image from Google Drive and click &quot;Insert&quot; to add it to a cell in Google Sheets.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Finally, you can select \u201cGoogle Image Search\u201d and use the \u201cSearch for Images\u201d text box at the top to look for images from the internet. You can type any search query here as you would on Google search.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730934\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-click-google-image-search-search.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the search box to find an image from Google Images within Google Sheets.\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The next step is to click the image that you want to select, and finally, you can hit \u201cInsert.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730933\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-click-google-image-search-select.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Double-click the image you want to insert in a cell inside Google Sheets.\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you use this method to add photos to your Google Sheets document, the images will automatically scale to fit inside the selected cells. The scaling is proportional, so you don\u2019t need to worry about the aspect ratio getting messed up.<\/p>\n<p>However, if your cells are too small, the images will barely be visible, so you will have to adjust the size of the cell to ensure that the image is big enough to see.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730935\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-image-in-cell-barely-visible.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Images added to cells in Google Sheets automatically scale to the size of the cell, leading to barely visible images sometimes.\" width=\"650\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can easily do this by moving your mouse pointer to the bar above or below the row number on the extreme left side of the spreadsheet.\u00a0Make sure that the mouse pointer turns into an up arrow icon and drag it up or down to adjust the size of the row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730938\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-adjust-row-size.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Adjust the row size in Google Sheets.\" width=\"650\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Similarly, you can drag the mouse pointer to the separators between two columns at the top of the spreadsheet. Columns are denoted by alphabets in Google Sheets.\u00a0Once the mouse pointer has turned into a right arrow, click and drag it to adjust the size of the column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730937\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-adjust-column-size.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Adjust the column size in Google Sheets.\" width=\"650\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As the size of the cell increases or decreases, you\u2019ll see that the image automatically scales to fit the dimensions of the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730936\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-scaled-image-in-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A large image inside a cell in Google Sheets.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Use_the_Image_Function_to_Add_an_Image_to_a_Cell\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_ImageFunction\">Use the Image Function to Add an Image to a Cell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The Image function offers another way to insert images inside cells in Google Sheets. This method is a bit more complex, but it also offers an additional degree of customizability by letting you choose the size of the image inside the cell.<\/p>\n<p>First, let\u2019s go to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">https:\/\/docs.google.com\/spreadsheets\/<\/a> and open any spreadsheet. Now, select any cell and go to the menu above the spreadsheet and navigate to Insert &gt; Function &gt; Google.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730910\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-insert-function-google.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select any cell and go to Insert &gt; Function &gt; Google.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To insert images inside a cell in Google Sheets, click \u201cImage.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730909\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-insert-function-google-image.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Image&quot; to use the Image function in Google Sheets.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a pop-up that shows you the syntax for the Image function and tells you what each parameter does. The syntax looks something like this:<code\/><\/p>\n<p><code>=IMAGE(url, [mode], [height], [width])<\/code><\/p>\n<p>Let\u2019s quickly take a look at what each of these parameters means and how to use them. The URL parameter is the most important, since the function will break if you don\u2019t add any value to this parameter. You can copy the link to any image from the internet and paste it here. If you\u2019re using an image URL, be sure to wrap it in quote marks, like this:<\/p>\n<p><code>=IMAGE(\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/08\/new-design-social-coverphoto.png\")<\/code><\/p>\n<p>You can select any cell and paste the syntax into the formula bar, which is located between the menu and the alphabets indicating column names.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730908\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-formula-bar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The formula bar in Google Sheets.\" width=\"650\" height=\"200\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You should remember that Google Sheets doesn\u2019t allow you to use Google Drive links with the Image function. Another thing to note is that SVG format images will not work with this function.<\/p>\n<p>All other parameters are optional, but they\u2019re quite useful, so we\u2019ll quickly explain what they do. The [mode] parameter lets you decide the size of the image, and it can only have one of four values:<\/p>\n<ul>\n<li><strong>1:<\/strong> This resizes the image to automatically fit inside the dimensions of the cell without disturbing the aspect ratio of the picture. This sizing mode is selected by default and will be automatically applied even if you don\u2019t add any value for the [mode] parameter.<\/li>\n<li><strong>2:<\/strong> This will stretch or shrink the image to make it fit the cell, and it\u2019ll distort the aspect ratio.<\/li>\n<li><strong>3:<\/strong> This sizing mode keeps the image in its original size. It doesn\u2019t change the size of the cell in Google Sheets, so you\u2019ll have to manually adjust the cell\u2019s dimensions to show the full image.<\/li>\n<li><strong>4:<\/strong> If you want to use custom dimensions for your image, this is the sizing mode that you must use.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730911\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-image-function-syntax-screenshot.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"125\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Here\u2019s how you can correctly use the first three sizing modes:<\/p>\n<p><code>=IMAGE(\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/08\/new-design-social-coverphoto.png\", 1)<\/code><\/p>\n<p>You can replace the number 1 with either 2 or 3 depending on the sizing mode that you want to use. To use the fourth sizing mode, the height and width parameters will also have to be specified. The Image function measures height and width in pixels, and here\u2019s an example of the correct syntax for this:<\/p>\n<p><code>=IMAGE(\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/08\/new-design-social-coverphoto.png\", 4, 1500, 500)<\/code><\/p>\n<p>Note that 1,500 is the width in pixels and that 500 is the height. We\u2019re using it in this order because that\u2019s what the Google Sheets syntax specifies.<\/p>\n<p>Once you master these methods, adding images inside cells in Google Sheets will become really easy. Good luck!<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/730887\/how-to-insert-an-image-in-a-cell-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Insert an Image in a Cell in Google Sheets&#8221; Spreadsheets don\u2019t always have to look like a solid wall of text. You can break that monotony by adding some images to your cells in Google Sheets. Quickly Insert an Image in a Cell Google Sheets has a really simple way to insert an&#8230;<\/p>\n","protected":false},"author":1,"featured_media":268176,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-logo-blue-gradient-hero.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-268175","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/268175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=268175"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/268175\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/268176"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=268175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=268175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=268175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}