{"id":3678,"date":"2023-09-25T19:19:50","date_gmt":"2023-09-25T19:19:50","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/"},"modified":"2023-12-03T11:20:39","modified_gmt":"2023-12-03T11:20:39","slug":"spalte-1-hinzufugen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/","title":{"rendered":"Wie f\u00fcge ich eine spalte mithilfe einer excel-verkn\u00fcpfung hinzu?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1497138796\"><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>Das Hinzuf\u00fcgen einer neuen Spalte in Excel ist eine sehr einfache Aufgabe. W\u00e4hrend der Arbeit mit Daten m\u00f6chten Benutzer h\u00e4ufig eine neue Spalte hinzuf\u00fcgen oder einf\u00fcgen und k\u00f6nnen dies mithilfe von Tastaturk\u00fcrzeln tun, anstatt auf das Symbol \u201eEinf\u00fcgen\u201c unter der Registerkarte \u201eStartseite\u201c zu klicken.<\/p><h2 class=\"wp-block-heading\"> Tastenkombination zum Hinzuf\u00fcgen einer Spalte in Excel<\/h2><p> <kbd>Alt<\/kbd> \u2192 <kbd>I<\/kbd> \u2192 <kbd>C<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67492\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"Tastenkombinationen zum Hinzuf\u00fcgen einer Spalte\" width=\"809\" height=\"317\"><\/figure><\/div><p> <kbd>Strg<\/kbd> + <kbd>Umschalt<\/kbd> <kbd>++<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67493\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-touches-de-raccourci-pour-ajouter-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"Tastenkombinationen zum Hinzuf\u00fcgen einer Spalte\" width=\"804\" height=\"315\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Schritte zum Hinzuf\u00fcgen einer Spalte mithilfe einer Tastenkombination<\/h2><h3 class=\"wp-block-heading\"> 1. Verwenden Sie die Tastenkombination Alt \u2192 I \u2192 C<\/h3><ol><li> Klicken Sie zun\u00e4chst auf eine beliebige Zelle, links von der Sie die neue leere Spalte hinzuf\u00fcgen m\u00f6chten. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-Zellenauswahl\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionnez-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-cell\" width=\"418\" height=\"213\"><\/li><li> Danach dr\u00fccken Sie einfach \u201eAlt \u2192 I \u2192 C\u201c und die neue Spalte wird links von der ausgew\u00e4hlten Zelle eingef\u00fcgt. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-neue-Spalte-hinzugef\u00fcgt\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nouvelle-colonne-ajoutee.png\" sizes=\"auto, \" srcset=\"\" alt=\"new-column-added\" width=\"564\" height=\"225\"><\/li><\/ol><h3 class=\"wp-block-heading\"> 2. Verwenden der Tastenkombination Strg + Umschalt + Pluszeichen (+)<\/h3><ol><li> W\u00e4hlen Sie zun\u00e4chst mit der Tastenkombination \u201eStrg + Leertaste\u201c die gesamte Spalte aus, links davon m\u00f6chten Sie die neue leere Spalte hinzuf\u00fcgen.<\/li><li> Dr\u00fccken Sie anschlie\u00dfend <kbd>Strg<\/kbd> + <kbd>Umschalt<\/kbd> + <kbd>+<\/kbd> Tastenkombinationen und Sie erhalten die neue leere Spalte, die links von der ausgew\u00e4hlten Spalte eingef\u00fcgt wird.<\/li><\/ol><h2 class=\"wp-block-heading\"> Imbissbuden<\/h2><ol><li> Excel f\u00fcgt die Spalte(n) immer links von der ausgew\u00e4hlten Zelle oder Spalte hinzu. Wir k\u00f6nnen diese Standardeinstellung nicht \u00e4ndern.<\/li><li> Sobald Sie eine Spalte hinzugef\u00fcgt haben, k\u00f6nnen Sie einfach die Tasten <kbd>Fn<\/kbd> + <kbd>F4<\/kbd> dr\u00fccken, damit Excel die Aufgabe wiederholt, um weitere leere Spalten hinzuzuf\u00fcgen. <\/li><\/ol><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Weitere Tutorials <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-3\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/zelle-loschen\/\">Zelle l\u00f6schen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zeile-loschen\/\">Zeilen l\u00f6schen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zelle-bearbeiten\/\">Zelle bearbeiten<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/eine-zelle-einfugen\/\">F\u00fcgen Sie eine Zelle ein<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/eine-zeile-einfugen\/\">Einf\u00fcgen \u2013 Zeilen hinzuf\u00fcgen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zellen-verschmelzen-dissoziieren-1\/\">Zellen zusammenf\u00fchren und wieder aufheben<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Zur\u00fcck zu <a href=\"https:\/\/exceladvisor.org\/de\/tastaturkurzel\/\">Excel-Verkn\u00fcpfungen (PDF-Spickzettel)<\/a><\/p><\/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-3678","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 f\u00fcge ich eine Spalte mithilfe einer Excel-Verkn\u00fcpfung hinzu?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie mithilfe einer Tastenkombination eine Spalte zu einem Arbeitsblatt in Excel hinzuf\u00fcgen.\" \/>\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\/spalte-1-hinzufugen\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie f\u00fcge ich eine Spalte mithilfe einer Excel-Verkn\u00fcpfung hinzu?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie mithilfe einer Tastenkombination eine Spalte zu einem Arbeitsblatt in Excel hinzuf\u00fcgen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:20:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.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\/spalte-1-hinzufugen\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/\",\"name\":\"Wie f\u00fcge ich eine Spalte mithilfe einer Excel-Verkn\u00fcpfung hinzu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png\",\"datePublished\":\"2023-09-25T19:19:50+00:00\",\"dateModified\":\"2023-12-03T11:20:39+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie mithilfe einer Tastenkombination eine Spalte zu einem Arbeitsblatt in Excel hinzuf\u00fcgen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie f\u00fcge ich eine spalte mithilfe einer excel-verkn\u00fcpfung hinzu?\"}]},{\"@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 f\u00fcge ich eine Spalte mithilfe einer Excel-Verkn\u00fcpfung hinzu?","description":"In diesem Tutorial erfahren Sie, wie Sie mithilfe einer Tastenkombination eine Spalte zu einem Arbeitsblatt in Excel hinzuf\u00fcgen.","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\/spalte-1-hinzufugen\/","og_locale":"de_DE","og_type":"article","og_title":"Wie f\u00fcge ich eine Spalte mithilfe einer Excel-Verkn\u00fcpfung hinzu?","og_description":"In diesem Tutorial erfahren Sie, wie Sie mithilfe einer Tastenkombination eine Spalte zu einem Arbeitsblatt in Excel hinzuf\u00fcgen.","og_url":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:20:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.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\/spalte-1-hinzufugen\/","url":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/","name":"Wie f\u00fcge ich eine Spalte mithilfe einer Excel-Verkn\u00fcpfung hinzu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png","datePublished":"2023-09-25T19:19:50+00:00","dateModified":"2023-12-03T11:20:39+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie mithilfe einer Tastenkombination eine Spalte zu einem Arbeitsblatt in Excel hinzuf\u00fcgen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touches-de-raccourci-pour-ajouter-une-colonne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/spalte-1-hinzufugen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie f\u00fcge ich eine spalte mithilfe einer excel-verkn\u00fcpfung hinzu?"}]},{"@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\/3678","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=3678"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3678\/revisions"}],"predecessor-version":[{"id":4019,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3678\/revisions\/4019"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}