{"id":4467,"date":"2024-09-30T13:46:28","date_gmt":"2024-09-30T13:46:28","guid":{"rendered":"https:\/\/howtogeek.blog\/da\/?p=4467"},"modified":"2024-09-30T13:46:28","modified_gmt":"2024-09-30T13:46:28","slug":"disabling-autoformatting-in-excel-a-stepbystep-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/da\/disabling-autoformatting-in-excel-a-stepbystep-guide\/","title":{"rendered":"Deaktivering af automatisk formatering i Excel: En trin-for-trin guide"},"content":{"rendered":"<p>Automatisk formatering er en yderst nyttig funktion, der automatisk formaterer de data, du indtaster i regneark, hvilket forbedrer l\u00e6sbarheden og forst\u00e5elsen. Der kan dog v\u00e6re tilf\u00e6lde, hvor du foretr\u00e6kker ikke at f\u00e5 dine data formateret automatisk. I s\u00e5danne tilf\u00e6lde er det ligetil at sl\u00e5 denne funktion fra. Derudover kan du tilpasse indstillingerne for automatisk formatering til kun at deaktivere specifikke aspekter, mens funktionen holdes aktiv.<\/p>\n<h2 id=\"option-1-turn-off-auto-formatting-for-a-range-or-a-cell\">Mulighed 1: Deaktiver automatisk formatering for specifikke celler eller omr\u00e5der<\/h2>\n<p>For at forhindre Excel i at automatisk formatere data i en bestemt celle eller et specifikt omr\u00e5de, skal du formatere cellen som tekst. Dette vil bevare dit input uden at p\u00e5virke hele arkets automatiske formatering.<\/p>\n<ul>\n<li>\u00c5bn dit Excel-regneark, og v\u00e6lg den celle eller det omr\u00e5de, hvor du vil deaktivere automatisk formatering. Du kan v\u00e6lge flere celler ved at tr\u00e6kke hen over dem.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00e6lg Celler i Excel\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-741-1.webp\" title=\"V\u00e6lg Celler i Excel\" width=\"882\"\/><\/figure>\n<ul>\n<li>N\u00e5r du har valgt de \u00f8nskede celler, skal du h\u00f8jreklikke p\u00e5 dit valg og v\u00e6lge &#8216;Formater celler&#8217; fra kontekstmenuen.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Valgmulighed for formater celler\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-742-1.webp\" title=\"Valgmulighed for formater celler\" width=\"863\"\/><\/figure>\n<ul>\n<li>I dialogboksen &#8220;Formater celler&#8221; skal du v\u00e6lge indstillingen &#8220;Tekst&#8221; under fanen &#8220;Nummer&#8221;, og derefter klikke p\u00e5 knappen &#8220;OK&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Dialogboksen Formater celler\" class=\"wp-image\" decoding=\"async\" height=\"500\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-743-1.webp\" title=\"Dialogboksen Formater celler\" width=\"889\"\/><\/figure>\n<ul>\n<li>Nu, hvis du indtaster specialtegn eller tal med foranstillede nuller, forbliver formateringen u\u00e6ndret. Det samme g\u00e6lder for tekst indtastet som datoer, f.eks. &#8217;03-24&#8242;, som ikke bliver konverteret til et datoformat.<\/li>\n<\/ul>\n<h2 id=\"option-2-turn-off-auto-formatting-permanently\">Mulighed 2: Deaktiver automatisk formatering permanent<\/h2>\n<p>Du kan ogs\u00e5 v\u00e6lge permanent at deaktivere automatisk formatering i Microsoft Excel for alle dine regneark.<\/p>\n<ul>\n<li>Start Microsoft Excel, og klik p\u00e5 menuen &#8216;Filer&#8217; i \u00f8verste venstre hj\u00f8rne.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Filmenu i Excel\" class=\"wp-image\" decoding=\"async\" height=\"443\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-744-1.webp\" title=\"Filmenu i Excel\" width=\"787\"\/><\/figure>\n<ul>\n<li>Klik derefter p\u00e5 &#8216;Indstillinger&#8217; nederst til venstre i menuen.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Excel-indstillinger\" class=\"wp-image\" decoding=\"async\" height=\"502\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-745-1.webp\" title=\"Excel-indstillinger\" width=\"892\"\/><\/figure>\n<ul>\n<li>I dialogboksen Indstillinger skal du klikke p\u00e5 &#8216;Data&#8217; fra listen til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Dataindstillinger i Excel\" class=\"wp-image\" decoding=\"async\" height=\"543\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-746-1.webp\" title=\"Dataindstillinger i Excel\" width=\"965\"\/><\/figure>\n<ul>\n<li>I afsnittet &#8216;Automatisk datakonvertering&#8217; skal du sikre dig, at afkrydsningsfeltet ud for &#8216;Aktiver alle standarddatakonverteringer&#8230;&#8217; ikke er markeret. Hvis det er markeret, skal du klikke p\u00e5 det for at deaktivere.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Indstillinger for datakonvertering\" class=\"wp-image\" decoding=\"async\" height=\"508\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-747-1.webp\" title=\"Indstillinger for datakonvertering\" width=\"903\"\/><\/figure>\n<ul>\n<li>Klik p\u00e5 knappen &#8216;OK&#8217; for at lukke dialogboksen. Fra nu af vil Excel ikke automatisk formatere de data, der er indtastet i dine regneark.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Bekr\u00e6ft \u00e6ndringer i Excel\" class=\"wp-image\" decoding=\"async\" height=\"473\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-748-1.webp\" title=\"Bekr\u00e6ft \u00e6ndringer i Excel\" width=\"841\"\/><\/figure>\n<ul>\n<li>Hvis det foretr\u00e6kkes, kan du bevare den overordnede indstilling, mens du selektivt deaktiverer visse autoformateringsindstillinger.<\/li>\n<\/ul>\n<h3 id=\"things-to-know\">Vigtige bem\u00e6rkninger<\/h3>\n<ul>\n<li>Du kan ogs\u00e5 undg\u00e5 automatisk formatering ved at indtaste en apostrof f\u00f8r dine v\u00e6rdier i en celle, hvilket vil holde dataene intakte.<\/li>\n<li>For mere avancerede brugere kan brug af Visual Basic for Applications (VBA) kode forhindre automatisk formatering i Excel. Dette kr\u00e6ver at aktivere fanen Udvikler og inds\u00e6tte et modul, hvilket g\u00f8r det mindre egnet til begyndere.<\/li>\n<li>Efter at have deaktiveret automatisk formatering, kan du genaktivere den n\u00e5r som helst ved at f\u00e5 adgang til menuen Indstillinger fra menuen Filer.<\/li>\n<\/ul>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-disable-auto-formatting-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Kilde<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automatisk formatering er en yderst nyttig funktion, der automatisk formaterer de data, du indtaster i regneark, hvilket forbedrer l\u00e6sbarheden og forst\u00e5elsen. Der kan dog v\u00e6re tilf\u00e6lde, hvor du foretr\u00e6kker ikke at f\u00e5 dine data formateret automatisk. I s\u00e5danne tilf\u00e6lde er det ligetil at sl\u00e5 denne funktion fra. Derudover kan du tilpasse indstillingerne for automatisk formatering [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[64,130,286],"class_list":["post-4467","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts\/4467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/comments?post=4467"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts\/4467\/revisions"}],"predecessor-version":[{"id":4468,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts\/4467\/revisions\/4468"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/media?parent=4467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/categories?post=4467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/tags?post=4467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}