{"id":12352,"date":"2024-09-16T06:53:50","date_gmt":"2024-09-16T04:53:50","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=12352"},"modified":"2024-08-31T19:42:37","modified_gmt":"2024-08-31T17:42:37","slug":"excel-inserer-une-image-ou-un-logo-dans-une-cellule","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=12352","title":{"rendered":"EXCEL : ins\u00e9rer une image ou un logo dans une cellule"},"content":{"rendered":"<p style=\"text-align: justify;\">Une image vaut mille mots.. Excel reprend pour lui cet adage avec la <strong>fonction IMAGE<\/strong>.<\/p>\n<p style=\"text-align: justify;\">En effet, la fonction IMAGE <strong>ins\u00e8re des images dans des cellules<\/strong> \u00e0 partir d\u2019un emplacement source et <strong>am\u00e9liore visuellement la pr\u00e9sentation<\/strong> et la lisibilit\u00e9 <strong>de liste de donn\u00e9es<\/strong>. Il est ensuite possible de trier, filtre et utiliser des images dans un tableau Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12371\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/03\/Excel-fonction-Image.png\" alt=\"Excel fonction Image\" width=\"413\" height=\"407\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/03\/Excel-fonction-Image.png 413w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/03\/Excel-fonction-Image-300x296.png 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Syntaxe<\/strong> de la fonction IMAGE :<\/p>\n<p style=\"text-align: center;\">=IMAGE(source, [texte alternatif], [dimensions], [hauteur], [largeur])<\/p>\n<p style=\"text-align: justify;\"><strong>Arguments<\/strong> de la fonction IMAGE :<\/p>\n<p><em>Obligatoire :<\/em><\/p>\n<ul>\n<li style=\"text-align: justify;\">source : chemin d\u2019acc\u00e8s \u00e0 l\u2019URL du fichier image (principaux formats pris en charge : BMP, JPG\/JPEG, GIF, TIFF, PNG&#8230;).<\/li>\n<\/ul>\n<p><em>Facultatifs :<\/em><\/p>\n<ul>\n<li style=\"text-align: justify;\">texte alternatif : texte de remplacement qui d\u00e9crit l\u2019image (s&#8217;affiche si l&#8217;image n&#8217;est pas disponible).<\/li>\n<li style=\"text-align: justify;\">dimensions : sp\u00e9cifie les dimensions de l\u2019image. Valeurs possibles :\n<ul>\n<li>0 : Ajuster l\u2019image dans la cellule et conserver ses proportions.<\/li>\n<li>1 : Remplir la cellule avec l\u2019image et ignorer ses proportions.<\/li>\n<li>2 : Conserver la taille de l\u2019image d\u2019origine, qui peut d\u00e9passer les limites de la cellule.<\/li>\n<li>3 : Personnaliser la taille de l\u2019image \u00e0 l\u2019aide des arguments hauteur et largeur.<\/li>\n<\/ul>\n<\/li>\n<li>hauteur : hauteur personnalis\u00e9e de l\u2019image, en pixels.<\/li>\n<li>largeur : largeur personnalis\u00e9e de l\u2019image, en pixels.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?page_id=11012\">d\u00e9couvrir l\u2019analyse de donn\u00e9es et l\u2019automatisation des t\u00e2ches avec Excel<\/a>\u2026<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%3A%20ins%C3%A9rer%20une%20image%20ou%20un%20logo%20dans%20une%20cellule\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Une image vaut mille mots.. Excel reprend pour lui cet adage avec la fonction IMAGE. En effet, la fonction IMAGE ins\u00e8re des images dans des cellules \u00e0 partir d\u2019un emplacement source et am\u00e9liore visuellement la pr\u00e9sentation et la lisibilit\u00e9 de liste de donn\u00e9es. Il est ensuite possible de trier, filtre et utiliser des images dans &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=12352\" class=\"more-link\">Continue reading &lsquo;EXCEL : ins\u00e9rer une image ou un logo dans une cellule&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%3A%20ins%C3%A9rer%20une%20image%20ou%20un%20logo%20dans%20une%20cellule\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,1326],"tags":[3269,1633,3270,2882,3084,813,3085,3271],"class_list":["post-12352","post","type-post","status-publish","format-standard","hentry","category-excel","category-maitriser-excel","tag-bmp","tag-excel","tag-gif","tag-image","tag-jpeg","tag-logo","tag-png","tag-tiff"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12352"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12352\/revisions"}],"predecessor-version":[{"id":12551,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12352\/revisions\/12551"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}