{"id":72,"date":"2026-10-16T11:06:24","date_gmt":"2026-10-16T11:06:24","guid":{"rendered":"https:\/\/www.lacompta.org\/?page_id=72"},"modified":"2026-10-16T21:53:51","modified_gmt":"2026-10-16T19:53:51","slug":"lc-5a1a47ca496c884f59fd","status":"publish","type":"page","link":"https:\/\/www.lacompta.org\/comptabilite-modeles-excel\/plan-comptable-francais-excel.php","title":{"rendered":"Plan comptable fran\u00e7ais &#8211; Excel"},"content":{"rendered":"<h1>Plan comptable fran\u00e7ais &#8211; Excel<\/h1>\n<div id=\"section\"><input type=\"hidden\" id=\"user_connected_quotes\" value=\"0\"><\/p>\n<div id=\"blackBack\"><\/div>\n<div id=\"userBlockNotConnected\" style=\"display:none;\">\n<div id=\"users_only\">\n<div id=\"users_only_title\">Seuls nos <span id=\"underline\">membres premium<\/span> peuvent voir <span id=\"underline\">les liens, et les t&eacute;l&eacute;chargements !<\/span><\/div>\n<div id=\"users_only_title_2\">Devenez un membre premium pour <strong><span id=\"underline\">3 &euro; seulement<\/span><\/strong><\/div>\n<div class=\"users_only_price_fork\">Devenir Membre Premium <strong> &#8211; 3 &euro;<\/strong><\/div>\n<div id=\"account_link_connect\">\n<p>\t\t\t\t\t\t\t\t\t\t\t\tVous avez d&eacute;j&agrave; un compte, Identifiez-vous<\/p><\/div>\n<div id=\"close_account_box\">FERMER [X]<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div id=\"article\"><input type=\"hidden\" id=\"file_name\" value=\"420\" name=\"file_name\"\/><\/p>\n<p>Nous avons adapt\u00e9 le plan comptable fran\u00e7ais disponible sur le site sous format excel pour vous permettre de l&rsquo;utiliser facilement dans vos travaux sous excel.<\/p>\n<div align=\"center\" style=\"width:100%; height: 300px;\">\n<p><\/p>\n<\/div>\n<p>Dans ce plan comptable sous format excel vous avez deux feuilles, la premi\u00e8re \u2018plan comptable fran\u00e7ais A\u2019 regroupe les comptes sous deux colonnes, la premi\u00e8re colonne pour les num\u00e9ros de comptes et la deuxi\u00e8me pour l&rsquo;intitul\u00e9 des comptes. La deuxi\u00e8me feuille \u2018plan comptable B\u2019 regroupe tous les comptes avec leurs num\u00e9ros dans une seul colonne.<\/p>\n<p><strong>Cr\u00e9er une liste de choix d\u00e9roulante pour s\u00e9lectionner un compte<\/strong><\/p>\n<p>&#8211; S\u00e9lectionnez tous les comptes de la feuille plan comptable fran\u00e7ais B<br \/>\n&#8211; Clique droit &gt; nommer une plage<br \/>\n&#8211; Saisir plan comptable<br \/>\n&#8211; S\u00e9lectionnez la cellule o\u00f9 vous voulez cr\u00e9er votre liste<br \/>\n&#8211; Rendez-vous dans l&rsquo;onglet donn\u00e9es &gt; validation des donn\u00e9es<br \/>\n&#8211; Dans l&rsquo;onglet options &gt; s\u00e9lectionnez autoriser &gt; liste et saisissez &nbsp;plan comptable<\/p>\n<p style=\"text-align:center\"><img decoding=\"async\" alt=\"plan comptable excel\" src=\"\/images-2\/excel_plan_comptable.png\" style=\"height:282px; width:620px\" \/><\/p>\n<p style=\"text-align:center\"><strong>T\u00e9l\u00e9charger le plan comptable fran\u00e7ais [Excel]<\/strong><\/p>\n<blockquote>\n<p style=\"text-align:center\"><strong>T\u00e9l\u00e9charger le plan comptable fran\u00e7ais [Excel]<\/strong><br \/>\n&nbsp;<\/p>\n<\/blockquote>\n<div align=\"center\" style=\"width:100%; height: 300px;\">\n<\/div>\n<\/div>\n<div style=\"\n\n    display: none;\n\n    padding: 4px;\n\n    border: 1px #2e93c361 solid;\n\n    border-radius: 2px;\n\n    transition: all 0.3s cubic-bezier(.25,.8,.25,1);\n\n    \"><\/p>\n<div><a id=\"title_external_from_page\" href=\"\/comptabilite-modeles-excel\/\">Documents de comptabilit&eacute; (mod&egrave;les et tableurs Excel,xls,xlsx)<\/a><\/div>\n<div align=\"left\">\n<p id=\"p_to_hide\" style=\"margin-top: 6px;\n\n    margin-bottom: 6px;\">Documents, mod&egrave;les et tableurs Microsoft Excel et Libre Office. Calcul des heures de travail, &eacute;tat de rapprochement bancaire, compte de r&eacute;sultat, Mod&egrave;le facture avec TVA, remise et acompte&#8230; <\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Plan comptable fran\u00e7ais &#8211; Excel Seuls nos membres premium peuvent voir les liens, et les t&eacute;l&eacute;chargements ! Devenez un membre [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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":""},"class_list":["post-72","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.lacompta.org\/index.php?rest_route=\/wp\/v2\/pages\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lacompta.org\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.lacompta.org\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.lacompta.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lacompta.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=72"}],"version-history":[{"count":2,"href":"https:\/\/www.lacompta.org\/index.php?rest_route=\/wp\/v2\/pages\/72\/revisions"}],"predecessor-version":[{"id":2196,"href":"https:\/\/www.lacompta.org\/index.php?rest_route=\/wp\/v2\/pages\/72\/revisions\/2196"}],"wp:attachment":[{"href":"https:\/\/www.lacompta.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}