{"id":288,"date":"2022-08-22T04:19:55","date_gmt":"2022-08-22T01:19:55","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=288"},"modified":"2023-05-12T23:01:43","modified_gmt":"2023-05-12T20:01:43","slug":"kaip-pasidaryti-iskrentanti-sarasa","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=288","title":{"rendered":"Kaip pasidaryti i\u0161krentant\u012f s\u0105ra\u0161\u0105"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>\u012e Excel lentel\u0119 lengviau \u012fvesite duomenis, jeigu naudosite&nbsp;i\u0161krentant\u012f&nbsp;s\u0105ra\u0161\u0105 su nurodytais pavadinimais. Naudojant \u0161\u012f s\u0105ra\u0161\u0105, galima leisti \u012fvesti tik s\u0105ra\u0161e esan\u010dius duomenis. Taip i\u0161vengiama klaid\u0173 ir papras\u010diau \u012fvesti reikiam\u0105 informacij\u0105.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"142\" src=\"https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/1_1.jpg\" alt=\"\" class=\"wp-image-289\" title=\"1 pav. I\u0161krentan\u010dio s\u0105ra\u0161o pavyzdys\"\/><\/figure>\n\n\n\n<p>\u012e langelius nuo&nbsp;<strong>A1<\/strong>&nbsp;iki&nbsp;<strong>A5<\/strong>&nbsp;suvedame duomenis:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Citrina;<\/li>\n\n\n\n<li>Apelsinas;<\/li>\n\n\n\n<li>Obuolys;<\/li>\n\n\n\n<li>Mandarinas;<\/li>\n\n\n\n<li>Kriau\u0161\u0117.<\/li>\n<\/ul>\n\n\n\n<p><br>\u012e langel\u012f\u00a0<strong>C1<\/strong>\u00a0\u012fvedame <em>Vaisi\u0173 s\u0105ra\u0161as<\/em>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pa\u017eymime langel\u012f&nbsp;<strong>D1<\/strong>&nbsp;\u2013 viet\u0105, kurioje nor\u0117sime matyti rezultat\u0105.<\/li>\n\n\n\n<li>Spragtelime kortel\u0119&nbsp;<strong>DATA<\/strong>. Kortel\u0117je Data i\u0161skleid\u017eiame&nbsp;<strong>Data Validation<\/strong>&nbsp;meniu.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"153\" src=\"https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/2-validation.jpg\" alt=\"\" class=\"wp-image-290\" title=\"2 pav. Data validation pasirinkimas\" srcset=\"https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/2-validation.jpg 400w, https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/2-validation-300x115.jpg 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Spragtelime&nbsp;<strong>Data Validation<\/strong>&nbsp;komand\u0105 \u2013 atsidarys dialogo langas.<\/li>\n\n\n\n<li>Dialogo lange pasirenkame&nbsp;<strong>Settings<\/strong>.<\/li>\n\n\n\n<li>Dalyje&nbsp;<strong>Allow<\/strong>&nbsp;pasirenkame&nbsp;<strong>List<\/strong>.<\/li>\n\n\n\n<li>Dalies&nbsp;<strong>Source<\/strong>&nbsp;langelyje spragtelime pel\u0117s kairiuoju klavi\u0161u, kad pelyt\u0117s \u017eymeklis atsidurt\u0173 langelyje.<\/li>\n\n\n\n<li>Excel darbo knygos lape pelyte pa\u017eymime langelius&nbsp;<strong>A1\u2013A5<\/strong>.<\/li>\n\n\n\n<li>Dialogo lange spaud\u017eiame&nbsp;<strong>\u041eK<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"327\" height=\"259\" src=\"https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/3_1.jpg\" alt=\"\" class=\"wp-image-291\" title=\"3 pav. S\u0105ra\u0161o sudarymas\" srcset=\"https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/3_1.jpg 327w, https:\/\/kompiuteriu-kursai.lt\/wp-content\/uploads\/2022\/08\/3_1-300x238.jpg 300w\" sizes=\"auto, (max-width: 327px) 100vw, 327px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Langelyje&nbsp;<strong>D1<\/strong>&nbsp;turi atsirasti nukreipta \u017eemyn rodykl\u0117.<\/li>\n\n\n\n<li>Paspaudus \u0161i\u0105 rodykl\u0119, atsiranda vaisi\u0173 pavadinim\u0173 s\u0105ra\u0161as.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u012e Excel lentel\u0119 lengviau \u012fvesite duomenis, jeigu naudosite&nbsp;i\u0161krentant\u012f&nbsp;s\u0105ra\u0161\u0105 su nurodytais pavadinimais. Naudojant \u0161\u012f s\u0105ra\u0161\u0105, galima leisti \u012fvesti tik s\u0105ra\u0161e esan\u010dius duomenis. Taip i\u0161vengiama klaid\u0173 ir papras\u010diau \u012fvesti reikiam\u0105 informacij\u0105. \u012e langelius nuo&nbsp;A1&nbsp;iki&nbsp;A5&nbsp;suvedame duomenis: \u012e langel\u012f\u00a0C1\u00a0\u012fvedame Vaisi\u0173 s\u0105ra\u0161as:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[],"class_list":["post-288","post","type-post","status-publish","format-standard","hentry","category-ekspertai-pataria"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=288"}],"version-history":[{"count":9,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/288\/revisions"}],"predecessor-version":[{"id":3463,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/288\/revisions\/3463"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}