{"id":2549,"date":"2020-07-09T10:14:46","date_gmt":"2020-07-09T10:14:46","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=2549"},"modified":"2021-03-30T06:36:54","modified_gmt":"2021-03-30T06:36:54","slug":"cum-adaugam-null-blank-celula-goala-ca-prima-optiune-intr-o-lista-derulanta-folosind-data-validation-in-excel","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/cum-adaugam-null-blank-celula-goala-ca-prima-optiune-intr-o-lista-derulanta-folosind-data-validation-in-excel\/","title":{"rendered":"Celula blank cu Data Validation in Excel"},"content":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text]<\/p>\n<h3 style=\"text-align: left;\"><strong>Cursuri Office<\/strong><\/h3>\n<h4 style=\"text-align: left;\">Cursuri Excel<\/h4>\n<p style=\"text-align: left;\"><em>De-a lungul celor 5 ani de activitate ne-am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant.<\/em><\/p>\n<p>[\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;996&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221; qode_css_animation=&#8221;&#8221;][vc_column_text]<\/p>\n<h5><\/h5>\n<h5 style=\"text-align: left;\">&#8222;Learn today for tomorrow!&#8221;<\/h5>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;3\/4&#8243;]<div class=\"qode-advanced-tabs qode-advanced-tabs qode-advanced-horizontal-tab clearfix qode-advanced-tab-without-icon qode-advanced-tabs-column-0 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-tab-513\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Cum adaugam null\/blank\/celula goala ca prima optiune intr-o lista derulanta folosind Data Validation in Excel.<\/h1>\n<p>&nbsp;<\/p>\n<p>Pentru a face acest lucru este necesar sa parcurgem cativa pasi.<\/p>\n<p>Primul pas ar fi sa realizam o lista care sa cuprinda si partea de celula goala in Excel, detalii in imaginea de mai jos:<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-2543 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/1.png\" alt=\"\" width=\"413\" height=\"387\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/1.png 413w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/1-300x281.png 300w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/p>\n<h2>Data Validation in Excel &#8211; Validarea datelor in Excel.<\/h2>\n<p>Dupa ce am definit lista de valori\/elemente in Excel, pasul numarul 2 ar fi sa le incarcam sub forma unei liste derulante, iar pentru acest lucru o sa accesam optiunea <strong>Data Validation<\/strong> din meniul Data: <strong>Data<\/strong>\u00a0&#8211;\u00a0<strong>Data Validation<\/strong>\u00a0&#8211;\u00a0<strong>Data Validation<\/strong> .<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-2544 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/2.png\" alt=\"\" width=\"1311\" height=\"294\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/2.png 1311w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/2-300x67.png 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/2-768x172.png 768w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/2-1024x230.png 1024w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/2-700x157.png 700w\" sizes=\"(max-width: 1311px) 100vw, 1311px\" \/><\/p>\n<h2>Cum contruiesc liste derulante in Excel avand ca prima optiune null\/blank\/celula goala.<\/h2>\n<p>In <strong>Data Validation <\/strong>va trebui sa selectam din zona la de<strong> Allow<\/strong> optiune <strong>List, <\/strong>In partea dreapta exista 2 butoane si va trebui sa ne asiguram ca nu avem bifa pusa pe optiunea <strong>Ignore blank. <\/strong>Prin urmare vom lasa libera casuta aferenta optiunii <strong>Ignore Blank<\/strong> si vom avea bifa in casuta aferenta lui <strong>In-cell dropdown, <\/strong>detalii si in imaginea de mai jos:<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-2545 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/3.png\" alt=\"\" width=\"863\" height=\"410\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/3.png 863w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/3-300x143.png 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/3-768x365.png 768w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/3-700x333.png 700w\" sizes=\"(max-width: 863px) 100vw, 863px\" \/><\/p>\n<p>Mergem in zona in care dorim sa avem lista derulata, intr-o celula sau pe o intreaga coloana. Ne vom intoarce in fereastra anterioara, urmatorul pas este sa incarcam elementele in zona de <strong>Source, <\/strong>iar acest lucru se face foarte simplu: click in casuta lui Source, dupa care selectam zona de elemente dorite a fi listate aici, inclusiv spatiul gol in cazul nostru, vezi imaginea de mai jos:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2546 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/4.png\" alt=\"\" width=\"809\" height=\"403\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/4.png 809w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/4-300x149.png 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/4-768x383.png 768w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/4-700x349.png 700w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/p>\n<p>O sa dam click pe <strong>OK<\/strong>. In acest moment prima optiune pe care o vedem in lista noastra este valoarea nula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2547 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/5.png\" alt=\"\" width=\"430\" height=\"252\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/5.png 430w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/07\/5-300x176.png 300w\" sizes=\"(max-width: 430px) 100vw, 430px\" \/><\/p>\n<p>In felul acesta putem lasa libere acele celule care nu corespund cu valorile noastre definite pentru a fi listate.<\/p>\n<p>Speram ca va este util acest tutorial, ne puteti urmari si in zona de social media\/ Facebook <a href=\"https:\/\/www.facebook.com\/SkyITLearning\/\">https:\/\/www.facebook.com\/SkyITLearning\/<\/a><\/p>\n<p>De asemenea putem sa va ajutam si cu programe de training personalizate, adaptate nevoilor Dvs. Cursurile sunt destinate atat persoanelor fizice cat si pentru companii, nu ezitati sa ne contactati pentru mai multe detalii.<\/p>\n<p><span class=\"lista1-service\">Nu uita&#8230;<\/span><\/p>\n<p><span class=\"lista1-service\"><em>Invata astazi pentru maine! Cursuri si conultanta solutii business Microsoft la cele mai bune preturi din piata, detalii <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">aici.<\/a><\/em><\/span>[\/vc_column_text]<\/div><\/div>[\/vc_column][\/vc_row][vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !<\/p>\n<p>important;background-color: #ffffff !important;}&#8221;][vc_column]<div class='qode_carousels_holder clearfix'><div class='qode_carousels' data-number-of-visible-items='4'><ul class='slides'><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel1-1.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel3.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel2-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel5.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel4.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel7.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel6.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel9.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel8.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel11.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel10.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel13.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel12.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel15.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel14.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><\/ul><\/div><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text] Cursuri Office Cursuri Excel De-a lungul celor 5 ani de activitate ne-am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant. [\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;996&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/2549"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/comments?post=2549"}],"version-history":[{"count":8,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/2549\/revisions"}],"predecessor-version":[{"id":2916,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/2549\/revisions\/2916"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=2549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=2549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=2549"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=2549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}