{"id":1740,"date":"2023-11-08T10:24:09","date_gmt":"2023-11-08T10:24:09","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/"},"modified":"2023-12-10T06:00:15","modified_gmt":"2023-12-10T06:00:15","slug":"bagimli-acilir-liste","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/","title":{"rendered":"Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-4093371726\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r men\u00fc, ba\u015fka bir a\u00e7\u0131l\u0131r men\u00fcdeki de\u011ferin se\u00e7imine ba\u011fl\u0131 olarak de\u011ferlerin bir a\u00e7\u0131l\u0131r men\u00fcde g\u00f6r\u00fcnt\u00fclenmesini i\u00e7erir.<\/p><p> Bug\u00fcn bu makalede, bu a\u00e7\u0131l\u0131r listeyi olu\u015fturmak i\u00e7in 7 ad\u0131ml\u0131k basit bir s\u00fcreci sizinle payla\u015fmak istiyorum. Ama \u00f6nce bunun neden \u00f6nemli oldu\u011funu anlatay\u0131m. A\u015fa\u011f\u0131daki \u00f6rnekte iki a\u00e7\u0131l\u0131r listeniz var. Boyut a\u00e7\u0131l\u0131r men\u00fcs\u00fc, \u00fcr\u00fcn a\u00e7\u0131l\u0131r men\u00fcs\u00fcne ba\u011fl\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif\" sizes=\"\" srcset=\"\" alt=\"iki seviyeli ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste\"><\/figure><\/div><p> \u00dcr\u00fcn h\u00fccresinde beyaz ka\u011f\u0131d\u0131 se\u00e7erseniz boyut a\u00e7\u0131l\u0131r listesinde k\u00fc\u00e7\u00fck ve orta boy g\u00f6sterilir. Ancak gri ka\u011f\u0131d\u0131 se\u00e7erseniz boyutu orta ve b\u00fcy\u00fck olacakt\u0131r.<\/p><p> Yani burada ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r men\u00fc olu\u015fturman\u0131n temel fikri, \u00fcr\u00fcn ad\u0131na g\u00f6re do\u011fru boyutu elde etmektir. Ba\u015flayal\u0131m.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de Ba\u011f\u0131ml\u0131 A\u00e7\u0131l\u0131r Liste Olu\u015fturma Ad\u0131mlar\u0131<\/h2><p> Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r men\u00fc olu\u015fturmak i\u00e7in <a style=\"outline: none;\" href=\"http:\/\/www.exceltrick.com\/how_to\/named-range-in-excel\/\" target=\"_blank\" rel=\"noopener\">adland\u0131r\u0131lm\u0131\u015f aral\u0131klar\u0131<\/a> ve dolayl\u0131 i\u015flevleri kullanmam\u0131z gerekir.<\/p><ul><li> \u00d6ncelikle a\u00e7\u0131l\u0131r listeler i\u00e7in adland\u0131r\u0131lm\u0131\u015f aral\u0131klar olu\u015fturman\u0131z gerekir. Bunu yapmak i\u00e7in \u00fcr\u00fcn listesini se\u00e7in. -&gt; Form\u00fcller -&gt; Tan\u0131ml\u0131 Adlar -&gt; Se\u00e7imden Olu\u015ftur se\u00e7ene\u011fine gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-creer-une-plage-nommee-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur, adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturun\"><\/figure><\/div><ul><li> Bir a\u00e7\u0131l\u0131r pencere g\u00f6receksiniz. &#8220;\u00dcst sat\u0131r&#8221; onay i\u015fareti<\/li><li><\/li><li> ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-creer-une-plage-nommee-cliquez-sur-OK-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturun Tamam'a t\u0131klay\u0131n\"><\/figure><\/div><ul><li> Ayn\u0131 ad\u0131mlar\u0131 kullanarak boyutlar i\u00e7in iki adland\u0131r\u0131lm\u0131\u015f aral\u0131k daha olu\u015fturun. Biri beyaz ka\u011f\u0131t, ikincisi ise gri ka\u011f\u0131t i\u00e7indir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-trois-plages-nommees-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de \u00fc\u00e7 adland\u0131r\u0131lm\u0131\u015f aral\u0131kta ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur\"><\/figure><\/div><p> \u0130pucu: Adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturmak i\u00e7in bu y\u00f6ntemi kullan\u0131rsan\u0131z, ilk h\u00fccredeki de\u011fer ad, geri kalan de\u011ferler ise aral\u0131k olarak kabul edilecektir. Bunun i\u00e7in dinamik bir adland\u0131r\u0131lm\u0131\u015f aral\u0131k da kullanabilirsiniz.<\/p><ul><li> \u015eimdi \u00fcr\u00fcn a\u00e7\u0131l\u0131r men\u00fcs\u00fcn\u00fc eklemek istedi\u011finiz h\u00fccreyi se\u00e7in ve -&gt; Veri -&gt; Veri Ara\u00e7lar\u0131 -&gt; Veri Do\u011frulama b\u00f6l\u00fcm\u00fcne gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-creer-une-liste-deroulante-pour-les-produits-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur \u00fcr\u00fcnler i\u00e7in bir a\u00e7\u0131l\u0131r liste olu\u015fturun\"><\/figure><\/div><ul><li> Veri Do\u011frulama penceresinde &#8220;Liste&#8221;yi se\u00e7in ve &#8220;Kaynak&#8221;ta a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin ve ard\u0131ndan Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-la-fenetre-deroulante-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel a\u00e7\u0131l\u0131r penceresinde ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur\"><\/figure><\/div><p> =Dolayl\u0131(\u201c\u00dcr\u00fcn\u201d)<\/p><ul><li> Boyut a\u00e7\u0131l\u0131r listesini eklemek istedi\u011finiz h\u00fccreyi se\u00e7in. -&gt; Veri -&gt; Veri Ara\u00e7lar\u0131 -&gt; Veri Do\u011frulama se\u00e7ene\u011fine gidin.<\/li><li> Veri do\u011frulama penceresinde \u201cListe\u201dyi se\u00e7in ve \u201cKaynak\u201da a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-la-fenetre-deroulante-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel a\u00e7\u0131l\u0131r penceresinde ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur\"><\/figure><\/div><p> =Dolayl\u0131(\u201cA5\u201d)<\/p><p> Sonunda ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r listeniz haz\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif\" sizes=\"\" srcset=\"\" alt=\"iki seviyeli ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> \u00d6ncelikle \u00fc\u00e7 adland\u0131r\u0131lm\u0131\u015f aral\u0131k olu\u015fturdunuz. Daha sonra, \u00fcr\u00fcnlerin a\u00e7\u0131l\u0131r listesini olu\u015fturmak i\u00e7in adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k kulland\u0131k. Bundan sonra ikinci a\u00e7\u0131l\u0131r men\u00fcde dolayl\u0131 i\u015flevi kulland\u0131n\u0131z ve \u00fcr\u00fcn h\u00fccresindeki de\u011fere ba\u015fvurdunuz.<\/p><p> Dikkat ederseniz beden aral\u0131klar\u0131m\u0131z \u00fcr\u00fcn a\u00e7\u0131l\u0131r men\u00fcs\u00fcnde sahip oldu\u011fumuz de\u011ferlere e\u015fit bir isme sahip.<\/p><p> \u00dcr\u00fcn h\u00fccresinde ve ard\u0131ndan beden h\u00fccresinde &#8220;WhitePaperSheet&#8221;i se\u00e7ti\u011fimizde dolayl\u0131 fonksiyon &#8220;WhitePaperSheet&#8221; isimli aral\u0131\u011f\u0131, &#8220;GreyPaperSheet&#8221;i se\u00e7ti\u011finizde ise &#8220;GreyPaperSheet&#8221; isimli aral\u0131\u011f\u0131 ifade edecektir.<\/p><h2 class=\"wp-block-heading\"> \u00dc\u00e7 seviyeli ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste<\/h2><p> Yukar\u0131daki \u00f6rnekte iki d\u00fczeyli ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste olu\u015fturdunuz. Ancak bazen \u00fc\u00e7 d\u00fczey ba\u011f\u0131ml\u0131l\u0131\u011f\u0131 olan bir liste olu\u015fturmam\u0131z gerekir. Bunu yapmak i\u00e7in, ikinci a\u00e7\u0131l\u0131r listenin se\u00e7imine ba\u011fl\u0131 olan \u00fc\u00e7\u00fcnc\u00fc bir a\u00e7\u0131l\u0131r liste olu\u015fturman\u0131z yeterlidir.<\/p><p> Ka\u011f\u0131tlar i\u00e7in &#8220;Uzunluk x Geni\u015flik&#8221; boyutlar\u0131nda bir a\u00e7\u0131l\u0131r liste eklemek istedi\u011fimizi varsayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-avec-des-donnees-a-trois-niveaux-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de \u00fc\u00e7 seviyeli verilerle ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur\"><\/figure><\/div><p> Bunun i\u00e7in de beden se\u00e7imine g\u00f6re \u201cUzunluk X Geni\u015flik\u201di g\u00f6sterecek \u00fc\u00e7\u00fcnc\u00fc bir a\u00e7\u0131l\u0131r liste olu\u015fturman\u0131z gerekiyor.<\/p><p> \u0130\u015fte ad\u0131mlar:<\/p><ul><li> Yukar\u0131da kulland\u0131\u011f\u0131m\u0131z y\u00f6ntemi kullanarak \u00fc\u00e7 adland\u0131r\u0131lm\u0131\u015f aral\u0131k daha olu\u015fturun. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-avec-de-nouvelles-plages-nommees-de-donnees-a-trois-niveaux-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00fc\u00e7 seviyeli verilerin yeni adland\u0131r\u0131lm\u0131\u015f aral\u0131klar\u0131yla excel'de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur\"><\/figure><\/div><ul><li> \u00dc\u00e7\u00fcnc\u00fc a\u00e7\u0131l\u0131r listenizi eklemek istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li><li> A\u00e7\u0131l\u0131r se\u00e7enekleri a\u00e7\u0131n ve a\u015fa\u011f\u0131daki form\u00fcl\u00fc kayna\u011fa ekleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-creer-une-liste-deroulante-dependante-dans-Excel-avec-une-liste-deroulante-a-trois-niveaux-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de \u00fc\u00e7 d\u00fczeyli bir a\u00e7\u0131l\u0131r listeyle ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur\"><\/figure><\/div><p> =Dolayl\u0131(\u201cC5\u201d)<\/p><ul><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k \u00fc\u00e7 seviyeli a\u00e7\u0131l\u0131r listeniz haz\u0131r <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-trois-niveaux-dans-Excel-pret.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de haz\u0131r \u00fc\u00e7 d\u00fczeyli ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/liste-deroulante-dependante-a-trois-niveaux.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><em>\u00d6rnek bir dosya indirin<\/em><\/a><\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excel-ilerlemesi\/\">\u0130leri Excel Dersleri<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/veri-dogrulama-tarih-araligi\/\">Tarih aral\u0131\u011f\u0131yla veri do\u011frulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\">Excel&#8217;de dinamik a\u00e7\u0131l\u0131r liste<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/evet-hayir-acilir-liste\/\">Excel&#8217;de Evet &#8211; Hay\u0131r A\u00e7\u0131l\u0131r Listesi Olu\u015fturma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acilir-listeyi-kaldir\/\">Excel&#8217;de a\u00e7\u0131l\u0131r listeyi (veri do\u011frulama) kald\u0131r<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1740","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Excel&#039;de ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste \u00e7ok faydal\u0131d\u0131r. Bu makalede, Excel&#039;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r listenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste \u00e7ok faydal\u0131d\u0131r. Bu makalede, Excel&#039;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r listenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\",\"name\":\"\u25b7 Excel&#39;de ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif\",\"datePublished\":\"2023-11-08T10:24:09+00:00\",\"dateModified\":\"2023-12-10T06:00:15+00:00\",\"description\":\"Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste \u00e7ok faydal\u0131d\u0131r. Bu makalede, Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r listenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Excel&#39;de ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?","description":"Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste \u00e7ok faydal\u0131d\u0131r. Bu makalede, Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r listenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?","og_description":"Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste \u00e7ok faydal\u0131d\u0131r. Bu makalede, Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r listenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/","url":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/","name":"\u25b7 Excel&#39;de ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif","datePublished":"2023-11-08T10:24:09+00:00","dateModified":"2023-12-10T06:00:15+00:00","description":"Ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste \u00e7ok faydal\u0131d\u0131r. Bu makalede, Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r listenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-deroulante-dependante-a-deux-niveaux-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1740"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1740\/revisions"}],"predecessor-version":[{"id":2391,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1740\/revisions\/2391"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}