{"id":881,"date":"2014-11-17T12:54:44","date_gmt":"2014-11-17T11:54:44","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=881"},"modified":"2022-08-15T16:00:54","modified_gmt":"2022-08-15T14:00:54","slug":"excel-copier-coller-uniquement-les-cellules-visibles","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/11\/excel-copier-coller-uniquement-les-cellules-visibles\/","title":{"rendered":"Excel &#8211; Copier-coller uniquement les cellules visibles"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous travaillez sur une feuille de calcul dont vous avez masqu\u00e9 des colonnes. Vous aimeriez faire un copier-coller du tableau (par exemple pour l&rsquo;ins\u00e9rer dans un nouveau classeur). Vous ne souhaitez pas inclure les colonnes masqu\u00e9es car celles-ci ne doivent pas figurer sur la copie (info confidentielle, note perso&#8230; \u00e0 vous de voir pourquoi). En r\u00e9sum\u00e9, vous n&rsquo;aimeriez copier que les colonnes visibles du tableau.<\/p>\n<p><strong>Solution<\/strong><\/p>\n<ul>\n<li>S\u00e9lectionnez le tableau \u00e0 copier (en conservant les colonnes masqu\u00e9es)<\/li>\n<li>Appuyez sur la touche F5 laquelle ouvre la bo\u00eete de dialogue Atteindre<\/li>\n<li>Cliquez sur le bouton Cellules puis choisissez l&rsquo;option Cellules visibles uniquement<\/li>\n<li>Cliquer sur OK<\/li>\n<li>Appuyez sur Cmd + C<\/li>\n<li>Cliquez sur la cellule o\u00f9 vous souhaitez coller le tableau (dans le m\u00eame classeur, dans un autre onglet ou dans un nouveau classeur)<\/li>\n<li>Appuyez sur Cmd + V<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous travaillez sur une feuille de calcul dont vous avez masqu\u00e9 des colonnes. Vous aimeriez faire un copier-coller du tableau (par exemple pour l&rsquo;ins\u00e9rer dans un nouveau&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3798,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"footnotes":""},"categories":[4],"tags":[54,19],"class_list":["post-881","post","type-post","status-publish","format-standard","has-post-thumbnail","category-excel","tag-collage-special","tag-tableau"],"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/881","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=881"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/881\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3798"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}