{"id":341,"date":"2026-01-22T19:27:58","date_gmt":"2026-01-22T19:27:58","guid":{"rendered":"https:\/\/bliv-klogere.dk\/?page_id=341"},"modified":"2026-02-05T17:25:38","modified_gmt":"2026-02-05T17:25:38","slug":"3-formatering-i-excel","status":"publish","type":"page","link":"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/","title":{"rendered":"3. Formatering i Excel"},"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\/3-formatering-i-excel\/#1_Oplaeg_om_formatering\" >1. Opl\u00e6g om formatering<\/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\/3-formatering-i-excel\/#Opgaver\" >Opgaver&nbsp;<\/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\/3-formatering-i-excel\/#11_Formatering\" >1.1 Formatering&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/#12_Mere_formatering\" >1.2 Mere formatering&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/#13_Ekstra_Oh_my_gosh_no_English_pounds\" >1.3 Ekstra. Oh my gosh no English pounds&nbsp;<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Oplaeg_om_formatering\"><\/span>1. Opl\u00e6g om formatering<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I Excel kan du, som i Word, PowerPoint mv. \u00e6ndre skrifttype og&nbsp; -farve mv., og det foreg\u00e5r p\u00e5 pr\u00e6cis samme m\u00e5de. Men der findes ogs\u00e5 en r\u00e6kke formateringsmuligheder, som er s\u00e6regne for Excel. Dem f\u00e5r du en introduktion til her.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jeg har her et lille budget som eksempel. Jeg har trukket i s\u00f8jlernes kanter, s\u00e5 er er plads til teksten. Men celle B2 har en tekst, der er for lang til cellen. Derfor markerer jeg celle B2 til D2 (1) og klikker p\u00e5 knappen Flet og centrer (2).&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"404\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-99.png\" alt=\"\" class=\"wp-image-342\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-99.png 662w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-99-300x183.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nu er cellen lang nok til, at min overskrift kan st\u00e5 der (1)&nbsp;<\/li>\n\n\n\n<li>For at g\u00f8re teksten til en overskrift p\u00e5 en nem m\u00e5de, v\u00e6lger jeg fra knappen Celletypografier (Cell styles) (2) stylen Title (3). Tilsvarende markerer jeg celler i selve tabellen og v\u00e6lger hhv. Formateringen Accent 5 (4) og Accent 2 (5). S\u00e5 blev min tabel p\u00e6nere (6)&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"413\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-100.png\" alt=\"\" class=\"wp-image-343\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-100.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-100-300x121.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-100-768x310.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jeg vil nu formatere bel\u00f8bene, s\u00e5 de er adskildt med tusindtalsseperator og der st\u00e5r \u201dkr\u201d ved bel\u00f8bet.&nbsp;&nbsp;<\/li>\n\n\n\n<li>Marker de \u00f8nskede celler eller nemmere, marker hele s\u00f8jlen med cellerne p\u00e5 en gang ved at klikke p\u00e5 den (her s\u00f8jle \u201dD\u201d, og den er markeret i figuren herunder (3)).&nbsp;<\/li>\n\n\n\n<li>I fanen Hjem klik p\u00e5 valuta-ikonet (1)&nbsp;<\/li>\n\n\n\n<li>I fald-ned menuen v\u00e6lg \u201dkr. Danish\u201d (2)&nbsp;<\/li>\n\n\n\n<li>S\u00e5 f\u00e5r alle bel\u00f8b-celler i s\u00f8jle D den \u00f8nskede formatering (3)&nbsp;<\/li>\n\n\n\n<li>Formateringen giver fast 2 decimaler efter kommaet. Hvis du \u00f8nsker at for\u00f8ge eller formindske antal decimaler, s\u00e5 brug knapperne for\u00f8g og formindsk decimaler (5)&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Kunne du godt t\u00e6nke dig tusindtalsseperation men uden, at der st\u00e5r \u201dkr\u201d? S\u00e5 brug knappen med kommaet (5). Resultatet ser du til h\u00f8jre (6).&nbsp;<br>&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"452\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-101.png\" alt=\"\" class=\"wp-image-344\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-101.png 584w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-101-300x232.png 300w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver\"><\/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=\"11_Formatering\"><\/span><strong>1.1 Formatering<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Indtast f\u00f8lgende i et Excelark&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"452\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-101.png\" alt=\"\" class=\"wp-image-345\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-101.png 584w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-101-300x232.png 300w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formater overskriften med flet og centrer som beskrevet ovenfor&nbsp;<\/li>\n\n\n\n<li>Giv overskrifterne (Post, Bem\u00e6rkning, Bel\u00f8b) samt ben\u00e6vnelserne (Husleje, Mad, \u00d8vrige regninger, T\u00f8j) et andet formatering (dvs. anden tekst- og baggrundsfarve)&nbsp;<\/li>\n\n\n\n<li>Ret bel\u00f8bene, s\u00e5 der st\u00e5r f.eks. \u201d6.000,00 kr\u201d&nbsp;<\/li>\n\n\n\n<li>Marker hele s\u00f8jlen med bel\u00f8bene og formindsk antal decimaler til 0. S\u00e5 skulle der gerne st\u00e5 6.000 kr&nbsp;<\/li>\n\n\n\n<li>Hvis det er sv\u00e6rt, s\u00e5 lav \u00f8velsen igen forfra&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12_Mere_formatering\"><\/span><strong>1.2 Mere formatering<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lav nu dit eget budget med 5 \u2013 6 poster, men denne gang skal du selv finde p\u00e5 formatering. Brug endelig l\u00f8s af alle de muligheder, som Excel giver dig&nbsp;<\/li>\n\n\n\n<li>Pr\u00f8v tasten med kommaet af, s\u00e5 du har tusindtalsseperation men uden ben\u00e6vnelsen \u201dkr\u201d.&nbsp;<\/li>\n\n\n\n<li>Ekstra opgave: Nederst i fald-ned menuen kan du lave dine egne celleformatering. Pr\u00f8v at lege lidt med den mulighed&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"13_Ekstra_Oh_my_gosh_no_English_pounds\"><\/span><strong>1.3 Ekstra. Oh my gosh no English pounds<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du skal en tur til England. Lav et hurtigt budget med flyrejse og ophold&nbsp;<\/li>\n\n\n\n<li>Det sv\u00e6re er, at du skal finde en m\u00e5de at angive bel\u00f8bene i pund p\u00e5. Kr, $ og \u20ac er nemt nok, men du kan alts\u00e5 ogs\u00e5 lave ben\u00e6vnelser efter eget valg som f.eks.&nbsp; \u00a3, CUC (cubanske turist-pesos), AUD (australske dollars) osv. Tip. Du skal samme sted hen, som da du lavede &#8220;kr&#8221;&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/\">toppen af siden<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Opl\u00e6g om formatering I Excel kan du, som i Word, PowerPoint mv. \u00e6ndre skrifttype og&nbsp; -farve mv., og det foreg\u00e5r p\u00e5 pr\u00e6cis samme m\u00e5de. Men der findes ogs\u00e5 en r\u00e6kke formateringsmuligheder, som er s\u00e6regne for Excel. Dem f\u00e5r du en introduktion til her.&nbsp; Kunne du godt t\u00e6nke dig tusindtalsseperation men uden, at der st\u00e5r &hellip; <a href=\"https:\/\/bliv-klogere.dk\/index.php\/3-formatering-i-excel\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">3. Formatering i Excel<\/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-341","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/341","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=341"}],"version-history":[{"count":4,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/341\/revisions"}],"predecessor-version":[{"id":1412,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/341\/revisions\/1412"}],"wp:attachment":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/media?parent=341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}