{"id":3737,"date":"2020-02-10T21:28:15","date_gmt":"2020-02-10T20:28:15","guid":{"rendered":"https:\/\/calculatic.pl\/dev\/?p=3737"},"modified":"2020-12-28T13:12:32","modified_gmt":"2020-12-28T12:12:32","slug":"usuwanie-listy-rozwijanej","status":"publish","type":"post","link":"https:\/\/calculatic.pl\/poradnik\/usuwanie-listy-rozwijanej\/","title":{"rendered":"Usuwanie listy rozwijanej"},"content":{"rendered":"\r\n<p>Po utworzeniu listy w Excelu mo\u017ce si\u0119 zdarzy\u0107, \u017ce jednak jej nie potrzebujemy. Mo\u017cna wi\u0119c list\u0119 rozwijana edytowa\u0107 lub usun\u0105\u0107 \u2013 nie wystarczy nacisn\u0105\u0107 klawisza DELETE. Na usuni\u0119cie listy rozwijanej sk\u0142ada si\u0119 kilka krok\u00f3w, kt\u00f3ra przestawimy.<\/p>\r\n<hr \/>\r\n<!--TOC-->\r\n<hr \/>\r\n\r\n\r\n<ul>\r\n<li>Nale\u017cy zaznaczy\u0107 ca\u0142y obszar w kt\u00f3rej znajduje si\u0119 lista rozwijana.<\/li>\r\n<li>Idziemy do zak\u0142adki DANE w menu Excela i klikamy ikon\u0119 POPRAWNO\u015aCI DANYCH<\/li>\r\n<li>Po pojawieniu si\u0119 okna dialogowego klikamy WYCZY\u015a\u0106 WSZYSTKO<\/li>\r\n<li>Na koniec klikamy przycisk OK.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2>Usuwanie listy rozwijanej z ca\u0142ego arkusza bez znajomo\u015bci po\u0142o\u017cenia:<\/h2>\r\n\r\n\r\n\r\n<p>Do wykonania tej czynno\u015bci s\u0142u\u017cy okno dialogowe znajduj\u0105ce si\u0119 w zak\u0142adce NARZ\u0118DZIA G\u0141\u00d3WNE.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>Nast\u0119pnie kliknij ZNAJD\u0179 I ZAZNACZ, PRZEJD\u0179 DO \u2013 SPECJALNE<\/li>\r\n<li>Mo\u017cna tak\u017ce u\u017cy\u0107 skr\u00f3tu klawiszowego CTRL + G i nast\u0119pne SPECJALNE<\/li>\r\n<li>Wybierz opcje SPRAWDZANIE POPRAWNO\u015aCI DANYCH \u2013 zaznaczy wszystkie menu rozwijane dost\u0119pne w arkuszu.<\/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>Po utworzeniu listy w Excelu mo\u017ce si\u0119 zdarzy\u0107, \u017ce jednak jej nie potrzebujemy. Mo\u017cna wi\u0119c&#8230; <a href=\"https:\/\/calculatic.pl\/poradnik\/usuwanie-listy-rozwijanej\/\" class=\"bwp-excerpt-more-link\">Czytaj wi\u0119cej<\/a><\/p>\n","protected":false},"author":1,"featured_media":3743,"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>Usuwanie listy rozwijanej Excel - jak usuna\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\/usuwanie-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=\"Usuwanie listy rozwijanej Excel - jak usuna\u0107 list\u0119 rozwijan\u0105? - Poradnik Excel\" \/>\r\n<meta property=\"og:description\" content=\"Po utworzeniu listy w Excelu mo\u017ce si\u0119 zdarzy\u0107, \u017ce jednak jej nie potrzebujemy. Mo\u017cna wi\u0119c... Czytaj wi\u0119cej\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/calculatic.pl\/poradnik\/usuwanie-listy-rozwijanej\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Poradnik Excel\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-02-10T20:28:15+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2020-12-28T12:12:32+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/usuwanie-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\/usuwanie-listy-rozwijanej\/#primaryimage\",\"inLanguage\":\"pl-PL\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/usuwanie-listy-rozwijanej.png\",\"width\":310,\"height\":210,\"caption\":\"Usuwanie listy rozwijanej\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/usuwanie-listy-rozwijanej\/#webpage\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/usuwanie-listy-rozwijanej\/\",\"name\":\"Usuwanie listy rozwijanej Excel - jak usuna\\u0107 list\\u0119 rozwijan\\u0105? - Poradnik Excel\",\"isPartOf\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/usuwanie-listy-rozwijanej\/#primaryimage\"},\"datePublished\":\"2020-02-10T20:28:15+00:00\",\"dateModified\":\"2020-12-28T12:12:32+00:00\",\"author\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#\/schema\/person\/b4ae4152be01d458be126ef1c77c6075\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/calculatic.pl\/poradnik\/usuwanie-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\/3737"}],"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=3737"}],"version-history":[{"count":4,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3737\/revisions"}],"predecessor-version":[{"id":5698,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3737\/revisions\/5698"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media\/3743"}],"wp:attachment":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media?parent=3737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/categories?post=3737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/tags?post=3737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}