{"id":3613,"date":"2023-10-14T05:07:37","date_gmt":"2023-10-14T05:07:37","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/"},"modified":"2023-12-03T13:05:10","modified_gmt":"2023-12-03T13:05:10","slug":"die-zelle-austauschen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/","title":{"rendered":"Wie tausche ich zwei zellen in excel aus?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1866595831\"><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 Excel gibt es eine schnelle und einfache M\u00f6glichkeit, zwei Zellen miteinander zu vertauschen. Wenn Sie einen Wert in Zelle A2 und einen Wert in Zelle B2 haben, k\u00f6nnen Sie mit Swap Zellen von A2 nach B2 und von B2 nach A2 austauschen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83226\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"399\" height=\"212\"><\/figure><\/div><p> In diesem Tutorial schauen wir uns einen schnellen Trick an, um zwei Zellen miteinander zu vertauschen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77868\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellules-dechange.png\" sizes=\"auto, \" srcset=\"\" alt=\"Swap-Zellen\" width=\"341\" height=\"140\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Schritte zum Austauschen von Zellen in Excel<\/h2><ol><li> Zuerst m\u00fcssen Sie Zelle A2 ausw\u00e4hlen. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-Zellen ausw\u00e4hlen, die ausgetauscht werden m\u00fcssen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cellules-selectionnees-doivent-etre-echangees.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-cell-need-to-swap\" width=\"329\" height=\"155\"><\/li><li> Halten Sie nun die Umschalttaste auf Ihrer Tastatur gedr\u00fcckt. <br><img loading=\"lazy\" decoding=\"async\" title=\"3. Halten Sie die Umschalttaste gedr\u00fcckt\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appuyez-et-maintenez-la-touche-Maj-enfoncee.png\" sizes=\"auto, \" srcset=\"\" alt=\"press-and-hold-shift-key\" width=\"330\" height=\"151\"><\/li><li> Bewegen Sie als N\u00e4chstes den Mauszeiger \u00fcber den Rand der Zelle A2. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-Maus-\u00fcber-der-Zellengrenze\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-passez-la-souris-sur-la-bordure-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"hover-the-mouse-on-cell-border\" width=\"333\" height=\"152\"><\/li><li> Klicken Sie anschlie\u00dfend mit der Maus und ziehen Sie die Zelle zwischen den Zellen B2 und C2. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 Tropfen zwischen den Zellen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-goutte-entre-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"drop-between-cells\" width=\"334\" height=\"156\"><\/li><li> Am Ende legen Sie die Zelle dort ab, um Zellen untereinander auszutauschen. <br><img loading=\"lazy\" decoding=\"async\" title=\"6 Zellen wurden ausgetauscht\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-ont-ete-echangees.png\" sizes=\"auto, \" srcset=\"\" alt=\"cells-got-swapped\" width=\"337\" height=\"158\"><\/li><\/ol><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/excel-grundlagen\/\">Microsoft Excel-Grundlagen (Komponenten, Teile und Wissenshinweise)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/hyperlinks-hinzufugen-und-entfernen\/\">F\u00fcgen Sie Hyperlinks in Excel hinzu und entfernen Sie sie<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/wasserzeichen-hinzufugen\/\">F\u00fcgen Sie in Excel ein Wasserzeichen hinzu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/entfernen-sie-ausgeblendete-zeilenspalten\/\">L\u00f6schen Sie ausgeblendete Zeilen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zellen-abwahlen\/\">Zellen in Excel abw\u00e4hlen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-eine-spalte-hinzu\/\">F\u00fcgen Sie eine Spalte in Excel hinzu<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-3613","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>\u25b7 Wie tausche ich schnell zwei Zellen in Excel aus?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial lernen wir, wie man zwei Zellen miteinander vertauscht. Eine kurze Schritt-f\u00fcr-Schritt-Anleitung zum Erlernen dieses Tricks.\" \/>\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\/die-zelle-austauschen\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie tausche ich schnell zwei Zellen in Excel aus?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial lernen wir, wie man zwei Zellen miteinander vertauscht. Eine kurze Schritt-f\u00fcr-Schritt-Anleitung zum Erlernen dieses Tricks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:05:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif\" \/>\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\/die-zelle-austauschen\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/\",\"name\":\"\u25b7 Wie tausche ich schnell zwei Zellen in Excel aus?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif\",\"datePublished\":\"2023-10-14T05:07:37+00:00\",\"dateModified\":\"2023-12-03T13:05:10+00:00\",\"description\":\"In diesem Tutorial lernen wir, wie man zwei Zellen miteinander vertauscht. Eine kurze Schritt-f\u00fcr-Schritt-Anleitung zum Erlernen dieses Tricks.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie tausche ich zwei zellen in excel aus?\"}]},{\"@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":"\u25b7 Wie tausche ich schnell zwei Zellen in Excel aus?","description":"In diesem Tutorial lernen wir, wie man zwei Zellen miteinander vertauscht. Eine kurze Schritt-f\u00fcr-Schritt-Anleitung zum Erlernen dieses Tricks.","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\/die-zelle-austauschen\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie tausche ich schnell zwei Zellen in Excel aus?","og_description":"In diesem Tutorial lernen wir, wie man zwei Zellen miteinander vertauscht. Eine kurze Schritt-f\u00fcr-Schritt-Anleitung zum Erlernen dieses Tricks.","og_url":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:05:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif","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\/die-zelle-austauschen\/","url":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/","name":"\u25b7 Wie tausche ich schnell zwei Zellen in Excel aus?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif","datePublished":"2023-10-14T05:07:37+00:00","dateModified":"2023-12-03T13:05:10+00:00","description":"In diesem Tutorial lernen wir, wie man zwei Zellen miteinander vertauscht. Eine kurze Schritt-f\u00fcr-Schritt-Anleitung zum Erlernen dieses Tricks.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/echanger-des-cellules-excel.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/die-zelle-austauschen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie tausche ich zwei zellen in excel aus?"}]},{"@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\/3613","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=3613"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3613\/revisions"}],"predecessor-version":[{"id":4200,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3613\/revisions\/4200"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}