{"id":319,"date":"2020-05-21T17:48:23","date_gmt":"2020-05-21T17:48:23","guid":{"rendered":"https:\/\/bethecoach.pl\/?p=319"},"modified":"2026-04-01T11:37:59","modified_gmt":"2026-04-01T11:37:59","slug":"filtrowanie-danych-w-excelu","status":"publish","type":"post","link":"https:\/\/bethecoach.pl\/index.php\/2020\/05\/21\/filtrowanie-danych-w-excelu\/","title":{"rendered":"Filtrowanie danych w Excelu."},"content":{"rendered":"\n<p>Ostatnio nauczyli\u015bmy si\u0119 szuka\u0107 warto\u015bci w arkuszu. Co jednak, gdy chcemy wybra\u0107 jak\u0105\u015b grup\u0119 warto\u015bci z tabeli maj\u0105c\u0105 jakie\u015b cechy wsp\u00f3lne? Z pomoc\u0105 przychodzi <strong>filtrowanie danych.<\/strong> Zapraszam!<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Kurs Excel #7 Filtrowanie danych w Excelu\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/aZF28gL46zA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<!--more-->\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Aby w\u0142\u0105czy\u0107 filtrowanie na naszych danych (tabeli) musimy znajdowa\u0107 si\u0119 w obr\u0119bie danych z warto\u015bciami \u2013 wewn\u0105trz naszej tabeli. Mo\u017cemy tak\u017ce zaznaczy\u0107 pewien obszar, na przyk\u0142ad ca\u0142y pierwszy wiersz, na kt\u00f3rym chcemy w\u0142\u0105czy\u0107 filtrowanie. <strong>\u017beby \u201ena\u0142o\u017cy\u0107\u201d filtry na dane kolumny wybierz opcj\u0119 <em>Filter<\/em> z zak\u0142adki <em>Home<\/em> -&gt; <em>Sort&amp;Filter<\/em> lub z zak\u0142adki <em>Data.<\/em><\/strong><\/p>\n\n\n\n<div style=\"height:31px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"272\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-1024x272.jpg\" alt=\"\" class=\"wp-image-320\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-1024x272.jpg 1024w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-300x80.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-768x204.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-24x6.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-36x10.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter-48x13.jpg 48w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filter.jpg 1357w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Wyb\u00f3r opcji Filter<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Zach\u0119cam Ci\u0119 jednak do u\u017cywania skr\u00f3tu klawiaturowego (a jak\u017ce!), kt\u00f3ry znacznie przyspieszy twoj\u0105 prac\u0119. <strong>Aby w\u0142\u0105czy\u0107 filtry wystarczy, \u017ce naci\u015bniesz skr\u00f3t klawiaturowy CTRL + SHIFT + L. <\/strong>W\u0142\u0105czenie opcji filtrowania na danej tabeli zasygnalizuje Ci pojawienie si\u0119 <strong>kwadracik\u00f3w z tr\u00f3jk\u0105tami wewn\u0105trz w kom\u00f3rkach<\/strong>, od kt\u00f3rych b\u0119dziesz zaczyna\u0107 filtrowanie (najcz\u0119\u015bciej b\u0119d\u0105 to warto\u015bci w pierwszym wierszu).<\/p>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"719\" height=\"202\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/symbole-filtrowania.jpg\" alt=\"\" class=\"wp-image-321\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/symbole-filtrowania.jpg 719w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/symbole-filtrowania-300x84.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/symbole-filtrowania-24x7.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/symbole-filtrowania-36x10.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/symbole-filtrowania-48x13.jpg 48w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><figcaption>Symbole filtrowania<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:56px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Nast\u0119pnie wystarczy, \u017ce <strong>zaznaczysz warto\u015bci, kt\u00f3re chcesz pokaza\u0107. Mo\u017cesz tak\u017ce odznaczy\u0107 niechciane warto\u015bci \u2013 wiersze z tymi warto\u015bciami zostan\u0105 ukryte<\/strong>. Pami\u0119taj, <strong><em>Excel<\/em> nie usuwa odfiltrowanych danych, a jedynie je ukrywa<\/strong>.<\/p>\n\n\n\n<div style=\"height:47px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Wybor-w-filtrze.jpg\" alt=\"\" class=\"wp-image-322\" width=\"633\" height=\"485\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Wybor-w-filtrze.jpg 678w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Wybor-w-filtrze-300x230.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Wybor-w-filtrze-24x18.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Wybor-w-filtrze-36x28.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Wybor-w-filtrze-48x37.jpg 48w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><figcaption>Wyb\u00f3r warto\u015bci, po kt\u00f3rych chcemy przefiltrowa\u0107 dane<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Mo\u017cesz korzysta\u0107 z <strong>wielu opcji filtrowania<\/strong>. Pierwszym przyk\u0142adem b\u0119dzie <strong>filtrowanie po kolorach<\/strong> (czyli wybierania warto\u015bci o okre\u015blonym kolorze).<\/p>\n\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"473\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/po-kolorze.jpg\" alt=\"\" class=\"wp-image-323\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/po-kolorze.jpg 640w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/po-kolorze-300x222.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/po-kolorze-24x18.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/po-kolorze-36x27.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/po-kolorze-48x35.jpg 48w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption>Filtrowanie po kolorze<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Ponadto <strong><em>Excel<\/em> oferuje Ci wiele ciekawych opcji zar\u00f3wno do filtrowania tekstu, jak i liczb<\/strong>.<\/p>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-tekstu.jpg\" alt=\"\" class=\"wp-image-324\" width=\"633\" height=\"457\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-tekstu.jpg 697w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-tekstu-300x216.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-tekstu-24x17.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-tekstu-36x26.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-tekstu-48x35.jpg 48w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><figcaption>Opcje filtrowania tekstu<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:67px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-liczb.jpg\" alt=\"\" class=\"wp-image-325\" width=\"521\" height=\"512\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-liczb.jpg 556w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-liczb-300x295.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-liczb-24x24.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-liczb-36x36.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Filtrowanie-liczb-48x48.jpg 48w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><figcaption>Opcje filtrowania liczb<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>O tym, jak z nich korzysta\u0107 pokazuje w lekcji video do\u0142\u0105czonej do tego filmu<\/strong>, do kt\u00f3rej obejrzenia Ci\u0119 serdecznie zapraszam!<\/p>\n\n\n\n<div style=\"height:47px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Kurs Excel #7 Filtrowanie danych w Excelu\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/aZF28gL46zA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Ostatnio nauczyli\u015bmy si\u0119 szuka\u0107 warto\u015bci w arkuszu. Co jednak, gdy chcemy wybra\u0107 jak\u0105\u015b grup\u0119 warto\u015bci z tabeli maj\u0105c\u0105 jakie\u015b cechy wsp\u00f3lne? Z pomoc\u0105 przychodzi filtrowanie danych. Zapraszam!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-319","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/comments?post=319"}],"version-history":[{"count":2,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/319\/revisions\/327"}],"wp:attachment":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/media?parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/categories?post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/tags?post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}