{"id":7889,"date":"2017-03-16T05:05:03","date_gmt":"2017-03-16T04:05:03","guid":{"rendered":"http:\/\/blog.wenzlaff.de\/?p=7889"},"modified":"2018-09-07T16:26:38","modified_gmt":"2018-09-07T14:26:38","slug":"excel-2016-mac-os-x-wie-werden-auswahllisten-erstellt","status":"publish","type":"post","link":"http:\/\/blog.wenzlaff.de\/?p=7889","title":{"rendered":"Excel 2016 Mac OS X: Wie werden Auswahllisten erstellt?"},"content":{"rendered":"<p>Wer so eine Auswahlbox mit Werten und Tooltip in Excel haben will:<br \/>\n<a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.14.04.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.14.04.png\" alt=\"\" width=\"254\" height=\"125\" class=\"aligncenter size-full wp-image-7890\" \/><\/a><\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.14.14.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.14.14.png\" alt=\"\" width=\"229\" height=\"128\" class=\"aligncenter size-full wp-image-7891\" \/><\/a><\/p>\n<p>1. Klick im Men\u00fc <strong>Daten<\/strong> auf <strong>Daten\u00fcberpr\u00fcfung<\/strong><!--more--><\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.40.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.40.png\" alt=\"\" width=\"550\" height=\"421\" class=\"aligncenter size-full wp-image-7892\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.40.png 550w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.40-300x230.png 300w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/a><\/p>\n<p>2. In Einstellungen den Bereich der <strong>Quelle<\/strong> eingeben<\/p>\n<p>3. Evl. noch Meldungen f\u00fcr Eingabe<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.47.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.47.png\" alt=\"\" width=\"549\" height=\"423\" class=\"aligncenter size-full wp-image-7893\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.47.png 549w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.47-300x231.png 300w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/a><\/p>\n<p>4. Evl. noch Meldung f\u00fcr Fehler<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.54.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.54.png\" alt=\"\" width=\"546\" height=\"421\" class=\"aligncenter size-full wp-image-7894\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.54.png 546w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/03\/Bildschirmfoto-2017-03-15-um-19.15.54-300x231.png 300w\" sizes=\"auto, (max-width: 546px) 100vw, 546px\" \/><\/a><\/p>\n<p>Das ist alles.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wer so eine Auswahlbox mit Werten und Tooltip in Excel haben will: 1. Klick im Men\u00fc Daten auf Daten\u00fcberpr\u00fcfung<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[2769],"tags":[2771,2772,2770,2774,2775,2773],"class_list":["post-7889","post","type-post","status-publish","format-standard","hentry","category-excel","tag-auswahl","tag-auswahlbox","tag-combobox","tag-tooltip","tag-ueerpruefung","tag-wertebereich"],"_links":{"self":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/7889","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=7889"}],"version-history":[{"count":0,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/7889\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7889"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}