{"id":25827,"date":"2026-06-25T03:44:29","date_gmt":"2026-06-25T03:44:29","guid":{"rendered":"https:\/\/umang.pk\/2026\/06\/25\/25827\/"},"modified":"2026-06-25T03:44:31","modified_gmt":"2026-06-25T03:44:31","slug":"25827","status":"publish","type":"post","link":"https:\/\/umang.pk\/en_us\/2026\/06\/25\/25827\/","title":{"rendered":""},"content":{"rendered":"\n<div id=\"\">\n<\/p>\n<ul>\n<li>\n<\/li>\n<li>\n<p> <code>IMAGE()<\/code> \u0641\u0646\u06a9\u0634\u0646<\/p>\n<\/li>\n<li>\n<\/li>\n<\/ul>\n<h2 id=\"heading-table-of-contents\">\u0627\u0646\u0688\u06cc\u06a9\u0633<\/h2>\n<h2 id=\"heading-understanding-how-images-work-in-google-sheets\"><\/h2>\n<\/p>\n<\/p>\n<h3 id=\"heading-images-inside-cells\"><\/h3>\n<\/p>\n<\/p>\n<ul>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<\/ul>\n<h3 id=\"heading-images-over-cells\"><\/h3>\n<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/06\/ecdc1248-9b8f-450a-9fab-c46bd668bcd7.png\" alt=\"\" style=\"display:block;margin:0 auto\" width=\"1500\" height=\"854\" loading=\"lazy\" title=\"\"><\/p>\n<p>\u0641\u0648\u0627\u0626\u062f \u06cc\u06c1 \u06c1\u06cc\u06ba:<\/p>\n<ul>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<\/ul>\n<p> <strong><\/strong> <\/p>\n<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/06\/b440f2e3-5773-448f-9dbc-4151cd420745.png\" alt=\"\" style=\"display:block;margin:0 auto\" width=\"1612\" height=\"480\" loading=\"lazy\" title=\"\"><\/p>\n<\/p>\n<h3 id=\"heading-image-in-cell\"><\/h3>\n<ol>\n<li>\n<p>\u06c1\u062f\u0641 \u0633\u06cc\u0644 \u0645\u0646\u062a\u062e\u0628 \u06a9\u0631\u06cc\u06ba\u06d4<\/p>\n<\/li>\n<li>\n<p>\u06a9\u0644\u06a9 \u06a9\u0631\u06cc\u06ba <strong><\/strong>.<\/p>\n<\/li>\n<li>\n<ul>\n<li>\n<\/li>\n<li>\n<p>\u06af\u0648\u06af\u0644 \u0688\u0631\u0627\u0626\u06cc\u0648<\/p>\n<\/li>\n<li>\n<p>\u06af\u0648\u06af\u0644 \u0641\u0648\u0679\u0648<\/p>\n<\/li>\n<li>\n<p>\u06a9\u06cc\u0645\u0631\u06d2<\/p>\n<\/li>\n<li>\n<p>URL<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p> <strong>\u062f\u0627\u062e\u0644 \u06a9\u0631\u06cc\u06ba<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<p><strong>\u0679\u067e:<\/strong> <\/p>\n<p><strong>\u06a9\u06d2 \u0644\u06cc\u06d2 \u0628\u06c1\u062a\u0631\u06cc\u0646 \u0645\u0648\u0632\u0648\u06ba:<\/strong><\/p>\n<p><strong><\/strong> <\/p>\n<h3 id=\"heading-image-over-cells\"><\/h3>\n<ol>\n<li>\n<p>\u06a9\u0644\u06a9 \u06a9\u0631\u06cc\u06ba <strong><\/strong>.<\/p>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<\/ol>\n<p><strong>\u06a9\u06d2 \u0644\u06cc\u06d2 \u0628\u06c1\u062a\u0631\u06cc\u0646 \u0645\u0648\u0632\u0648\u06ba:<\/strong><\/p>\n<p> <strong><\/strong> <\/p>\n<\/p>\n<h2 id=\"heading-inserting-images-in-google-sheets-using-the-image-function\"><\/h2>\n<\/p>\n<p>\u06a9\u06c1<code>IMAGE()<\/code> <\/p>\n<h3 id=\"heading-image-function-syntax\"><\/h3>\n<pre><code class=\"language-excel\">=IMAGE(url,[mode],[height],[width])\n<\/code><\/pre>\n<p>\u0627\u062e\u062a\u06cc\u0627\u0631\u06cc <strong>\u0637\u0631\u06cc\u0642\u06c1<\/strong> <\/p>\n<\/p>\n<table>\n<thead>\n<tr>\n<th>\u0637\u0631\u06cc\u0642\u06c1<\/th>\n<th>\u0633\u0631\u06a9\u0627\u0631\u06cc<\/th>\n<th>\u06a9\u0627\u0631\u0631\u0648\u0627\u0626\u06cc<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1 (\u067e\u06c1\u0644\u06d2 \u0633\u06d2 \u0637\u06d2 \u0634\u062f\u06c1)<\/td>\n<td><code>=IMAGE(A2,1)<\/code><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td><code>=IMAGE(A2,2)<\/code><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td><code>=IMAGE(A2,3)<\/code><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td><code>=IMAGE(A2,4,200,200)<\/code><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <strong>\u0645\u0648\u0688 1<\/strong> This is the best choice as it fits neatly within the cell while maintaining the image proportions. \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u06cc\u06ba <strong><\/strong> <\/p>\n<h3 id=\"heading-basic-example\">\u0628\u0646\u06cc\u0627\u062f\u06cc \u0645\u062b\u0627\u0644<\/h3>\n<pre><code class=\"language-excel\">=IMAGE(\"https:\/\/example.com\/product-image.jpg\")\n<\/code><\/pre>\n<\/p>\n<h3 id=\"heading-displaying-images-from-a-column-of-urls\"><\/h3>\n<\/p>\n<pre><code class=\"language-excel\">=IMAGE(B2)\n<\/code><\/pre>\n<\/p>\n<p><strong>\u06a9\u06d2 \u0644\u06cc\u06d2 \u0628\u06c1\u062a\u0631\u06cc\u0646 \u0645\u0648\u0632\u0648\u06ba:<\/strong><\/p>\n<h3 id=\"heading-common-issues\">\u0639\u0627\u0645 \u0645\u0633\u0627\u0626\u0644<\/h3>\n<\/p>\n<p><strong>\u0627\u062a\u06be\u0627\u0631\u0679\u06cc:<\/strong>  <strong>\u06a9\u0648\u0626\u06cc \u0628\u06be\u06cc \u062c\u0633 \u06a9\u06d2 \u067e\u0627\u0633 \u0644\u0646\u06a9 \u06c1\u06d2\u06d4<\/strong> <strong>\u062f\u06cc\u06a9\u06be \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba<\/strong>.<\/p>\n<p><strong>\u0628\u0631\u0627\u06c1 \u0631\u0627\u0633\u062a URL:<\/strong> Standard Google Drive sharing links will not work. \u0645\u06cc\u06ba \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0631\u06cc\u06ba:<\/p>\n<pre><code class=\"language-text\">https:\/\/drive.google.com\/uc?id=FILE_ID\n<\/code><\/pre>\n<p><strong>\u06a9\u0627\u0631\u06a9\u0631\u062f\u06af\u06cc:<\/strong> \u06a9\u06cc\u0648\u0646\u06a9\u06c1 <code>IMAGE<\/code> <\/p>\n<h2 id=\"heading-inserting-multiple-images-from-urls\"><\/h2>\n<p> <code>IMAGE<\/code> <\/p>\n<\/p>\n<pre><code class=\"language-excel\">=ARRAYFORMULA(IF(A2:A=\"\",\"\",IMAGE(A2:A)))\n<\/code><\/pre>\n<\/p>\n<p><strong>\u0645\u0646\u0627\u0641\u0639:<\/strong><\/p>\n<ul>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<\/ul>\n<\/p>\n<h3 id=\"heading-performance-considerations\">\u06a9\u0627\u0631\u06a9\u0631\u062f\u06af\u06cc \u06a9\u06d2 \u062a\u062d\u0641\u0638\u0627\u062a:<\/h3>\n<\/p>\n<ul>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<li>\n<\/li>\n<\/ul>\n<p><strong>\u0679\u0631\u0628\u0644 \u0634\u0648\u0679\u0646\u06af:<\/strong><\/p>\n<table>\n<thead>\n<tr>\n<th>\u0645\u0633\u0626\u0644\u06c1<\/th>\n<th>\u0645\u0645\u06a9\u0646\u06c1 \u0648\u062c\u06c1<\/th>\n<th>\u0679\u06be\u06cc\u06a9 \u06a9\u0631\u06cc\u06ba<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<td> <strong>\u06a9\u0648\u0626\u06cc \u0628\u06be\u06cc \u062c\u0633 \u06a9\u06d2 \u067e\u0627\u0633 \u0644\u0646\u06a9 \u06c1\u06d2\u06d4<\/strong><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>\u063a\u06cc\u0631 \u062a\u0639\u0627\u0648\u0646 \u06cc\u0627\u0641\u062a\u06c1 \u0641\u0627\u0631\u0645\u06cc\u0679<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>\u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u06cc\u06ba <code>uc?id=FILE_ID<\/code> \u06cc\u0627 <code>lh3.googleusercontent.com\/d\/FILE_ID<\/code><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"heading-best-practices\">\u0628\u06c1\u062a\u0631\u06cc\u0646 \u0637\u0631\u0632 \u0639\u0645\u0644<\/h2>\n<ul>\n<li>\n<p><strong><\/strong> <\/p>\n<\/li>\n<li>\n<p><strong><\/strong>  <code>=IMAGE(\"https:\/\/cdn.example.com\/products\/\" & A2 & \".jpg\")<\/code><\/p>\n<\/li>\n<li>\n<p><strong><\/strong> <\/p>\n<\/li>\n<\/ul>\n<h2 id=\"heading-working-with-multiple-images-stored-in-google-drive\"><\/h2>\n<p> <code>IMAGE<\/code> <\/p>\n<p> <code>IMAGE<\/code> \u0641\u0646\u06a9\u0634\u0646<\/p>\n<\/p>\n<h3 id=\"heading-converting-google-drive-links-into-image-previews\"><\/h3>\n<\/p>\n<pre><code class=\"language-excel\">=IMAGE(\"https:\/\/drive.google.com\/uc?export=view&id=\" & REGEXEXTRACT(A2,\"\/d\/([^\/]+)\"))\n<\/code><\/pre>\n<p> <strong><\/strong> <\/p>\n<h3 id=\"heading-working-with-large-image-libraries\"><\/h3>\n<\/p>\n<h3 id=\"heading-video-tutorial-how-to-insert-image-inside-a-cell-in-google-sheets\"><\/h3>\n<\/p>\n<h2 id=\"heading-which-method-should-you-choose\"><\/h2>\n<table>\n<thead>\n<tr>\n<th>\u06a9\u06cc\u0633\u0632 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u06cc\u06ba\u06d4<\/th>\n<th>\u062a\u062c\u0648\u06cc\u0632 \u06a9\u0631\u062f\u06c1 \u0637\u0631\u06cc\u0642\u06c1<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><\/td>\n<td>\u0645\u06cc\u0646\u0648 \u062f\u0627\u062e\u0644 \u06a9\u0631\u06cc\u06ba\u06d4<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u0645\u0635\u0646\u0648\u0639\u0627\u062a \u06a9\u06cc \u0641\u06c1\u0631\u0633\u062a<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u0627\u0646\u0648\u06cc\u0646\u0679\u0631\u06cc \u0645\u06cc\u0646\u062c\u0645\u0646\u0679<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"heading-conclusion\">\u0646\u062a\u06cc\u062c\u06c1<\/h2>\n<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>IMAGE() \u0641\u0646\u06a9\u0634\u0646 \u0627\u0646\u0688\u06cc\u06a9\u0633 \u0641\u0648\u0627\u0626\u062f \u06cc\u06c1 \u06c1\u06cc\u06ba: \u06c1\u062f\u0641 \u0633\u06cc\u0644 \u0645\u0646\u062a\u062e\u0628 \u06a9\u0631\u06cc\u06ba\u06d4 \u06a9\u0644\u06a9 \u06a9\u0631\u06cc\u06ba . \u06af\u0648\u06af\u0644 \u0688\u0631\u0627\u0626\u06cc\u0648 \u06af\u0648\u06af\u0644 \u0641\u0648\u0679\u0648 \u06a9\u06cc\u0645\u0631\u06d2 URL \u062f\u0627\u062e\u0644 \u06a9\u0631\u06cc\u06ba. \u0679\u067e: \u06a9\u06d2 \u0644\u06cc\u06d2 \u0628\u06c1\u062a\u0631\u06cc\u0646 \u0645\u0648\u0632\u0648\u06ba: \u06a9\u0644\u06a9 \u06a9\u0631\u06cc\u06ba . \u06a9\u06d2 \u0644\u06cc\u06d2 \u0628\u06c1\u062a\u0631\u06cc\u0646 \u0645\u0648\u0632\u0648\u06ba: \u06a9\u06c1IMAGE() =IMAGE(url,[mode],[height],[width]) \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u0637\u0631\u06cc\u0642\u06c1 \u0637\u0631\u06cc\u0642\u06c1 \u0633\u0631\u06a9\u0627\u0631\u06cc \u06a9\u0627\u0631\u0631\u0648\u0627\u0626\u06cc 1 (\u067e\u06c1\u0644\u06d2 \u0633\u06d2 \u0637\u06d2 \u0634\u062f\u06c1) =IMAGE(A2,1) 2 =IMAGE(A2,2) 3 =IMAGE(A2,3) 4 =IMAGE(A2,4,200,200) \u0645\u0648\u0688 1 This [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":25828,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-25827","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts\/25827","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/comments?post=25827"}],"version-history":[{"count":1,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts\/25827\/revisions"}],"predecessor-version":[{"id":25829,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts\/25827\/revisions\/25829"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/media\/25828"}],"wp:attachment":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/media?parent=25827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/categories?post=25827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/tags?post=25827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}