{"id":13466,"date":"2019-08-06T05:29:13","date_gmt":"2019-08-06T03:29:13","guid":{"rendered":"http:\/\/blog.wenzlaff.de\/?p=13466"},"modified":"2019-08-05T10:37:43","modified_gmt":"2019-08-05T08:37:43","slug":"excel-quickie-wie-koennen-excel-tabellen-referenzen-in-andere-arbeitsplaetter-eingefuegt-werden-in-mac-os-x","status":"publish","type":"post","link":"http:\/\/blog.wenzlaff.de\/?p=13466","title":{"rendered":"Excel-Quickie: Wie k\u00f6nnen Excel Tabellen-Referenzen bzw. Verkn\u00fcpfungen in andere Arbeitsbl\u00e4tter eingef\u00fcgt werden in Mac OS X?"},"content":{"rendered":"<p>1. Tabelle kopieren:<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.11.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.11.png\" alt=\"\" width=\"540\" height=\"686\" class=\"aligncenter size-full wp-image-13468\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.11.png 540w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.11-236x300.png 236w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><\/a><\/p>\n<p>2. Auf das Ziel Blatt gehen und Einf\u00fcgen:<!--more--><\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.24.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.24.png\" alt=\"\" width=\"499\" height=\"578\" class=\"aligncenter size-full wp-image-13469\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.24.png 499w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.24-259x300.png 259w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p>3. In dem kleinen Notizblock auf Zellen Verkn\u00fcpfung klicken:<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.37.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.37.png\" alt=\"\" width=\"778\" height=\"484\" class=\"aligncenter size-full wp-image-13470\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.37.png 778w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.37-300x187.png 300w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.37-768x478.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>4. Schon sind die Referenzen vorhanden:<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.48.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.48.png\" alt=\"\" width=\"489\" height=\"869\" class=\"aligncenter size-full wp-image-13471\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.48.png 489w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2019\/08\/Bildschirmfoto-2019-08-05-um-10.25.48-169x300.png 169w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/a><\/p>\n<p>Wenn es dann eine \u00c4nderung in der Haupttabelle gibt, wird es gleich in Verkn\u00fcpfung aktuallisiert.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Tabelle kopieren: 2. Auf das Ziel Blatt gehen und Einf\u00fcgen:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[220,2769,3187],"tags":[2310,3727,3728,3729],"class_list":["post-13466","post","type-post","status-publish","format-standard","hentry","category-anleitung","category-excel","category-office","tag-excel","tag-referenz","tag-tabelle","tag-tabellenblatt"],"_links":{"self":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/13466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13466"}],"version-history":[{"count":0,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/13466\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13466"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}