{"id":579,"date":"2021-08-13T15:16:00","date_gmt":"2021-08-13T13:16:00","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=579"},"modified":"2022-08-15T14:28:49","modified_gmt":"2022-08-15T12:28:49","slug":"excel-verifier-des-donnees-apres-saisie","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2021\/08\/excel-verifier-des-donnees-apres-saisie\/","title":{"rendered":"Excel &#8211; V\u00e9rifier des donn\u00e9es apr\u00e8s saisie"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez cr\u00e9\u00e9 un tableau Excel destin\u00e9 \u00e0 \u00eatre rempli par plusieurs utilisateurs. Vous avez pr\u00e9vu une colonne \u00ab\u00a0Date\u00a0\u00bb mais avez omis de d\u00e9finir dans Excel une r\u00e8gle de validation indiquant que les dates saisies devaient l&rsquo;\u00eatre dans une fourchette allant par exemple du 01.01.2022 au 31.12.2022. Or, en parcourant le tableau, vous constatez que certains utilisateurs particuli\u00e8rement taquins ont saisi des dates farfelues ou situ\u00e9es en dehors de cette fourchette (et vous vous \u00eates dit \u00ab\u00a0zuuut, il va falloir que je v\u00e9rifie toutes ces dates manuellement\u00a0\u00bb).<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>S\u00e9lectionnez la plage contenant les dates voire m\u00eame toute la colonne<\/li>\n<li>Allez dans l&rsquo;onglet Donn\u00e9es &gt; Validation des donn\u00e9es &gt; onglet Options<\/li>\n<li>Sous Autoriser, choisissez Date et indiquez les dates de d\u00e9but et de fin puis validez<\/li>\n<li>Cliquez sur le menu du bouton Validation des donn\u00e9es &gt; commande Entourer les donn\u00e9es non valides afin de rep\u00e9rer les erreurs dans la plage de cellules s\u00e9lectionn\u00e9e<\/li>\n<li>Corrigez les valeurs dans la feuille de calcul; les cercles rouges dispara\u00eetront automatiquement<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez cr\u00e9\u00e9 un tableau Excel destin\u00e9 \u00e0 \u00eatre rempli par plusieurs utilisateurs. Vous avez pr\u00e9vu une colonne \u00ab\u00a0Date\u00a0\u00bb mais avez omis de d\u00e9finir dans Excel une&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3770,"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":[55],"class_list":{"0":"post-579","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-validation"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/579","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=579"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/579\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3770"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}