{"id":1878,"date":"2023-10-30T10:14:44","date_gmt":"2023-10-30T10:14:44","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/"},"modified":"2023-12-10T06:01:50","modified_gmt":"2023-12-10T06:01:50","slug":"onay-kutusu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/","title":{"rendered":"Excel&#39;de onay kutusu nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2435450041\"><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>Bir Excel kullan\u0131c\u0131s\u0131 i\u00e7in en zorlu ve b\u00fcy\u00fcleyici \u015feylerden biri, Excel&#8217;de etkile\u015fimli \u015feyler olu\u015fturmakt\u0131r. Ve onay kutusu, i\u015faretini kald\u0131rarak\/i\u015faretleyerek bir\u00e7ok \u015feyi kontrol etmek i\u00e7in kullanabilece\u011finiz k\u00fc\u00e7\u00fck ama g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r.<\/p><p> K\u0131sacas\u0131: \u0130\u00e7eri\u011finizi etkile\u015fimli hale getirme g\u00fcc\u00fc verir. Ve eminim i\u015flerinizde de s\u0131kl\u0131kla kullan\u0131yorsunuzdur. Ancak mesele \u015fu: Bir onay kutusunu en iyi \u015fekilde nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 biliyor musunuz? Evet, soru bu.<\/p><p> Bug\u00fcnk\u00fc yaz\u0131da, size Excel&#8217;de bir onay kutusunu nas\u0131l ekleyebilece\u011finizi ve \u00f6zelliklerini ve se\u00e7eneklerini bilmenize yard\u0131mc\u0131 olacak di\u011fer t\u00fcm \u015feyleri tam olarak g\u00f6sterece\u011fim. O halde daha fazla uzatmadan bu konuyu inceleyelim.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Excel&#8217;de onay kutusu ekleme ad\u0131mlar\u0131<\/h2><p> Burada onay kutusu eklemek i\u00e7in iki farkl\u0131 y\u00f6nteminiz var. E\u011fer sizin i\u00e7in uygun oldu\u011funu d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z bu y\u00f6ntemlerden herhangi birini kullanabilirsiniz.<\/p><h3 id=\"tab-con-2\" class=\"wp-block-heading\"> Manuel y\u00f6ntem<\/h3><ul><li> \u00d6ncelikle geli\u015ftirici sekmesine gidin ve \u015feridinizde geli\u015ftirici sekmesini g\u00f6remiyorsan\u0131z <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">bu basit ad\u0131mlar\u0131 kullanarak<\/a> etkinle\u015ftirebilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de Onay Kutusu Eklemek i\u00e7in Geli\u015ftirici Sekmesine gidin\"><\/figure><\/div><ul><li> Geli\u015ftirici sekmesinde Kontroller \u2192 Form Kontrolleri \u2192 Onay Kutusunu Se\u00e7&#8217;e gidin.<\/li><li> Onay kutusunu se\u00e7tikten sonra e-tablonuzda eklemek istedi\u011finiz yeri 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\/Cliquez-sur-Inserer-une-case-a-cocher-dans-Excel.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de Onay Kutusu Ekle'yi t\u0131klay\u0131n\"><\/figure><\/div><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> VBA kodu<\/h3><p> Bu, onay kutusu eklemenin ba\u015fka bir y\u00f6ntemidir; a\u015fa\u011f\u0131daki VBA kodunu kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ActiveSheet.CheckBoxes.Add(left, Right, Height, Width).Select ActiveSheet.CheckBoxes.Add(80, 40, 72, 72).Select<\/code><\/pre><p> Yukar\u0131daki y\u00f6ntemi kullanmak yaln\u0131zca tam olarak nereye eklenece\u011fini ve onay kutusunun boyutunu bildi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/office\/microsoft.office.interop.excel.checkboxes.add.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Bu y\u00f6ntem hakk\u0131nda daha fazla bilgiyi burada<\/a> bulabilirsiniz.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> Onay kutusunu bir h\u00fccreye ba\u011flama<\/h2><p> \u00c7al\u0131\u015fma sayfan\u0131za bir onay kutusu ekledikten sonra onu bir h\u00fccreye ba\u011flaman\u0131z gerekir. Bu basit ad\u0131mlar\u0131 izleyin.<\/p><ul><li> Onay kutusuna sa\u011f t\u0131klay\u0131n ve Denetimi Bi\u00e7imlendir&#8217;i se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-cliquez-dessus-avec-le-bouton-droit-de-la-souris-selectionnez-le-controle-de-format.png\" sizes=\"\" srcset=\"\" alt=\"Onay kutusunu Excel'e ekleyin, sa\u011f t\u0131klay\u0131n, format kontrol\u00fcn\u00fc se\u00e7in\"><\/figure><\/div><ul><li> Art\u0131k bir format kontrol\u00fc ileti\u015fim kutusu g\u00f6receksiniz.<\/li><li> Kontrol sekmesine gidin ve h\u00fccre ba\u011flant\u0131s\u0131 giri\u015f \u00e7ubu\u011funa, ba\u011flamak istedi\u011finiz h\u00fccrenin h\u00fccre adresini onay kutusuyla girin.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> Onay kutunuza ba\u011flad\u0131\u011f\u0131n\u0131z h\u00fccrede, kutuyu i\u015faretledi\u011finizde DO\u011eRU, i\u015fareti kald\u0131rd\u0131\u011f\u0131n\u0131zda YANLI\u015e al\u0131rs\u0131n\u0131z. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Lier-la-cellule-une-fois-que-vous-avez-insere-la-case-a-cocher-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de onay kutusunu ekledikten sonra h\u00fccreyi ba\u011flay\u0131n\"><\/figure><\/div><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> Onay kutusunu kald\u0131rma<\/h2><p> Bir onay kutusunu iki \u015fekilde kald\u0131rabilirsiniz. \u0130lki bir onay kutusunu se\u00e7ip Sil&#8217;e basmakt\u0131r. Bu, bunu yapman\u0131n h\u0131zl\u0131 ve kolay bir y\u00f6ntemidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Supprimer-lorsque-vous-inserez-une-case-a-cocher-dans-Excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de bir onay kutusu ekledi\u011finizde silin\"><\/figure><\/div><p> E-tablonuzda birden fazla onay kutusu varsa ne olur? Kontrol tu\u015funu bas\u0131l\u0131 tutarak ve Sil tu\u015funa basarak t\u00fcm kutular\u0131 i\u015faretleyin. \u0130kinci yol ise bunlar\u0131 kald\u0131rmak i\u00e7in se\u00e7im b\u00f6lmesini kullanmakt\u0131r.<\/p><ol><li> Ana Sayfa sekmesi \u2192 D\u00fczenle \u2192 Bul ve Se\u00e7 \u2192 Se\u00e7im B\u00f6lmesi&#8217;ne gidin.<\/li><li> Se\u00e7im b\u00f6lmesinde, \u00e7al\u0131\u015fma sayfan\u0131zda kulland\u0131\u011f\u0131n\u0131z t\u00fcm onay kutular\u0131n\u0131n listesini g\u00f6receksiniz.<\/li><li> Her birini tek tek se\u00e7ebilece\u011finiz gibi, kontrol tu\u015funu kullanarak birden fazla se\u00e7ebilirsiniz.<\/li><li> Bunlar\u0131 se\u00e7tikten sonra sil&#8217;e dokunun. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-Utiliser-le-volet-de-selection-dans-Excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'e Onay Kutusu Ekleme Excel'de Se\u00e7im B\u00f6lmesini Kullanma\"><\/figure><\/div><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> Onay kutusunu yazd\u0131rma<\/h2><p> Kullan\u0131c\u0131lar \u00e7o\u011fu zaman onay kutusu yazd\u0131rmaktan ka\u00e7\u0131n\u0131r. Ancak bunu yapmak istiyorsan\u0131z a\u015fa\u011f\u0131daki y\u00f6ntemi kullanarak bu se\u00e7ene\u011fi etkinle\u015ftirebilirsiniz.<\/p><ol><li> Onay kutusuna sa\u011f t\u0131klay\u0131n ve Denetimi Bi\u00e7imlendir&#8217;i se\u00e7in.<\/li><li> \u00d6zellikler sekmesine gidin.<\/li><li> \u201cNesneyi yazd\u0131r\u201d kutusunu i\u015faretleyin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utilisez-loption-de-format-pour-activer-limpression-apres-avoir-insere-la-case-a-cocher-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de onay kutusunu ekledikten sonra yazd\u0131rmay\u0131 etkinle\u015ftirmek i\u00e7in format se\u00e7ene\u011fini kullan\u0131n\"><\/figure><\/div><p> Bu, onay kutular\u0131n\u0131 yazd\u0131rman\u0131za olanak tan\u0131r ve bunlar\u0131 yazd\u0131rmak istemiyorsan\u0131z bu se\u00e7ene\u011fin i\u015faretini kald\u0131rd\u0131\u011f\u0131n\u0131zdan emin olun.<\/p><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> Onay kutusunu yeniden boyutland\u0131r<\/h2><p> Onay kutusunu yeniden boyutland\u0131rmak istiyorsan\u0131z, kenar\u0131ndaki noktalar\u0131 kullanarak boyutunu art\u0131rabilirsiniz. Ayr\u0131ca, belirli bir y\u00fckseklik ve geni\u015flik kullanarak yeniden boyutland\u0131rmak istiyorsan\u0131z a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyerek bunu yapabilirsiniz.<\/p><ul><li> Onay kutusuna sa\u011f t\u0131klay\u0131n ve format kontrol se\u00e7ene\u011fini se\u00e7in.<\/li><li> Boyut -&gt; Sekme Boyutu&#8217;na gidin ve d\u00f6nd\u00fcr\u00fcn.<\/li><li> Onay kutusu i\u00e7in ayarlamak istedi\u011finiz y\u00fcksekli\u011fi ve geni\u015fli\u011fi girin.<\/li><li> Tamam&#8217;\u0131 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\/Inserer-une-case-a-cocher-dans-Excel-avec-une-largeur-de-hauteur-personnalisee-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00d6zel y\u00fckseklik geni\u015fli\u011fine sahip Excel'e onay kutusu ekle\"><\/figure><\/div><p class=\"qt-tip\"> H\u0131zl\u0131 \u0130pucu: Onay kutusu boyutuna ili\u015fkin en boy oran\u0131n\u0131 kilitlemek i\u00e7in \u201cEn Boy Oran\u0131n\u0131 Kilitle\u201d se\u00e7ene\u011fini i\u015faretleyin.<\/p><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> Bir onay kutusunu birden fazla h\u00fccreye kopyalama<\/h2><p> Bir onay kutusunu bir yerden ba\u015fka bir yere kopyalamak i\u00e7in \u00fc\u00e7 farkl\u0131 y\u00f6ntem kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> Kopyala yap\u0131\u015ft\u0131r<\/h3><ul><li> Bir kutuyu i\u015faretleyin.<\/li><li> \u00dczerine sa\u011f t\u0131klay\u0131n ve kopyalay\u0131n.<\/li><li> Bu onay kutusunu yap\u0131\u015ft\u0131rmak istedi\u011finiz h\u00fccreye gidin.<\/li><li> Sa\u011f t\u0131klay\u0131p yap\u0131\u015ft\u0131r\u0131n.<\/li><\/ul><h3 class=\"wp-block-heading\"> Kontrol tu\u015funu kullan\u0131n<\/h3><ul><li> Bir kutuyu i\u015faretleyin.<\/li><li> Kontrol tu\u015funa bas\u0131n.<\/li><li> \u015eimdi farenizle bu onay kutusunu yap\u0131\u015ft\u0131rmak istedi\u011finiz ba\u015fka bir yere s\u00fcr\u00fckleyin.<\/li><\/ul><h3 class=\"wp-block-heading\"> Doldurma Kolunu Kullanma<\/h3><ul><li> Onay kutunuzun bulundu\u011fu h\u00fccreyi se\u00e7in.<\/li><li> Doldurma tutamac\u0131n\u0131 kullan\u0131n ve onay kutusunu kopyalamak istedi\u011finiz h\u00fccreye s\u00fcr\u00fckleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-dans-plusieurs-cellules-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de birden \u00e7ok h\u00fccreye onay kutusu ekle\"><\/figure><\/div><h2 id=\"tab-con-9\" class=\"wp-block-heading\"> Onay kutusunu yeniden adland\u0131r\u0131n<\/h2><p> Bir onay kutusunu yeniden adland\u0131r\u0131rken, bir onay kutusuyla ili\u015fkilendirilmi\u015f iki farkl\u0131 ad\u0131n\u0131z oldu\u011funu akl\u0131n\u0131zda tutman\u0131z gerekir. Bir onay kutusunun ba\u015fl\u0131k ad\u0131 ve ger\u00e7ek ad\u0131.<\/p><ol><li> Soru: Onay kutusu g\u00f6stergesinin ad\u0131n\u0131 nas\u0131l de\u011fi\u015ftiririm?<\/li><li> Cevap: Sa\u011f t\u0131klay\u0131n ve Metni D\u00fczenle&#8217;yi se\u00e7in, ard\u0131ndan varsay\u0131lan metni silin ve yeni metni girin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-Changer-le-nom-de-la-legende-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'e Onay Kutusu Ekle G\u00f6sterge Ad\u0131n\u0131 De\u011fi\u015ftir\"><\/figure><\/div><ol><li> Soru: Bir onay kutusunu nas\u0131l yeniden adland\u0131rabilirim?<\/li><li> Cevap: Onay kutusunu sa\u011f t\u0131klay\u0131n. Adres \u00e7ubu\u011funa gidin ve ad\u0131 d\u00fczenleyin. \u0130stedi\u011finiz ad\u0131 de\u011fi\u015ftirin ve Enter tu\u015funa bas\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-Changer-le-nom-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel Ad\u0131n\u0131 De\u011fi\u015ftir'e Onay Kutusu Ekle\"><\/figure><\/div><h2 id=\"tab-con-10\" class=\"wp-block-heading\"> Onay kutusunun konumunu d\u00fczeltme<\/h2><p> Varsay\u0131lan olarak, Excel&#8217;de bir onay kutusu ekledi\u011finizde, yerle\u015ftirildi\u011fi h\u00fccreyi geni\u015fletti\u011finizde konumu ve \u015fekli de\u011fi\u015fir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-Changer-de-position.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de bir onay kutusu ekleme Konumu de\u011fi\u015ftir\"><\/figure><\/div><p> Ancak bu ad\u0131mlar\u0131 izleyerek konumunu kolayca d\u00fczeltebilirsiniz.<\/p><ol><li> Onay kutusuna sa\u011f t\u0131klay\u0131n ve Format Kontrol\u00fc \u2192 \u00d6zellikler sekmesine gidin.<\/li><li> Nesne Konumland\u0131rma&#8217;da &#8220;H\u00fccreyle ta\u015f\u0131ma veya yeniden boyutland\u0131rma&#8221; se\u00e7ene\u011fini se\u00e7in.<\/li><li> Bu se\u00e7ene\u011fi se\u00e7ti\u011finizde, s\u00fctun veya sat\u0131r geni\u015fletilirken onay kutusu konumundan hareket etmeyecektir. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-la-case-a-cocher-dans-Excel-sans-changer-de-position.gif\" sizes=\"\" srcset=\"\" alt=\"Konumu de\u011fi\u015ftirmeden onay kutusunu Excel'e ekle\"><\/figure><\/div><h2 id=\"tab-con-11\" class=\"wp-block-heading\"> Onay kutusunu gizleyin veya g\u00f6sterin<\/h2><p> Ayr\u0131ca bu ad\u0131mlar\u0131 izleyerek \u00e7al\u0131\u015fma sayfan\u0131zdaki bir onay kutusunu gizleyebilir veya g\u00f6sterebilirsiniz.<\/p><ol><li> Alt + F10 k\u0131sayol tu\u015funu kullanarak Se\u00e7im B\u00f6lmesini a\u00e7\u0131n.<\/li><li> Her onay kutusu ad\u0131n\u0131n sa\u011f taraf\u0131nda k\u00fc\u00e7\u00fck bir g\u00f6z simgesi bulunur.<\/li><li> Bir onay kutusunu gizlemek i\u00e7in bu simgeye, g\u00f6stermek i\u00e7in de ayn\u0131 simgeye t\u0131klay\u0131n.<\/li><li> T\u00fcm onay kutular\u0131n\u0131 gizlemek\/g\u00f6stermek istiyorsan\u0131z, t\u00fcm onay kutular\u0131n\u0131 g\u00f6stermek i\u00e7in T\u00fcm\u00fcn\u00fc Gizle ve T\u00fcm\u00fcn\u00fc G\u00f6ster D\u00fc\u011fmelerini kullanabilirsiniz. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-la-case-a-cocher-dans-Excel-sans-changer-de-position.gif\" sizes=\"\" srcset=\"\" alt=\"Konumu de\u011fi\u015ftirmeden onay kutusunu Excel'e ekle\"><\/figure><\/div><h2 id=\"tab-con-12\" class=\"wp-block-heading\"> Excel&#8217;de onay kutusu nas\u0131l kullan\u0131l\u0131r?<\/h2><p> Burada e-tablonuzda onay kutusu olarak kullanabilece\u011finiz faydal\u0131 fikirlerin bir listesi var.<\/p><h3 id=\"tab-con-13\" class=\"wp-block-heading\"> Kontrol Listesi Olu\u015fturma<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte bir kontrol listesi olu\u015fturmak i\u00e7in bir onay kutusu kulland\u0131m. Ve bu kontrol listesini olu\u015fturmak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/formuller-1\/\" data-wpil=\"url\">ko\u015fullu bi\u00e7imlendirmedeki form\u00fclleri<\/a> kulland\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-pour-creer-une-liste-de-controle-1.gif\" sizes=\"\" srcset=\"\" alt=\"kontrol listesi olu\u015fturmak i\u00e7in Excel'e bir onay kutusu ekleyin\"><\/figure><\/div><ol><li> Bir onay kutusu ekleyin ve onu bir h\u00fccreye ba\u011flay\u0131n.<\/li><li> \u015eimdi g\u00f6rev ad\u0131n\u0131n bulundu\u011fu h\u00fccreyi se\u00e7in ve Ana Sayfa sekmesine -&gt; Stiller -&gt; Ko\u015fullu Bi\u00e7imlendirme -&gt; Yeni Kural&#8217;a gidin.<\/li><li> \u201cHangi h\u00fccrenin bi\u00e7imlendirilece\u011fini belirlemek i\u00e7in form\u00fcl kullan\u201d se\u00e7ene\u011fini t\u0131klay\u0131n ve a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin.<ul><li> =E\u011eER(B1=DO\u011eRU,DO\u011eRU,YANLI\u015e)<\/li><\/ul><\/li><li> \u00dcst\u00fc \u00e7izili bi\u00e7imlendirmeyi uygulay\u0131n.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Art\u0131k kutuyu her i\u015faretledi\u011finizde, ba\u011flant\u0131l\u0131 h\u00fccrenin de\u011feri TRUE olur ve ko\u015fullu bi\u00e7imlendirmeyi uygulad\u0131\u011f\u0131n\u0131z h\u00fccre <a href=\"https:\/\/exceladvisor.org\/tr\/kamis\/\">, de\u011fer arac\u0131l\u0131\u011f\u0131yla bir sat\u0131r al\u0131r<\/a> .<\/p><h3 id=\"tab-con-14\" class=\"wp-block-heading\"> Onay kutusuyla dinamik bir grafik olu\u015fturun<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte \u00e7izgi grafi\u011fi ve s\u00fctun grafi\u011fini kullanarak dinamik bir grafik olu\u015fturdum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-pour-creer-un-graphique-dynamique-1.gif\" sizes=\"\" srcset=\"\" alt=\"Dinamik bir grafik olu\u015fturmak i\u00e7in Excel'e bir onay kutusu ekleyin\"><\/figure><\/div><ol><li> K\u00e2r de\u011ferlerini i\u00e7eren bir tablo olu\u015fturun ve a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanarak bunu ba\u015fka bir tabloya ba\u011flay\u0131n.<ul><li> =E\u011eER($I$17=DO\u011eRU, D\u00dc\u015eEYARA($I4,$M$3:$N$15,2,0),YOK())<\/li><\/ul><\/li><li> Daha sonra $I$17 \u00f6\u011fesini onay kutusuyla ba\u011flay\u0131n.<\/li><li> Bu kutuyu i\u015faretliyorum, yukar\u0131daki form\u00fcl kar y\u00fczdelerini elde etmek i\u00e7in D\u00dc\u015eEYARA i\u015flevini kullanaca\u011f\u0131nda. Ve e\u011fer bir kutu i\u015faretlenmezse #N\/A mesaj\u0131 alaca\u011f\u0131m.<\/li><\/ol><h3 id=\"tab-con-15\" class=\"wp-block-heading\"> Makroyu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in onay kutusunu kullan\u0131n<\/h3><p> Bir fatura \u015fablonu \u00fczerinde \u00e7al\u0131\u015f\u0131rken akl\u0131ma \u015fu fikir geldi. Buradaki fikir, teslimat adresini fatura adresiyle ayn\u0131 \u015fekilde girmek istiyorsan\u0131z kutuyu i\u015faretlemeniz yeterlidir; adres oraya kopyalanacakt\u0131r.<\/p><p> \u00d6te yandan bu kutunun i\u015faretini kald\u0131rd\u0131\u011f\u0131n\u0131zda i\u00e7erik silinecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Inserer-une-case-a-cocher-dans-Excel-pour-creer-un-modele-de-facture-1.gif\" sizes=\"\" srcset=\"\" alt=\"fatura \u015fablonu olu\u015fturmak i\u00e7in Excel'e bir onay kutusu ekleyin\"><\/figure><\/div><ol><li> Geli\u015ftirici sekmesi \u2192 Kod \u2192 Visual Basic&#8217;e gidin veya Visual Basic d\u00fczenleyicisini a\u00e7mak i\u00e7in k\u0131sayol tu\u015funu da kullanabilirsiniz.<\/li><li> A\u015fa\u011f\u0131daki VBA kodunu onay kutunuzu ekledi\u011finiz sayfaya ekleyin.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub Ship_To_XL() If Range(\u201cD15\u201d) = True Then Range(\"D17:D21\") = Range(\"C17:C21\") Else If Range(\u201cD15\u201d) = False Then Range(\"D17:D21\").ClearContents Else: MsgBox (\u201cError!\u201d) End If End Sub<\/code><\/pre><p> L\u00fctfen bu kodu, kullanmak istedi\u011finiz e-tablonun kod penceresine eklemeniz gerekti\u011fini unutmay\u0131n. Yukar\u0131daki kodda D17:D21 teslimat adresi aral\u0131\u011f\u0131d\u0131r ve C17:C21 fatura adresi aral\u0131\u011f\u0131d\u0131r. D15 h\u00fccresinde onay kutusunu ba\u011flad\u0131m.<\/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-kaybetmeden-hucreleri-birlestirme\/\">Excel&#8217;de veri kaybetmeden h\u00fccreleri birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-carpim-yapistir\/\">\u00d6zel Yap\u0131\u015ft\u0131r&#8217;\u0131 kullanarak Excel&#8217;de \u00e7arpma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/barkod-ekle\/\" data-wpil=\"url\">Excel&#8217;e barkod ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/varsayilan-yazi-tipi\/\">Excel&#8217;de varsay\u0131lan yaz\u0131 tipini de\u011fi\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/renge-gore-filtrele\/\">Excel&#8217;de renge g\u00f6re filtrele<\/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-1878","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>Excel&#039;de onay kutusu nas\u0131l eklenir? (3 \u00f6rnek)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, 8 \u00f6nemli nokta ve 3 \u00f6rnekle Excel&#039;de bir onay kutusunun nas\u0131l kullan\u0131laca\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\/onay-kutusu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de onay kutusu nas\u0131l eklenir? (3 \u00f6rnek)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, 8 \u00f6nemli nokta ve 3 \u00f6rnekle Excel&#039;de bir onay kutusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png\" \/>\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=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\",\"name\":\"Excel&#39;de onay kutusu nas\u0131l eklenir? (3 \u00f6rnek)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png\",\"datePublished\":\"2023-10-30T10:14:44+00:00\",\"dateModified\":\"2023-12-10T06:01:50+00:00\",\"description\":\"Bu e\u011fitimde, 8 \u00f6nemli nokta ve 3 \u00f6rnekle Excel&#39;de bir onay kutusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de onay kutusu nas\u0131l eklenir?\"}]},{\"@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":"Excel&#39;de onay kutusu nas\u0131l eklenir? (3 \u00f6rnek)","description":"Bu e\u011fitimde, 8 \u00f6nemli nokta ve 3 \u00f6rnekle Excel&#39;de bir onay kutusunun nas\u0131l kullan\u0131laca\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\/onay-kutusu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de onay kutusu nas\u0131l eklenir? (3 \u00f6rnek)","og_description":"Bu e\u011fitimde, 8 \u00f6nemli nokta ve 3 \u00f6rnekle Excel&#39;de bir onay kutusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/","url":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/","name":"Excel&#39;de onay kutusu nas\u0131l eklenir? (3 \u00f6rnek)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png","datePublished":"2023-10-30T10:14:44+00:00","dateModified":"2023-12-10T06:01:50+00:00","description":"Bu e\u011fitimde, 8 \u00f6nemli nokta ve 3 \u00f6rnekle Excel&#39;de bir onay kutusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/onay-kutusu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Accedez-a-longlet-Developpeur-pour-inserer-une-case-a-cocher-dans-Excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de onay kutusu nas\u0131l eklenir?"}]},{"@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\/1878","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=1878"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1878\/revisions"}],"predecessor-version":[{"id":2561,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1878\/revisions\/2561"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}