{"id":3687,"date":"2020-02-09T21:17:38","date_gmt":"2020-02-09T20:17:38","guid":{"rendered":"https:\/\/calculatic.pl\/dev\/?p=3687"},"modified":"2020-12-28T15:09:44","modified_gmt":"2020-12-28T14:09:44","slug":"jak-posortowac-dane-w-excelu","status":"publish","type":"post","link":"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/","title":{"rendered":"Jak posortowa\u0107 dane w Excelu"},"content":{"rendered":"\r\n<p>Podczas pracy z arkuszami cz\u0119sto wyst\u0119puje potrzeba uszeregowania danych wg wybranego kryterium. Opiszemy tu kilka sposob\u00f3w sortowania danych w Excelu.<\/p>\r\n<hr \/>\r\n<div id=\"toc_container\" class=\"toc_white no_bullets\"><ul class=\"toc_list\"><li><a href=\"#Proste_sortowanie\"><span class=\"toc_number toc_depth_1\">1<\/span> Proste sortowanie<\/a><ul><li><a href=\"#Sortowanie_na_2_poziomach\"><span class=\"toc_number toc_depth_2\">1.1<\/span> Sortowanie na 2 poziomach<\/a><\/li><li><a href=\"#Sortowanie_wg_innych_kryteriow\"><span class=\"toc_number toc_depth_2\">1.2<\/span> Sortowanie wg innych kryteri\u00f3w<\/a><\/li><li><a href=\"#Kolejnosc_sortowania_wg_specjalnego_klucza\"><span class=\"toc_number toc_depth_2\">1.3<\/span> Kolejno\u015b\u0107 sortowania wg specjalnego klucza<\/a><\/li><\/ul><\/li><\/ul><\/div>\n\r\n<hr \/>\r\n\r\n\r\n<h1><span id=\"Proste_sortowanie\">Proste sortowanie<\/span><\/h1>\r\n\r\n\r\n\r\n<p>Je\u015bli chcemy posortowa\u0107 tabel\u0119 wg warto\u015bci jednej kolumny (rosn\u0105co lub malej\u0105co) wystarczy, je\u015bli wybierzemy dowoln\u0105 kom\u00f3rk\u0119 z kolumny i klikniemy ikon\u0119 sortowania (rosn\u0105co A\u2192Z lub malej\u0105co Z\u2192A).<\/p>\r\n\r\n\r\n\r\n<p>W poni\u017cszym przyk\u0142adzie sortujemy tabel\u0119 wg kolumny <em>Wielko\u015b\u0107 zam\u00f3wienia<\/em> od warto\u015bci najwi\u0119kszych do najmniejszych.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3690\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/1-jak-posortowac.png\" alt=\"sortowanie excel\" width=\"506\" height=\"629\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/1-jak-posortowac.png 506w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/1-jak-posortowac-241x300.png 241w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>I oto efekt:<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3699\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/2-jak-posortowac-dane-w-excelu-1.png\" alt=\"excel sortowanie\" width=\"916\" height=\"550\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/2-jak-posortowac-dane-w-excelu-1.png 916w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/2-jak-posortowac-dane-w-excelu-1-300x180.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/2-jak-posortowac-dane-w-excelu-1-768x461.png 768w\" sizes=\"(max-width: 916px) 100vw, 916px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h2><span id=\"Sortowanie_na_2_poziomach\">Sortowanie na 2 poziomach<\/span><\/h2>\r\n\r\n\r\n\r\n<p>Je\u015bli tabela ma by\u0107 posortowana wg 2 kryteri\u00f3w np. najpierw miasta alfabetycznie, a nast\u0119pnie (w obr\u0119bie danego miasta) wg wielko\u015bci zam\u00f3wienia (malej\u0105co) u\u017cyjemy sortowania wielopoziomowego. Najpierw wybieramy dowoln\u0105 kom\u00f3rk\u0119 z naszej tabeli przeznaczonej do posortowania, a nast\u0119pnie klikamy ikon\u0119 <strong>Sortuj<\/strong> na wst\u0105\u017cce <strong>Dane<\/strong>.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3700\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/3-sortowanie-na-dwoch-poziomach-1-1024x590.png\" alt=\"sortowanie w excelu\" width=\"1024\" height=\"590\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/3-sortowanie-na-dwoch-poziomach-1-1024x590.png 1024w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/3-sortowanie-na-dwoch-poziomach-1-300x173.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/3-sortowanie-na-dwoch-poziomach-1-768x442.png 768w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/3-sortowanie-na-dwoch-poziomach-1.png 1085w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>W okienku <em>Sortuj wed\u0142ug<\/em> wybieramy pierwsze kryterium sortowania (tu: <strong>Miasto<\/strong>).<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3701\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/4-tu-miasto-1.png\" alt=\"sortowanie danych excel\" width=\"954\" height=\"423\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/4-tu-miasto-1.png 954w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/4-tu-miasto-1-300x133.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/4-tu-miasto-1-768x341.png 768w\" sizes=\"(max-width: 954px) 100vw, 954px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Nast\u0119pnie klikamy przycisk <strong>+Dodaj poziom<\/strong>.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3702\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/5-dodaj-poziom-1.png\" alt=\"jak sortowa\u0107 w excelu\" width=\"943\" height=\"409\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/5-dodaj-poziom-1.png 943w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/5-dodaj-poziom-1-300x130.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/5-dodaj-poziom-1-768x333.png 768w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>W okienku <em>Nast\u0119pnie wed\u0142ug<\/em> wybieramy kolejne kryterium (tu: <em>Wielko\u015b\u0107 zam\u00f3wienia<\/em>), a w okienku <em>Kolejno\u015b\u0107<\/em> opcj\u0119 <em>Od najwi\u0119kszych do najmniejszych<\/em>.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3703\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/6-wielkosc-zamowienia-1.png\" alt=\"jak posortowa\u0107 dane w excelu\" width=\"1018\" height=\"404\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/6-wielkosc-zamowienia-1.png 1018w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/6-wielkosc-zamowienia-1-300x119.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/6-wielkosc-zamowienia-1-768x305.png 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Klikamy <strong>OK<\/strong> i sortowanie wykonane.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3704\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/7-klikamy-ok-1-1024x513.png\" alt=\"excel sortowanie danych\" width=\"1024\" height=\"513\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/7-klikamy-ok-1-1024x513.png 1024w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/7-klikamy-ok-1-300x150.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/7-klikamy-ok-1-768x385.png 768w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/7-klikamy-ok-1.png 1279w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h2><span id=\"Sortowanie_wg_innych_kryteriow\">Sortowanie wg innych kryteri\u00f3w<\/span><\/h2>\r\n\r\n\r\n\r\n<p>Tabel\u0119 mo\u017cemy sortowa\u0107 nie tylko wg warto\u015bci, ale tak\u017ce wg innych cech kom\u00f3rek jak np. koloru wype\u0142nienia. Je\u015bli kom\u00f3rki zawieraj\u0105ce warto\u015bci zosta\u0142y przez nas wyr\u00f3\u017cnione r\u00f3\u017cnymi kolorami wype\u0142nienia, mo\u017cemy tabel\u0119 posortowa\u0107 wg tej cechy kom\u00f3rek.<\/p>\r\n\r\n\r\n\r\n<p>W poni\u017cszym przyk\u0142adzie wybrane kom\u00f3rki kolumny zosta\u0142y wype\u0142nione kolorami: czerwonym i \u017c\u00f3\u0142tym. Chcemy posortowa\u0107 tabel\u0119 wg kolor\u00f3w: najpierw czerwone kom\u00f3rki, nast\u0119pnie \u017c\u00f3\u0142te i dopiero niewype\u0142nione kolorem.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3705\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/8-sortowanie-wedlug-innych-kryteriow-1-1024x535.png\" alt=\"sortowanie exel\" width=\"1024\" height=\"535\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/8-sortowanie-wedlug-innych-kryteriow-1-1024x535.png 1024w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/8-sortowanie-wedlug-innych-kryteriow-1-300x157.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/8-sortowanie-wedlug-innych-kryteriow-1-768x401.png 768w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/8-sortowanie-wedlug-innych-kryteriow-1.png 1277w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Jak w ka\u017cdym przypadku sortowania najpierw zaznaczamy dowoln\u0105 kom\u00f3rk\u0119 w tabeli, a nast\u0119pnie wybieramy narz\u0119dzie <strong>Sortuj<\/strong>.<\/p>\r\n\r\n\r\n\r\n<p>W okienku <em>Sortuj wed\u0142ug<\/em> wybieramy kolumn\u0119 <strong>Klient<\/strong>, w okienku <em>Sortowanie<\/em> &#8211; <strong>kolor kom\u00f3rki<\/strong>, a w trzecim okienku <em>Kolejno\u015b\u0107<\/em> \u2013 kolor, kt\u00f3rym wype\u0142nione kom\u00f3rki maj\u0105 by\u0107 na g\u00f3rze kolumny (tu: czerwony.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3706\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/9-kolor-komorki-1.png\" alt=\"sortowanie tabeli excel\" width=\"946\" height=\"408\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/9-kolor-komorki-1.png 946w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/9-kolor-komorki-1-300x129.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/9-kolor-komorki-1-768x331.png 768w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Nast\u0119pnie dodajemy kolejny poziom z pierwszymi 2 parametrami jak poprzednio (lub klikamy <strong>Kopiuj poziom<\/strong>),\u00a0 a w okienku <em>Kolejno\u015b\u0107<\/em> wybieramy kolor \u017c\u00f3\u0142ty.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3707\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/10-kopiuj-poziom.png\" alt=\"excel sortowanie zaawansowane\" width=\"937\" height=\"399\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/10-kopiuj-poziom.png 937w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/10-kopiuj-poziom-300x128.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/10-kopiuj-poziom-768x327.png 768w\" sizes=\"(max-width: 937px) 100vw, 937px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Oto efekt sortowania wg kolor\u00f3w kom\u00f3rek.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3708\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/11-efekt-sortowania-wedlug-koloru-1024x316.png\" alt=\"sortowanie excel\" width=\"1024\" height=\"316\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/11-efekt-sortowania-wedlug-koloru-1024x316.png 1024w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/11-efekt-sortowania-wedlug-koloru-300x93.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/11-efekt-sortowania-wedlug-koloru-768x237.png 768w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/11-efekt-sortowania-wedlug-koloru.png 1273w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h2><span id=\"Kolejnosc_sortowania_wg_specjalnego_klucza\">Kolejno\u015b\u0107 sortowania wg specjalnego klucza<\/span><\/h2>\r\n\r\n\r\n\r\n<p>Gdy zachodzi konieczno\u015b\u0107 posortowania tabeli wg kolumny zawieraj\u0105cej warto\u015bci tekstowe, ale w kolejno\u015bci ustalonej przez nas (niealfabetycznej), u\u017cyjemy tzw. <em>list niestandardowych<\/em>.<\/p>\r\n\r\n\r\n\r\n<p>Poni\u017cej mamy przyk\u0142ad tabeli, gdzie w kolumnie A wyst\u0119puj\u0105 symbole 3 dzia\u0142\u00f3w. Tabel\u0119 chcemy posortowa\u0107 wg nast\u0119puj\u0105cej kolejno\u015bci dzia\u0142\u00f3w: EF-2, DP-1, KK-2. W tym celu niezb\u0119dne b\u0119dzie stworzenie nowej listy niestandardowej z symbolami tych dzia\u0142\u00f3w\u2026<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3709\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/12-specjalny-klucz.png\" alt=\"excel sortowanie\" width=\"411\" height=\"541\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/12-specjalny-klucz.png 411w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/12-specjalny-klucz-228x300.png 228w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Wybieramy kom\u00f3rk\u0119 w zakresie danych i klikamy Sortuj.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3710\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/13-sortuj.png\" alt=\"sortowanie w excelu\" width=\"945\" height=\"405\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/13-sortuj.png 945w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/13-sortuj-300x129.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/13-sortuj-768x329.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>W okienkach opcji kolejno wybieramy: <em>Dzia\u0142, Warto\u015bci kom\u00f3rek i Lista niestandardowa\u2026<\/em><\/p>\r\n\r\n\r\n\r\n<p>Otworzy si\u0119 nowe okienko z listami niestandardowymi. Wpisujemy w nim symbole dzia\u0142\u00f3w w takiej kolejno\u015bci, wg kt\u00f3rej ma by\u0107 tabelka posortowana.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3711\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/14-nowa-lista.png\" alt=\"sortowanie danych excel\" width=\"982\" height=\"573\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/14-nowa-lista.png 982w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/14-nowa-lista-300x175.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/14-nowa-lista-768x448.png 768w\" sizes=\"(max-width: 982px) 100vw, 982px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Klikamy OK i tabela zostaje posortowana<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3712\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/15-klikamy-ok.png\" alt=\"jak sortowa\u0107 w excelu\" width=\"940\" height=\"401\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/15-klikamy-ok.png 940w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/15-klikamy-ok-300x128.png 300w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/15-klikamy-ok-768x328.png 768w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3713\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/16-ef-2.png\" alt=\"jak posortowa\u0107 dane w excelu\" width=\"412\" height=\"546\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/16-ef-2.png 412w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/16-ef-2-226x300.png 226w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Proste sortowanie mo\u017cemy wykona\u0107 r\u00f3wnie\u017c za pomoc\u0105 narz\u0119dzia <strong>Filtrowanie<\/strong>. Dzia\u0142a ono w identyczny spos\u00f3b jak proste filtrowanie.<\/p>\r\n\r\n\r\n\r\n<p>W kolumnie wg kt\u00f3rej chcemy sortowa\u0107 rozwijamy narz\u0119dzie filtru i wybieramy rodzaj sortowania.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" class=\"alignnone wp-image-3714\" src=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/17-rodzaj-sortowania.png\" alt=\"sortowanie exel\" width=\"662\" height=\"373\" srcset=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/17-rodzaj-sortowania.png 662w, https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/02\/17-rodzaj-sortowania-300x169.png 300w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Efekt b\u0119dzie taki sam jak przy bezpo\u015brednim korzystaniu z narz\u0119dzia sortowania.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>1 Proste sortowanie1.1 Sortowanie na 2 poziomach1.2 Sortowanie wg innych kryteri\u00f3w1.3 Kolejno\u015b\u0107 sortowania wg specjalnego&#8230; <a href=\"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/\" class=\"bwp-excerpt-more-link\">Czytaj wi\u0119cej<\/a><\/p>\n","protected":false},"author":1,"featured_media":5994,"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>Jak posortowa\u0107 dane w Excelu - 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\/jak-posortowac-dane-w-excelu\/\" \/>\r\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Jak posortowa\u0107 dane w Excelu - Poradnik Excel\" \/>\r\n<meta property=\"og:description\" content=\"1 Proste sortowanie1.1 Sortowanie na 2 poziomach1.2 Sortowanie wg innych kryteri\u00f3w1.3 Kolejno\u015b\u0107 sortowania wg specjalnego... Czytaj wi\u0119cej\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Poradnik Excel\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-02-09T20:17:38+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2020-12-28T14:09:44+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/12\/2-6.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"937\" \/>\r\n\t<meta property=\"og:image:height\" content=\"625\" \/>\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=\"2 minuty\">\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\/jak-posortowac-dane-w-excelu\/#primaryimage\",\"inLanguage\":\"pl-PL\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/wp-content\/uploads\/2020\/12\/2-6.png\",\"width\":937,\"height\":625,\"caption\":\"Jak posortowa\\u0107 dane w Excelu\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/#webpage\",\"url\":\"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/\",\"name\":\"Jak posortowa\\u0107 dane w Excelu - Poradnik Excel\",\"isPartOf\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/#primaryimage\"},\"datePublished\":\"2020-02-09T20:17:38+00:00\",\"dateModified\":\"2020-12-28T14:09:44+00:00\",\"author\":{\"@id\":\"https:\/\/calculatic.pl\/poradnik\/#\/schema\/person\/b4ae4152be01d458be126ef1c77c6075\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/calculatic.pl\/poradnik\/jak-posortowac-dane-w-excelu\/\"]}]},{\"@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\/3687"}],"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=3687"}],"version-history":[{"count":6,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3687\/revisions"}],"predecessor-version":[{"id":6187,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/posts\/3687\/revisions\/6187"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media\/5994"}],"wp:attachment":[{"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/media?parent=3687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/categories?post=3687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/calculatic.pl\/poradnik\/wp-json\/wp\/v2\/tags?post=3687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}