{"id":1016,"date":"2020-04-16T15:07:29","date_gmt":"2020-04-16T13:07:29","guid":{"rendered":"http:\/\/bi-vaerkstedet.dk\/?p=1016"},"modified":"2022-02-06T15:33:49","modified_gmt":"2022-02-06T13:33:49","slug":"udfyld-blanke-vaerdier-i-excel","status":"publish","type":"post","link":"http:\/\/bi-vaerkstedet.dk\/?p=1016","title":{"rendered":"Udfyld blanke v\u00e6rdier i Excel."},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Der kan af og til v\u00e6re behov for, i et datas\u00e6t, at udfylde v\u00e6rdier ned, s\u00e5ledes at underliggende blanke v\u00e6rdier fyldes med den overliggende ikke blanke v\u00e6rdi som i eksemplet nedenfor.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"510\" height=\"310\" src=\"http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/UdfyldNedExcel.jpg\" alt=\"\" class=\"wp-image-1018\" srcset=\"http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/UdfyldNedExcel.jpg 510w, http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/UdfyldNedExcel-300x182.jpg 300w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I Power Bi kan dette g\u00f8res med udfyld kommandoerne.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"123\" src=\"http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/udfyldning.png\" alt=\"\" class=\"wp-image-1017\" srcset=\"http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/udfyldning.png 397w, http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/udfyldning-300x93.png 300w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Denne mulighed findes ikke i Excel, men man kan opn\u00e5 detsamme resultat som vist nedenfor.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Marker det omr\u00e5de hvor blanke celler skal udfyldes.<\/li><li>G\u00e5 til Hjem -&gt; S\u00f8g og v\u00e6lg -&gt; G\u00e5 til speciel<\/li><li>Mark\u00e9r Tomme celler<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"327\" height=\"449\" src=\"http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/V\u00e6lgTommeCeller.jpg\" alt=\"\" class=\"wp-image-1019\" srcset=\"http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/V\u00e6lgTommeCeller.jpg 327w, http:\/\/bi-vaerkstedet.dk\/wp-content\/uploads\/2020\/04\/V\u00e6lgTommeCeller-218x300.jpg 218w\" sizes=\"auto, (max-width: 327px) 100vw, 327px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. V\u00e6lg OK<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nu er alle de blankt celler i omr\u00e5det markeret. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Tast formelen =A4 i celle A5 og afslut med Ctrl + Enter.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Der kan af og til v\u00e6re behov for, i et datas\u00e6t, at udfylde v\u00e6rdier ned, s\u00e5ledes at underliggende blanke v\u00e6rdier fyldes med den overliggende ikke blanke v\u00e6rdi som i eksemplet nedenfor. I Power Bi kan dette g\u00f8res med udfyld kommandoerne. Denne mulighed findes ikke i Excel, men man kan opn\u00e5 detsamme resultat som vist nedenfor. Marker det omr\u00e5de hvor blanke celler skal udfyldes. G\u00e5 til Hjem -&gt; S\u00f8g og v\u00e6lg&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[11],"class_list":["post-1016","post","type-post","status-publish","format-standard","hentry","category-excel","tag-excel"],"gutentor_comment":108,"_links":{"self":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts\/1016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1016"}],"version-history":[{"count":2,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts\/1016\/revisions"}],"predecessor-version":[{"id":1267,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=\/wp\/v2\/posts\/1016\/revisions\/1267"}],"wp:attachment":[{"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1016"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bi-vaerkstedet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}