{"id":3738,"date":"2020-02-10T21:28:11","date_gmt":"2020-02-10T20:28:11","guid":{"rendered":"https:\/\/calculatic.pl\/dev\/?p=3738"},"modified":"2020-12-28T13:12:09","modified_gmt":"2020-12-28T12:12:09","slug":"edycja-elementow-listy-rozwijanej","status":"publish","type":"post","link":"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/","title":{"rendered":"Edycja element\u00f3w listy rozwijanej"},"content":{"rendered":"\r\n<p>Wprowadzaj\u0105c dane do tabelek Excel cz\u0119sto pope\u0142niamy b\u0142\u0119dy. Tu z pomoc\u0105 przychodzi Lista rozwijana w Excelu. Dlaczego? Odpowied\u017a jest prosta.<\/p>\r\n<hr \/>\r\n<!--TOC-->\r\n<hr \/>\r\n\r\n\r\n<p>Gdy udost\u0119pniasz obcym osobom mo\u017cliwo\u015b\u0107 samemu skorygowania danych \u2013 niezale\u017cnie czy to przy pisaniu ankiet czy wype\u0142nianiu wniosk\u00f3w ludzie lubi\u0105 pope\u0142nia\u0107 b\u0142\u0119dy \u2013 lub podchodzi\u0107 do tego niechlujnie. Gdy masz opcj\u0119 wyboru i wystarczy zaznaczy\u0107 odpowiedni\u0105 mo\u017cliwo\u015b\u0107 jest wiele \u0142atwiej. Na podobnej zasadzie dzia\u0142a lista rozwijana w Excelu. Wybieramy jedn\u0105 z dost\u0119pnym opcji.<\/p>\r\n\r\n\r\n\r\n<p>Dzi\u0119ki narz\u0119dziu zwanym SPRAWDZANIE POPRAWNO\u015aCI DANYCH jeste\u015bmy w stanie zastosowa\u0107 mo\u017cliwo\u015b\u0107 wprowadzenia listy w Excelu.<\/p>\r\n\r\n\r\n\r\n<h2>Po utworzeniu listy rozwijanej w Excelu:<\/h2>\r\n\r\n\r\n\r\n<ul>\r\n<li>Mo\u017cesz ukry\u0107 list\u0119 pozycji zawartej w rozwijanym menu, tak aby osoby korzystaj\u0105ce z arkusza nie mogli wprowadzi\u0107 tam zmian albo po prostu jej nie widzieli. Aby to zrobi\u0107 ZABLOKUJ KOM\u00d3RK\u0118.<\/li>\r\n<li>Zobacz czy szeroko\u015b\u0107 kolumn jest wystarczaj\u0105ca do wprowadzania opcji z listy rozwijanej.<\/li>\r\n<li>Upewnij si\u0119, \u017ce wprowadzi\u0142e\u015b liste rozwijan\u0105 w odpowiednie miejsce \u2013 w przeciwnym wypadku b\u0119dziesz musia\u0142 usun\u0105\u0107 liste rozwij\u0105n\u0105 \u2013 podobnie ma si\u0119 sprawa, z edytowaniem pozycji na li\u015bcie rozwijanej.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<section class=\"calculatic\">\r\n<div class=\"col-md-12 col-xs-12\" style=\"margin-left: 0px;\">\r\n<div class=\"col-md-12 col-sm-12 col-xs-12\">\r\n<h5>Tysi\u0105ce film\u00f3w szkoleniowych z Excela<\/h5>\r\n<\/div>\r\n<div class=\"col-md-9 col-sm-9 col-xs-12\">\r\n<p>Sprawd\u017a za darmo calculatic.pl gdzie znajdziesz wiele wi\u0119cej przyk\u0142adowych zada\u0144!<\/p>\r\n<div class=\"button-calc\"><a class=\"button-calculatic\" href=\"https:\/\/calculatic.pl\">SPRAWD\u0179 ZA DARMO!<\/a><\/div>\r\n<\/div>\r\n<div class=\"col-md-3\">\u00a0<\/div>\r\n<\/div>\r\n<img class=\"hidden-xs\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2019\/11\/screen.png\" alt=\"\" \/> <img src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2019\/11\/white-logo-banner.png\" alt=\"\" \/><\/section>\r\n","protected":false},"excerpt":{"rendered":"<p>Wprowadzaj\u0105c dane do tabelek Excel cz\u0119sto pope\u0142niamy b\u0142\u0119dy. Tu z pomoc\u0105 przychodzi Lista rozwijana w&#8230; <a href=\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/\" class=\"bwp-excerpt-more-link\">Czytaj wi\u0119cej<\/a><\/p>\n","protected":false},"author":1,"featured_media":3746,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Edycja element\u00f3w listy rozwijanej Excel - Jak edytowa\u0107 list\u0119 rozwijan\u0105? - Poradnik Excel<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/\" \/>\r\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Edycja element\u00f3w listy rozwijanej Excel - Jak edytowa\u0107 list\u0119 rozwijan\u0105? - Poradnik Excel\" \/>\r\n<meta property=\"og:description\" content=\"Wprowadzaj\u0105c dane do tabelek Excel cz\u0119sto pope\u0142niamy b\u0142\u0119dy. Tu z pomoc\u0105 przychodzi Lista rozwijana w... Czytaj wi\u0119cej\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Poradnik Excel\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-02-10T20:28:11+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2020-12-28T12:12:09+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/edycja-elementow-listy-rozwijanej.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"310\" \/>\r\n\t<meta property=\"og:image:height\" content=\"210\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"1 minuta\">\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#website\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/\",\"name\":\"Poradnik Excel\",\"description\":\"Calculatic.pl\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/calculatic.pl\/poradnik\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/#primaryimage\",\"inLanguage\":\"pl-PL\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/edycja-elementow-listy-rozwijanej.png\",\"width\":310,\"height\":210,\"caption\":\"Edycja element\\u00f3w listy rozwijanej\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/#webpage\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/\",\"name\":\"Edycja element\\u00f3w listy rozwijanej Excel - Jak edytowa\\u0107 list\\u0119 rozwijan\\u0105? - Poradnik Excel\",\"isPartOf\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/#primaryimage\"},\"datePublished\":\"2020-02-10T20:28:11+00:00\",\"dateModified\":\"2020-12-28T12:12:09+00:00\",\"author\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#\/schema\/person\/b4ae4152be01d458be126ef1c77c6075\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/calculatic.pl\/poradnik\/edycja-elementow-listy-rozwijanej\/\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#\/schema\/person\/b4ae4152be01d458be126ef1c77c6075\",\"name\":\"poradnik_user\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#personlogo\",\"inLanguage\":\"pl-PL\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e446533ab5321dff25fa238d4f33eb78?s=96&d=blank&r=g\",\"caption\":\"poradnik_user\"}}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3738"}],"collection":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/comments?post=3738"}],"version-history":[{"count":4,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3738\/revisions"}],"predecessor-version":[{"id":5700,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3738\/revisions\/5700"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media\/3746"}],"wp:attachment":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media?parent=3738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/categories?post=3738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/tags?post=3738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}