{"id":6752,"date":"2021-03-18T12:34:00","date_gmt":"2021-03-18T11:34:00","guid":{"rendered":"https:\/\/calculatic.pl\/poradnik\/?p=6752"},"modified":"2021-09-23T13:03:59","modified_gmt":"2021-09-23T11:03:59","slug":"sortowanie-z-uwzglednieniem-wielkosci-liter","status":"publish","type":"post","link":"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/","title":{"rendered":"Sortowanie z uwzgl\u0119dnieniem wielko\u015bci liter"},"content":{"rendered":"<p>Wi\u0119kszo\u015b\u0107 narz\u0119dzi Excela nie zwraca uwagi na wielko\u015b\u0107 znak\u00f3w w tekstach. Podobnie jest przy sortowaniu \u2013 ma\u0142a litera \u201ea\u201d jest traktowana tak samo jak du\u017ca \u201eA\u201d. Mo\u017cesz jednak to zmieni\u0107 w oknie <strong>Sortowanie,<\/strong> pod przyciskiem <strong>Opcje<\/strong> \u2013 zaznacz pole <strong>Uwzgl\u0119dnij wielko\u015b\u0107 liter<\/strong>.<\/p>\n<p><em>Rysunek 1. Otwarcie okno sortowania w g\u00f3rnym menu Excela.<\/em><img loading=\"lazy\" class=\"alignnone wp-image-6755\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-3-przycisk-sortuj-w-menu-excela.png\" alt=\"\" width=\"352\" height=\"98\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-3-przycisk-sortuj-w-menu-excela.png 453w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-3-przycisk-sortuj-w-menu-excela-300x83.png 300w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/p>\n<p><em>Rysunek 2. Okno sortowania i przycisk Opcje.<\/em><img loading=\"lazy\" class=\"alignnone wp-image-6753\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-1-okno-sortowanie.png\" alt=\"\" width=\"462\" height=\"197\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-1-okno-sortowanie.png 629w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-1-okno-sortowanie-300x128.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/p>\n<p><em> Rysunek 3. Opcja uwzgl\u0119dniania wielko\u015bci liter podczas sortowania w Excelu.<\/em><img loading=\"lazy\" class=\"alignnone wp-image-6754\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/rys-2-uwzglednienie-wielkosci-liter.png\" alt=\"\" width=\"161\" height=\"136\" \/> Nale\u017cy przy tym pami\u0119ta\u0107 o dw\u00f3ch regu\u0142ach:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Zasada jest taka, \u017ce ma\u0142e litery s\u0105 przed du\u017cymi \u2013 np. \u201ea\u201d jest przed \u201eA\u201d<\/strong>.<\/li>\n<li>Pami\u0119taj jednak, <strong>\u017ce wielko\u015b\u0107 znak\u00f3w jest brana pod uwag\u0119 dopiero wtedy, gdy dwa teksty s\u0105 dok\u0142adnie takie same<\/strong>. Je\u015bli w jednej kom\u00f3rce znajduje si\u0119 \u201eac\u201d, a w drugiej \u201eAb\u201d, to nie jest wa\u017cny rozmiar litery \u201ea\u201d bo drugie litery s\u0105 r\u00f3\u017cne \u2013 oczywi\u015bcie \u201eb\u201d jest przed \u201ec\u201d. Dopiero gdy s\u0105 dwa takie same teksty, ale o r\u00f3\u017cnej wielko\u015bci znak\u00f3w (\u201eac\u201d oraz \u201eAc\u201d), to ten zapisany z ma\u0142ej litery b\u0119dzie wy\u017cej na li\u015bcie.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Wi\u0119kszo\u015b\u0107 narz\u0119dzi Excela nie zwraca uwagi na wielko\u015b\u0107 znak\u00f3w w tekstach. Podobnie jest przy sortowaniu&#8230; <a href=\"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/\" class=\"bwp-excerpt-more-link\">Czytaj wi\u0119cej<\/a><\/p>\n","protected":false},"author":1,"featured_media":6799,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Sortowanie z uwzgl\u0119dnieniem wielko\u015bci liter - 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\/sortowanie-z-uwzglednieniem-wielkosci-liter\/\" \/>\r\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Sortowanie z uwzgl\u0119dnieniem wielko\u015bci liter - Poradnik Excel\" \/>\r\n<meta property=\"og:description\" content=\"Wi\u0119kszo\u015b\u0107 narz\u0119dzi Excela nie zwraca uwagi na wielko\u015b\u0107 znak\u00f3w w tekstach. Podobnie jest przy sortowaniu... Czytaj wi\u0119cej\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Poradnik Excel\" \/>\r\n<meta property=\"article:published_time\" content=\"2021-03-18T11:34:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2021-09-23T11:03:59+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/wielkosc-znakow.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"400\" \/>\r\n\t<meta property=\"og:image:height\" content=\"300\" \/>\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\/sortowanie-z-uwzglednieniem-wielkosci-liter\/#primaryimage\",\"inLanguage\":\"pl-PL\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2021\/03\/wielkosc-znakow.png\",\"width\":400,\"height\":300},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/#webpage\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/\",\"name\":\"Sortowanie z uwzgl\\u0119dnieniem wielko\\u015bci liter - Poradnik Excel\",\"isPartOf\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/#primaryimage\"},\"datePublished\":\"2021-03-18T11:34:00+00:00\",\"dateModified\":\"2021-09-23T11:03:59+00:00\",\"author\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#\/schema\/person\/b4ae4152be01d458be126ef1c77c6075\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/calculatic.pl\/poradnik\/sortowanie-z-uwzglednieniem-wielkosci-liter\/\"]}]},{\"@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\/6752"}],"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=6752"}],"version-history":[{"count":1,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/6752\/revisions"}],"predecessor-version":[{"id":6756,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/6752\/revisions\/6756"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media\/6799"}],"wp:attachment":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media?parent=6752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/categories?post=6752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/tags?post=6752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}