{"id":418,"date":"2026-01-23T10:46:32","date_gmt":"2026-01-23T10:46:32","guid":{"rendered":"https:\/\/bliv-klogere.dk\/?page_id=418"},"modified":"2026-02-05T17:28:32","modified_gmt":"2026-02-05T17:28:32","slug":"4-sorter-og-filtrer","status":"publish","type":"page","link":"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/","title":{"rendered":"4. Sorter og filtrer"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Indholdsfortegnelse<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#1_Almindelig_sortering\" >1. Almindelig sortering<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#Opgaver\" >Opgaver<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#11_Sortering\" >1.1 Sortering<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#2_Simpel_filtrering\" >2. Simpel filtrering<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#Opgaver-2\" >Opgaver&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#21_Filtrering\" >2.1 Filtrering&nbsp;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#3_Sortering_og_filtrering_med_tabelformatering\" >3. Sortering og filtrering med tabelformatering<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#Opgaver-3\" >Opgaver&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/#31_Sortering\" >3.1 Sortering&nbsp;<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Almindelig_sortering\"><\/span>1. Almindelig sortering<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du kan sagtens f\u00e5 brug for at b\u00e5de sortere og filtrere<\/li>\n\n\n\n<li>Sortering er, n\u00e5r man laver en r\u00e6kkef\u00f8lge. F.eks. nummerorden, alfabetisk r\u00e6kkef\u00f8lge mv.<\/li>\n\n\n\n<li>Filtrering er, n\u00e5r der er nogle data, man ikke \u00f8nsker at se<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Her er en tabel over kunder, som jeg gerne vil filtrere. I f\u00f8rste omgang vil jeg gerne filtrere efter fornavn.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Marker, hvad du vil filtrere (1)<\/li>\n\n\n\n<li>I fanen data klik p\u00e5 sorteringsknappen (2)<\/li>\n\n\n\n<li>S\u00e5 f\u00e5r du et pop op vindue, der sp\u00f8rger, om du vil ekspandere sorteringen til hele tabellen (3). Det er en rigtig god ide at g\u00f8re det, s\u00e5 klik p\u00e5 Sorter (4)<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-123-1024x437.png\" alt=\"\" class=\"wp-image-419\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-123-1024x437.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-123-300x128.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-123-768x328.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-123.png 1470w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sortering med flere kriterier<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nu vil jeg sortere efter efternavn f\u00f8rst, herefter efter fornavn<\/li>\n\n\n\n<li>Klik et sted I tabellen (1)<\/li>\n\n\n\n<li>I fanen Data klik p\u00e5 knappen Sorter (2)<\/li>\n\n\n\n<li>I det nye pop-op vindue ser du en linje til sortering. V\u00e6lg &#8220;Efternavn&#8221; og sorter stigende (3)<\/li>\n\n\n\n<li>For at f\u00e5 flere linjer frem, klik p\u00e5 knappen Add level (4)<\/li>\n\n\n\n<li>I den nye linje sortere du s\u00e5 efter fornavn (5)<\/li>\n\n\n\n<li>S\u00f8rg forresten for at s\u00e6tte flueben ved, at dine data har en overskrift (6)<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 OK (7)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"407\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-124-1024x407.png\" alt=\"\" class=\"wp-image-420\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-124-1024x407.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-124-300x119.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-124-768x305.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-124.png 1430w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sortering efter dine egne kriterier<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Der er 3 kundetyper. Premium, Business og Standard<\/li>\n\n\n\n<li>Jeg vil gerne sortere kunderne med premium f\u00f8rst, s\u00e5 business og s\u00e5 standard. Det kan man kun g\u00f8re ved at lave sin egen sorteringsliste<br>&nbsp;<\/li>\n\n\n\n<li>Som f\u00f8r klik et sted I tabellen (1)<\/li>\n\n\n\n<li>I fanen Data klik p\u00e5 knappen Sorter (2)<\/li>\n\n\n\n<li>I det nye pop-op vindue ser du en linje til sortering. V\u00e6lg &#8220;Kundetype&#8221;<\/li>\n\n\n\n<li>Helt th. I linjen klik p\u00e5 fald-ned menuen (4) og v\u00e6lg Brugerdefineret liste (5)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"402\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-125-1024x402.png\" alt=\"\" class=\"wp-image-421\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-125-1024x402.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-125-300x118.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-125-768x302.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-125.png 1466w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I pop-op vinduet skriv listen som vist (1)<\/li>\n\n\n\n<li>Klik p\u00e5 Add (2), s\u00e5 listen er synlig tv. (3)<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 OK (4).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"556\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-126.png\" alt=\"\" class=\"wp-image-422\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-126.png 820w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-126-300x203.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-126-768x521.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>N\u00e5r du klikker p\u00e5 OK igen, s\u00e5 bliver listen sorteret efter kundetype<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"557\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-127-1024x557.png\" alt=\"\" class=\"wp-image-423\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-127-1024x557.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-127-300x163.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-127-768x418.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-127.png 1053w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver\"><\/span>Opgaver<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11_Sortering\"><\/span><strong>1.1 Sortering<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gennemf\u00f8r vejledningen<\/li>\n\n\n\n<li>Den med at sortere p\u00e5 premium, business og standard er ekstra<\/li>\n\n\n\n<li>Ekstra: S\u00e6t flere kriterier p\u00e5, s\u00e5 du ikke kun sorterer efter kundetype men ogs\u00e5 efter Efternavn og herefter Fornavn<\/li>\n\n\n\n<li>Ekstra: Lav en ny egen sortering, som sorterer efter Viborg, Horsens, Vejle, Valby, Odense, Sundby og Kalundborg<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Til geng\u00e6ld slipper du for indtastningen, for du f\u00e5r Excel-filen her til download:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-5478f4c6-483b-4b56-8146-eebf7caed695\" href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Sortering-og-filtrering1.xlsx\">Sortering og filtrering1<\/a><a href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Sortering-og-filtrering1.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-5478f4c6-483b-4b56-8146-eebf7caed695\">Download<\/a><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Simpel_filtrering\"><\/span>2. Simpel filtrering<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Simpel filtrering (1 kolonne)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Marker hele tabellen (1)<\/li>\n\n\n\n<li>I fanen Data klik p\u00e5 knappen Filtrer (2)<\/li>\n\n\n\n<li>Du f\u00e5r nu fald-ned menuer ved hver s\u00f8jle (3)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"746\" height=\"562\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-128.png\" alt=\"\" class=\"wp-image-428\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-128.png 746w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-128-300x226.png 300w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Filtreringen foreg\u00e5r simpelt ved, at du klikker p\u00e5 fald-ned menuen (1)&nbsp;<\/li>\n\n\n\n<li>I s\u00f8jlen med Kundetype vil jeg nu kun se premium-kunderne. Jeg fjerner fluebenene alle andre steder end ud for Premium (2)&nbsp;<\/li>\n\n\n\n<li>Til sidst klikker jeg p\u00e5 OK (3)&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"512\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-129.png\" alt=\"\" class=\"wp-image-430\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-129.png 735w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-129-300x209.png 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resultatet ses nedenfor (1)&nbsp;<\/li>\n\n\n\n<li>Bem\u00e6rk at der er kommet en lille tragt p\u00e5 kolonnen Kundetype. Det viser, at der er filtreret&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"785\" height=\"212\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-130.png\" alt=\"\" class=\"wp-image-431\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-130.png 785w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-130-300x81.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-130-768x207.png 768w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fjern filtreringen ved I fanen Data at klikke p\u00e5 knappen Clear (1)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"364\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-131.png\" alt=\"\" class=\"wp-image-432\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-131.png 752w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-131-300x145.png 300w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Filtrering efter kriterie<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jeg vil gerne se alle postnumre, der ligger vest for Storeb\u00e6lt. Postnummer 5000 og alle postnumre h\u00f8jre end det ligger vest for storeb\u00e6lt&nbsp;<\/li>\n\n\n\n<li>\u00c5ben fald-ned menuen I r\u00e6kken postnummer (1)&nbsp;<\/li>\n\n\n\n<li>V\u00e6lg nummeret filter (2). Excel g\u00e6tter selv ud fra datatypen hvilken type filter, du har brug for.&nbsp;<\/li>\n\n\n\n<li>V\u00e6lg St\u00f8rre end eller lig med (3)&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"668\" height=\"644\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-132.png\" alt=\"\" class=\"wp-image-433\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-132.png 668w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-132-300x289.png 300w\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I det nye pop-op vindue indtast 5000 (1), som er det postnummer, der skiller \u00f8st og vest for Storeb\u00e6lt&nbsp;<\/li>\n\n\n\n<li>Bem\u00e6rk at du kan s\u00e6tte flere kriterier op, linje 2 er allerede parat, og du f\u00e5r automatisk flere linjer&nbsp;<\/li>\n\n\n\n<li>Klik p\u00e5 OK (2)&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"942\" height=\"270\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-133.png\" alt=\"\" class=\"wp-image-434\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-133.png 942w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-133-300x86.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-133-768x220.png 768w\" sizes=\"auto, (max-width: 942px) 100vw, 942px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resultatet&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"272\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-134.png\" alt=\"\" class=\"wp-image-435\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-134.png 786w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-134-300x104.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-134-768x266.png 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver-2\"><\/span>Opgaver&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21_Filtrering\"><\/span><strong>2.1 Filtrering<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gennemf\u00f8r vejledningen p\u00e5 det vedh\u00e6ftede Excel ark&nbsp;(se opgave 1.1 ovenfor)<\/li>\n\n\n\n<li>Ekstra: Udfordr filtrene. Kan du f.eks. filtrere, s\u00e5 du ser alle postnumre mellem 5000 og 7500? Eller alle postnumre over 7000 og under 3000?&nbsp;<\/li>\n\n\n\n<li>Ekstra: Pr\u00f8v at udforsk muligheden for at filtrere felter efter farver&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Sortering_og_filtrering_med_tabelformatering\"><\/span>3. Sortering og filtrering med tabelformatering<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hvis du formaterer tabellen, s\u00e5 f\u00e5r du automatisk nogle sortering- og filtreringsmuligheder&nbsp;<\/li>\n\n\n\n<li>Marker tabellen (1)&nbsp;<\/li>\n\n\n\n<li>I fanen Hjem v\u00e6lg knappen Tabeltypografier (2)&nbsp;<\/li>\n\n\n\n<li>V\u00e6lg en af tabeltypografierne men gerne en af dem, hvor den \u00f8verste r\u00e6kke har samme farve (3)&nbsp;<\/li>\n\n\n\n<li>Bem\u00e6rk, at du kan lave dine egne tabeltypografier, hvis du skulle f\u00e5 trangen (4)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"559\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-135.png\" alt=\"\" class=\"wp-image-438\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-135.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-135-300x164.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-135-768x419.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I pop-op vinduet kan du tjekke, om du har valgt de rigtige celler (1). Hvad den n\u00e6sten altid har, men du kan \u00e6ndre det her&nbsp;<\/li>\n\n\n\n<li>S\u00e6t flueben ud for, at din tabel har overskrifter (2)&nbsp;<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 OK<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"170\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-136.png\" alt=\"\" class=\"wp-image-439\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-136.png 338w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-136-300x151.png 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00e5 f\u00e5r du en formatering af tabellen, s\u00e5 den automatisk er sat op til sortering og filtrering&nbsp;&nbsp;<\/li>\n\n\n\n<li>Hvis du s\u00e6tter flere r\u00e6kker eller s\u00f8jler p\u00e5, s\u00e5 vil de v\u00e6re omfattet af den nye formatering<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"851\" height=\"396\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-137.png\" alt=\"\" class=\"wp-image-440\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-137.png 851w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-137-300x140.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-137-768x357.png 768w\" sizes=\"auto, (max-width: 851px) 100vw, 851px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver-3\"><\/span>Opgaver&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"31_Sortering\"><\/span><strong>3.1 Sortering<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Download Excel arket fra opgave 1.1<\/li>\n\n\n\n<li>Gennemf\u00f8r vejledningen&nbsp;<\/li>\n\n\n\n<li>Ekstra: Udfordr igen b\u00e5de filtreringen og sorteringen&nbsp;<\/li>\n\n\n\n<li>Ekstra: Lav din egen tabeltypograf og test den af&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\">toppen af siden<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Almindelig sortering Her er en tabel over kunder, som jeg gerne vil filtrere. I f\u00f8rste omgang vil jeg gerne filtrere efter fornavn. Link til toppen af siden. Sortering med flere kriterier Link til toppen af siden. Sortering efter dine egne kriterier Link til toppen af siden. Opgaver 1.1 Sortering Til geng\u00e6ld slipper du for &hellip; <a href=\"https:\/\/bliv-klogere.dk\/index.php\/4-sorter-og-filtrer\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">4. Sorter og filtrer<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-418","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":6,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/418\/revisions"}],"predecessor-version":[{"id":1415,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/418\/revisions\/1415"}],"wp:attachment":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/media?parent=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}