{"id":883,"date":"2026-01-23T13:23:04","date_gmt":"2026-01-23T12:23:04","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=883"},"modified":"2026-01-23T13:23:06","modified_gmt":"2026-01-23T12:23:06","slug":"excel-coller-et-multiplier-en-une-seule-operation","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2026\/01\/excel-coller-et-multiplier-en-une-seule-operation\/","title":{"rendered":"Excel &#8211; Coller et multiplier en une seule op\u00e9ration"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez re\u00e7u d&rsquo;un fournisseur une feuille de calcul contenant des valeurs en euro. Vous aimeriez rapidement faire appara\u00eetre des francs suisses \u00e0 la place des euros. Vous n&rsquo;avez pas envie de toucher \u00e0 la structure du tableau (par ex. ajouter des colonnes pour y faire des calculs de conversion&#8230;.). Vous connaissez le taux de change, par ex. <span id=\"ctl00_M_grid_ctl02_lblExplain\">0.93.<\/span><\/p>\n<blockquote><p>Attention : le collage effectu\u00e9 ci-dessous va remplacer les valeurs en euros par des francs suisses<\/p><\/blockquote>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li><span class=\"chevron\">Dans l&rsquo;importe quelle cellule vide du tableau, t<\/span>apez le taux de change par ex. <span id=\"ctl00_M_grid_ctl02_lblExplain\">0.93<\/span><\/li>\n<li>Appuyez sur Cmd +\u00a0C pour copier ce taux de change<\/li>\n<li>S\u00e9lectionnez la(les) cellules(s) contenant les valeurs en euro<\/li>\n<li><span class=\"chevron\">Ouvrez le menu <strong>Edition<\/strong> &gt; <\/span><strong>Collage sp\u00e9cial<\/strong><\/li>\n<li>Choisissez <strong>Multiplication<\/strong> et validez<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez re\u00e7u d&rsquo;un fournisseur une feuille de calcul contenant des valeurs en euro. Vous aimeriez rapidement faire appara\u00eetre des francs suisses \u00e0 la place des euros.&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3801,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[54],"class_list":{"0":"post-883","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-collage-special"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=883"}],"version-history":[{"count":1,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/883\/revisions"}],"predecessor-version":[{"id":5043,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/883\/revisions\/5043"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3801"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}