{"id":551,"date":"2020-04-29T22:33:16","date_gmt":"2020-04-29T20:33:16","guid":{"rendered":"https:\/\/www.echiquier-nazairien.com\/web-formation\/?page_id=551"},"modified":"2020-04-29T23:26:51","modified_gmt":"2020-04-29T21:26:51","slug":"masquer-et-afficher-des-colonnes-dans-excel","status":"publish","type":"page","link":"https:\/\/www.echiquier-nazairien.com\/web-formation\/masquer-et-afficher-des-colonnes-dans-excel\/","title":{"rendered":"Masquer et afficher des colonnes dans Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"551\" class=\"elementor elementor-551\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-51001cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"1405\" data-id=\"51001cb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-63dbf8a\" data-eae-slider=\"30463\" data-id=\"63dbf8a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-77b4731 elementor-widget elementor-widget-heading\" data-id=\"77b4731\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Excel : faire appara\u00eetre et dispara\u00eetre les colonnes<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-cfc219a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"34371\" data-id=\"cfc219a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d13ba82\" data-eae-slider=\"43139\" data-id=\"d13ba82\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ce488a3 elementor-widget elementor-widget-text-editor\" data-id=\"ce488a3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2 id=\"accroche\">Ce tutoriel pour Microsoft Excel vous pr\u00e9sente les diff\u00e9rentes m\u00e9thodes pour afficher et masquer les colonnes dans le tableur.<\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-18df3d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"8916\" data-id=\"18df3d6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d7148ca\" data-eae-slider=\"5980\" data-id=\"d7148ca\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ebb3549 elementor-widget elementor-widget-text-editor\" data-id=\"ebb3549\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Tout utilisateur d\u2019Excel a, a eu ou aura un jour la n\u00e9cessit\u00e9 de masquer une ou plusieurs colonnes. Pour y voir plus clair en all\u00e9geant l\u2019affichage des donn\u00e9es visibles, pour faire une capture d\u2019\u00e9cran en dissimulant certaines informations, pour cacher des cellules peu importantes ou obsol\u00e8tes\u2026 nombreuses sont les situations o\u00f9 ce masquage peut \u00eatre utile.<\/p><p>Pour masquer une colonne, la man\u0153uvre est un v\u00e9ritable jeu d\u2019enfant. Effectuez un <code><em><strong><span style=\"color: #800000;\">clic droit<\/span><\/strong><\/em><\/code> sur la colonne souhait\u00e9e puis cliquez sur <code><em><strong><span style=\"color: #800000;\">Masquer<\/span><\/strong><\/em><\/code>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-78e361b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"15491\" data-id=\"78e361b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-75705d1\" data-eae-slider=\"22217\" data-id=\"75705d1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e3b6d8b elementor-widget elementor-widget-image\" data-id=\"e3b6d8b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"414\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/1-masquer-colonne-excel-version-windows.jpg\" class=\"attachment-full size-full wp-image-554\" alt=\"\" srcset=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/1-masquer-colonne-excel-version-windows.jpg 600w, https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/1-masquer-colonne-excel-version-windows-300x207.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-cdc38d8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"68269\" data-id=\"cdc38d8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-93fcee1\" data-eae-slider=\"92183\" data-id=\"93fcee1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dd9bb9f elementor-widget elementor-widget-text-editor\" data-id=\"dd9bb9f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Dissimuler temporairement une colonne sous le tableur de Microsoft est une chose (simple et facilement m\u00e9morisable), mais encore faut-il savoir la faire r\u00e9appara\u00eetre. Et vous allez le voir, ce ne sont pas les techniques qui manquent. Nous en comptons au moins 3. La premi\u00e8re consiste d\u2019abord \u00e0 viser (tr\u00e8s pr\u00e9cis\u00e9ment) sur la poign\u00e9e de la colonne masqu\u00e9e. Elle est ici illustr\u00e9e tout en haut de la ligne verte que vous voyez ci-dessous.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-b18e29d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"24824\" data-id=\"b18e29d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3b20351\" data-eae-slider=\"39056\" data-id=\"3b20351\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a5edfdd elementor-widget elementor-widget-image\" data-id=\"a5edfdd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"600\" height=\"295\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/2-colonne-masquee-sous-excel.jpg\" class=\"attachment-full size-full wp-image-555\" alt=\"\" srcset=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/2-colonne-masquee-sous-excel.jpg 600w, https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/2-colonne-masquee-sous-excel-300x148.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-48bafdb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"69433\" data-id=\"48bafdb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e9c2e7e\" data-eae-slider=\"95297\" data-id=\"e9c2e7e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-97e833b elementor-widget elementor-widget-text-editor\" data-id=\"97e833b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Effectuez ensuite un <code><em><strong><span style=\"color: #800000;\">clic<\/span><\/strong> <strong><span style=\"color: #800000;\">droit<\/span><\/strong><\/em><\/code> sur cette (fine) zone puis cliquez sur <code><em><strong><span style=\"color: #800000;\">Afficher<\/span><\/strong><\/em><\/code> dans le menu contextuel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-a997eae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"3641\" data-id=\"a997eae\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-07f3862\" data-eae-slider=\"42737\" data-id=\"07f3862\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f8b83d0 elementor-widget elementor-widget-image\" data-id=\"f8b83d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"600\" height=\"394\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/3-reafficher-colonnes-masquees-microsoft-excel.jpg\" class=\"attachment-full size-full wp-image-556\" alt=\"\" srcset=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/3-reafficher-colonnes-masquees-microsoft-excel.jpg 600w, https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/3-reafficher-colonnes-masquees-microsoft-excel-300x197.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-91e80ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"39947\" data-id=\"91e80ca\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-d9fcb87\" data-eae-slider=\"40583\" data-id=\"d9fcb87\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-96a0656 elementor-widget elementor-widget-image\" data-id=\"96a0656\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"54\" height=\"76\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/005-ampoule-jaune.png\" class=\"attachment-full size-full wp-image-490\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-4674a42\" data-eae-slider=\"40268\" data-id=\"4674a42\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7f266a9 elementor-widget elementor-widget-text-editor\" data-id=\"7f266a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Deuxi\u00e8me m\u00e9thode (sans doute la plus rapide) : vous pouvez aussi placer votre curseur sur la jointure jusqu\u2019\u00e0 faire appara\u00eetre une fl\u00e8che horizontale \u00e0 2 pointes entre les 2 colonnes encadrant la colonne masqu\u00e9e. L\u00e0, tirez-la vers la droite pour l\u2019\u00e9tendre.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-3d406a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"15775\" data-id=\"3d406a5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-88df3d8\" data-eae-slider=\"16921\" data-id=\"88df3d8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7af8c4d elementor-widget elementor-widget-text-editor\" data-id=\"7af8c4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Enfin, pour la troisi\u00e8me m\u00e9thode, s\u00e9lectionnez les 2 colonnes de part et d\u2019autre de la colonne masqu\u00e9e puis allez dans l\u2019onglet <code><em><strong><span style=\"color: #800000;\">Accueil<\/span><\/strong><\/em><\/code> d\u2019Excel. Dans la section <code><em><strong><span style=\"color: #800000;\">Cellules<\/span><\/strong><\/em><\/code>, d\u00e9roulez le menu <code><em><strong><span style=\"color: #800000;\">Format<\/span><\/strong><\/em><\/code>. Dans la rubrique <code><em><strong><span style=\"color: #800000;\">Visibilit\u00e9<\/span><\/strong><\/em><\/code>, ouvrez le menu <code><em><strong><span style=\"color: #800000;\">Masquer<\/span><\/strong><\/em> &amp; <em><strong><span style=\"color: #800000;\">Afficher<\/span><\/strong><\/em><\/code> puis <code><em><strong><span style=\"color: #800000;\">Afficher les colonnes<\/span><\/strong><\/em><\/code>. Pour cet exemple, la colonne \u00ab V \u00bb r\u00e9appara\u00eetra instantan\u00e9ment.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-3ed8a74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"48917\" data-id=\"3ed8a74\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f246fb5\" data-eae-slider=\"60021\" data-id=\"f246fb5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c5d2cc elementor-widget elementor-widget-image\" data-id=\"1c5d2cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"424\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/4-visibilite-colonnes-microsoft-excel.jpg\" class=\"attachment-full size-full wp-image-557\" alt=\"\" srcset=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/4-visibilite-colonnes-microsoft-excel.jpg 600w, https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/4-visibilite-colonnes-microsoft-excel-300x212.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-3b7daf2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"56434\" data-id=\"3b7daf2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b08db0a\" data-eae-slider=\"28874\" data-id=\"b08db0a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0240acb elementor-widget elementor-widget-text-editor\" data-id=\"0240acb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Pour les utilisateurs de la version Excel sous macOS, d\u00e9couvrez notre memo :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-720dfef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"80385\" data-id=\"720dfef\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ef4750\" data-eae-slider=\"48879\" data-id=\"3ef4750\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5a39cf9 elementor-widget elementor-widget-heading\" data-id=\"5a39cf9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Gestion affichage colonnes sous Excel version macOS<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-0acb7f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"74164\" data-id=\"0acb7f9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1ac55f3\" data-eae-slider=\"56757\" data-id=\"1ac55f3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5585b92 elementor-widget elementor-widget-image-gallery\" data-id=\"5585b92\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image-gallery.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-image-gallery\">\n\t\t\t<div id='gallery-1' class='gallery galleryid-551 gallery-columns-3 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"5585b92\" data-elementor-lightbox-title=\"1 - S\u00e9lectionnez la colonne puis \u00ab Masquer \u00bb via clic droit\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NTU4LCJ1cmwiOiJodHRwczpcL1wvd3d3LmVjaGlxdWllci1uYXphaXJpZW4uY29tXC93ZWItZm9ybWF0aW9uXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDIwXC8wNFwvNS1jYXB0dXJlLWRlY3Jhbi0yMDE3LTAxLTEzLWEtMjIuanBnIiwic2xpZGVzaG93IjoiNTU4NWI5MiJ9\" href='https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/5-capture-decran-2017-01-13-a-22.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/5-capture-decran-2017-01-13-a-22-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" aria-describedby=\"gallery-1-558\" \/><\/a>\n\t\t\t<\/div>\n\t\t\t\t<figcaption class='wp-caption-text gallery-caption' id='gallery-1-558'>\n\t\t\t\t1 &#8211; S\u00e9lectionnez la colonne puis \u00ab Masquer \u00bb via clic droit\n\t\t\t\t<\/figcaption><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"5585b92\" data-elementor-lightbox-title=\"2 - Pour afficher la colonne masqu\u00e9e, s\u00e9lectionnez les 2\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NTU5LCJ1cmwiOiJodHRwczpcL1wvd3d3LmVjaGlxdWllci1uYXphaXJpZW4uY29tXC93ZWItZm9ybWF0aW9uXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDIwXC8wNFwvNi1jYXB0dXJlLWRlY3Jhbi0yMDE3LTAxLTEzLWEtMjIuanBnIiwic2xpZGVzaG93IjoiNTU4NWI5MiJ9\" href='https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/6-capture-decran-2017-01-13-a-22.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/6-capture-decran-2017-01-13-a-22-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" aria-describedby=\"gallery-1-559\" \/><\/a>\n\t\t\t<\/div>\n\t\t\t\t<figcaption class='wp-caption-text gallery-caption' id='gallery-1-559'>\n\t\t\t\t2 &#8211; Pour afficher la colonne masqu\u00e9e, s\u00e9lectionnez les 2 colonnes voisines\n\t\t\t\t<\/figcaption><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"5585b92\" data-elementor-lightbox-title=\"3 - Puis menu Mise en forme - Colonne - Afficher\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NTYwLCJ1cmwiOiJodHRwczpcL1wvd3d3LmVjaGlxdWllci1uYXphaXJpZW4uY29tXC93ZWItZm9ybWF0aW9uXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDIwXC8wNFwvNy1jYXB0dXJlLWRlY3Jhbi0yMDE3LTAxLTEzLWEtMjIuanBnIiwic2xpZGVzaG93IjoiNTU4NWI5MiJ9\" href='https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/7-capture-decran-2017-01-13-a-22.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-content\/uploads\/2020\/04\/7-capture-decran-2017-01-13-a-22-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" aria-describedby=\"gallery-1-560\" \/><\/a>\n\t\t\t<\/div>\n\t\t\t\t<figcaption class='wp-caption-text gallery-caption' id='gallery-1-560'>\n\t\t\t\t3 &#8211; Puis menu Mise en forme &#8211; Colonne &#8211; Afficher\n\t\t\t\t<\/figcaption><\/figure>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-12f658a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-eae-slider=\"45328\" data-id=\"12f658a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b29f944\" data-eae-slider=\"33126\" data-id=\"b29f944\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-720bf9d elementor-widget elementor-widget-heading\" data-id=\"720bf9d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">1 - S\u00e9lectionnez la colonne puis \u00ab Masquer \u00bb via clic droit<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Excel : faire appara\u00eetre et dispara\u00eetre les colonnes Ce tutoriel pour Microsoft Excel vous pr\u00e9sente les diff\u00e9rentes m\u00e9thodes pour afficher et masquer les colonnes dans le tableur. Tout utilisateur d\u2019Excel a, a eu ou aura un jour la n\u00e9cessit\u00e9 de masquer une ou plusieurs colonnes. Pour y voir plus clair en all\u00e9geant l\u2019affichage des donn\u00e9es [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"0","footnotes":""},"class_list":["post-551","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/pages\/551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/comments?post=551"}],"version-history":[{"count":3,"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/pages\/551\/revisions"}],"predecessor-version":[{"id":573,"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/pages\/551\/revisions\/573"}],"wp:attachment":[{"href":"https:\/\/www.echiquier-nazairien.com\/web-formation\/wp-json\/wp\/v2\/media?parent=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}