{"id":3558,"date":"2023-10-21T10:46:36","date_gmt":"2023-10-21T10:46:36","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/"},"modified":"2023-12-03T13:04:31","modified_gmt":"2023-12-03T13:04:31","slug":"optionen-zum-offnen-von-zellenformaten","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/","title":{"rendered":"Wie \u00f6ffne ich die option \u201ezellen formatieren\u201c?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1342759122\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>In Microsoft Excel k\u00f6nnen Sie mit der Funktion \u201eZellen formatieren\u201c das Erscheinungsbild von Zellen anpassen, indem Sie verschiedene Formatierungsoptionen anpassen.<\/p><p> Um auf das Dialogfeld \u201eZellen formatieren\u201c zuzugreifen, k\u00f6nnen Sie mit der rechten Maustaste auf eine Zelle oder einen Zellbereich klicken und im Kontextmen\u00fc \u201eZellen formatieren\u201c ausw\u00e4hlen. Sie finden es auch auf der Registerkarte \u201eStartseite\u201c des Men\u00fcbands unter der Schaltfl\u00e4che \u201eNummerngruppe\u201c.<\/p><h2> \u00d6ffnen Sie Formatzellen mit der Tastenkombination<\/h2><p> Um die Option \u201eZellen formatieren\u201c in Excel zu \u00f6ffnen, m\u00fcssen Sie eine Zelle oder einen Zellbereich ausw\u00e4hlen und dann die folgende Tastenkombination dr\u00fccken: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61075\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Hotkey-Format-Zellenoptionen\" width=\"1742\" height=\"404\"><\/figure><\/div><p class=\"has-text-align-left\"> <kbd class=\"has-medium-font-size\">Strg+1<\/kbd><\/p><p> Wenn Sie diese Tastenkombination dr\u00fccken, wird sofort die Option \u201eZellen formatieren\u201c ge\u00f6ffnet, die Ihnen das folgende Dialogfeld anzeigt.<\/p><h3 class=\"wp-block-heading\"> Wie man es benutzt<\/h3><ol><li> W\u00e4hlen Sie zun\u00e4chst eine Zelle oder einen Zellbereich aus, in dem Sie die Zellenformatoptionen verwenden m\u00f6chten.<\/li><li> Halten Sie anschlie\u00dfend die <kbd>Strg-Taste<\/kbd> auf der linken Seite der Tastatur gedr\u00fcckt.<\/li><li> Dr\u00fccken Sie anschlie\u00dfend die Taste <kbd>1<\/kbd> oben auf der Tastatur.<\/li><li> W\u00e4hlen Sie am Ende die Registerkarte aus den Optionen aus.<\/li><\/ol><div class=\"gb-container gb-container-2116538e gb-container-mt\"> <a class=\"gb-button gb-button-f7d2c131 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/tastaturkurzel\/\">Tastenkombinationen f\u00fcr Excel-PDFs<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Weitere Verkn\u00fcpfungen <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6ab6fbc6\"><div class=\"gb-container gb-container-6ab6fbc6\"><ul><li style=\"list-style-type: none;\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/automatische-anpassung\/\">Automatische Anpassung<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/malerformat-1\/\">Malerformat<\/a><\/li><li> Zeilenumbruch<\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fuge-kommentare-hinzu\/\">F\u00fcge Kommentare hinzu<\/a><\/li><\/ul><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3558","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wie \u00f6ffne ich die Option \u201eZellen formatieren\u201c in Excel?<\/title>\n<meta name=\"description\" content=\"Lernen Sie die Tastenkombination zum \u00d6ffnen von Zellformatoptionen in Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie \u00f6ffne ich die Option \u201eZellen formatieren\u201c in Excel?\" \/>\n<meta property=\"og:description\" content=\"Lernen Sie die Tastenkombination zum \u00d6ffnen von Zellformatoptionen in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/\",\"name\":\"Wie \u00f6ffne ich die Option \u201eZellen formatieren\u201c in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png\",\"datePublished\":\"2023-10-21T10:46:36+00:00\",\"dateModified\":\"2023-12-03T13:04:31+00:00\",\"description\":\"Lernen Sie die Tastenkombination zum \u00d6ffnen von Zellformatoptionen in Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie \u00f6ffne ich die option \u201ezellen formatieren\u201c?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie \u00f6ffne ich die Option \u201eZellen formatieren\u201c in Excel?","description":"Lernen Sie die Tastenkombination zum \u00d6ffnen von Zellformatoptionen in Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/","og_locale":"de_DE","og_type":"article","og_title":"Wie \u00f6ffne ich die Option \u201eZellen formatieren\u201c in Excel?","og_description":"Lernen Sie die Tastenkombination zum \u00d6ffnen von Zellformatoptionen in Excel.","og_url":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/","url":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/","name":"Wie \u00f6ffne ich die Option \u201eZellen formatieren\u201c in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png","datePublished":"2023-10-21T10:46:36+00:00","dateModified":"2023-12-03T13:04:31+00:00","description":"Lernen Sie die Tastenkombination zum \u00d6ffnen von Zellformatoptionen in Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/options-de-cellule-de-format-de-raccourci-clavier-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/optionen-zum-offnen-von-zellenformaten\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie \u00f6ffne ich die option \u201ezellen formatieren\u201c?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3558"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3558\/revisions"}],"predecessor-version":[{"id":4161,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3558\/revisions\/4161"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}