{"id":1491,"date":"2023-11-21T11:44:20","date_gmt":"2023-11-21T11:44:20","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/"},"modified":"2023-12-10T06:01:49","modified_gmt":"2023-12-10T06:01:49","slug":"onay-isareti-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/","title":{"rendered":"Excel&#39;de onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-504042912\"><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>Ge\u00e7en hafta seyahat ederken bana ak\u0131ll\u0131ca bir soru soran biriyle tan\u0131\u015ft\u0131m. Sessizce diz\u00fcst\u00fc bilgisayar\u0131nda \u00e7al\u0131\u015f\u0131yordu ve aniden bana \u015funu sordu:<\/p><p> <strong>\u201cHey, Excel&#8217;e onay i\u015fareti sembol\u00fcn\u00fcn nas\u0131l eklenece\u011fini biliyor musun?<\/strong> \u201c<\/p><p> Daha sonra elinde bir m\u00fc\u015fteri listesi oldu\u011funu ve tan\u0131\u015ft\u0131\u011f\u0131 her m\u00fc\u015fteri i\u00e7in bir onay i\u015fareti eklemek istedi\u011fini fark ettim.<\/p><p> Ona basit bir yol g\u00f6sterdim ve o da bundan memnun oldu. Ama nihayet bug\u00fcn sabah, bir h\u00fccreye onay i\u015fareti koyman\u0131n birden fazla yolu olabilece\u011fi akl\u0131ma geldi.<\/p><p> Ve \u015fans eseri, bunun i\u00e7in birka\u00e7 tane oldu\u011funu buldum. O y\u00fczden bug\u00fcn bu yaz\u0131mda Excel&#8217;de 10 farkl\u0131 y\u00f6ntem kullanarak onay i\u015fareti sembol\u00fcn\u00fcn nas\u0131l eklenece\u011fini ve bu y\u00f6ntemleri kullanmam\u0131z gereken t\u00fcm durumlar\u0131 g\u00f6stermek istiyorum.<\/p><p> <span style=\"font-size: 1em;\">Bu 10 y\u00f6ntem Ayr\u0131ca aral\u0131ktaki bir h\u00fccreden onay i\u015fareti + say\u0131m onay i\u015faretlerini nas\u0131l bi\u00e7imlendirebilece\u011finizi de belirttim.<\/span><\/p><h2 class=\"wp-block-heading\"> <span style=\"color: #ea493f;\">H\u0131zl\u0131 Notlar<\/span><\/h2><ul><li> Excel&#8217;de onay i\u015fareti Wingding yaz\u0131 tipi karakteridir. Yani onu bir h\u00fccreye ekledi\u011finizde, o h\u00fccrenin kanatl\u0131 bir yaz\u0131 tipi stiline sahip olmas\u0131 gerekir (ba\u015fka bir yerden kopyalamad\u0131\u011f\u0131n\u0131z s\u00fcrece).<\/li><li> Bu y\u00f6ntemler Excel&#8217;in t\u00fcm s\u00fcr\u00fcmlerinde (2007, 2010, 2013, 2016, 2019 ve Office 365) kullan\u0131labilir.<\/li><\/ul><h2 class=\"wp-block-heading\"> Excel&#8217;de onay i\u015faretini ne zaman kullanman\u0131z gerekir?<\/h2><p> Bir onay i\u015fareti veya onay i\u015fareti, &#8220;EVET&#8221;i belirtmek, &#8220;Bitti&#8221; veya &#8220;Bitti&#8221;yi belirtmek i\u00e7in kullan\u0131labilecek bir i\u015farettir.<\/p><p> Dolay\u0131s\u0131yla yap\u0131lacaklar listesi kullan\u0131yorsan\u0131z, bir \u015feyin yap\u0131ld\u0131\u011f\u0131n\u0131, tamamland\u0131\u011f\u0131n\u0131 veya i\u015faretlendi\u011fini i\u015faretlemek istiyorsan\u0131z, en iyi yol bir onay i\u015fareti kullanmakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> 1. Onay i\u015fareti eklemek i\u00e7in klavye k\u0131sayolu<\/h2><p> Hi\u00e7bir \u015fey klavye k\u0131sayolundan daha h\u0131zl\u0131 olamaz ve bir onay i\u015fareti simgesi eklemek i\u00e7in ihtiyac\u0131n\u0131z olan tek \u015fey bir klavye k\u0131sayoludur.<\/p><p> Dikkat etmeniz gereken tek \u015fey; Sembol\u00fc eklemek istedi\u011finiz h\u00fccrenin yaz\u0131 tipi stili kanat \u015feklinde olmal\u0131d\u0131r. A\u015fa\u011f\u0131da bir h\u00fccreye onay i\u015fareti eklemek i\u00e7in kullanabilece\u011finiz basit k\u0131sayol bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\" sizes=\"\" srcset=\"\" alt=\"k\u0131sayol tu\u015fuyla excel'e onay i\u015fareti ekleyin\"><\/figure><\/div><ol><li> Windows kullan\u0131yorsan\u0131z: Eklemek istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li><li> <strong>Alt + 0 2 5 2 tu\u015flar\u0131n\u0131 kullan\u0131n<\/strong> (Alt tu\u015funu bas\u0131l\u0131 tuttu\u011funuzdan emin olun, ard\u0131ndan say\u0131sal tu\u015f tak\u0131m\u0131n\u0131zla &#8220;0252&#8221; yaz\u0131n). <br><img decoding=\"async\" title=\"excel'de-onay i\u015fareti-eklemek i\u00e7in windows-klavye-k\u0131sayolu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/raccourci-clavier-windows-pour-inserer-une-coche-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"windows-keyboard-shortcut-to-insert-a-checkmark-in-excel\"><\/li><li> Ve Mac kullan\u0131yorsan\u0131z: eklemek istedi\u011finiz h\u00fccreyi se\u00e7meniz yeterlidir.<\/li><li> <strong>Se\u00e7enek tu\u015funu + 0 2 5 2<\/strong> kullan\u0131n (tu\u015fu bas\u0131l\u0131 tuttu\u011funuzdan emin olun ve ard\u0131ndan say\u0131sal tu\u015f tak\u0131m\u0131n\u0131zla \u201c0252\u201d yaz\u0131n). <br><img decoding=\"async\" title=\"excel'de-onay i\u015fareti-eklemek i\u00e7in mac-klavye-k\u0131sayolu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/raccourci-clavier-mac-pour-inserer-une-coche-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"mac-keyboard-shortcut-to-insert-a-checkmark-in-excel\"><\/li><\/ol><h2 class=\"wp-block-heading\"> 2. Onay i\u015fareti sembol\u00fcn\u00fc kopyalay\u0131p bir h\u00fccreye yap\u0131\u015ft\u0131r\u0131n<\/h2><p> Genellikle onay i\u015fareti kullanm\u0131yorsan\u0131z, onu bir yerden kopyalay\u0131p yap\u0131\u015ft\u0131rabilir ve bir h\u00fccreye ekleyebilirsiniz.<\/p><p> \u00c7\u00fcnk\u00fc burada herhangi bir form\u00fcl, k\u0131sayol veya VBA kullanm\u0131yorsunuz (buradan bir onay i\u015faretini kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n \u2713).<\/p><p> Veya <a href=\"https:\/\/www.google.com\/search?q=check+mark&amp;sca_esv=584275836&amp;sxsrf=AM9HkKkV41ajk1YDfsvPBSGYZsbdreKIfw%3A1700569357142\" target=\"_blank\" rel=\"nofollow external noopener noreferrer\" data-wpel-link=\"external\">google&#8217;da arayarak<\/a> da kopyalayabilirsiniz. Kopyala ve yap\u0131\u015ft\u0131r y\u00f6nteminin en iyi yan\u0131, yaz\u0131 tipi stilini de\u011fi\u015ftirmeye gerek olmamas\u0131d\u0131r.<\/p><h2 class=\"wp-block-heading\"> 3. <span style=\"color: #ea493f;\">Do\u011frudan sembol se\u00e7eneklerinden<\/span> bir onay i\u015fareti ekleyin<\/h2><p> Excel&#8217;de Semboller se\u00e7ene\u011finden ekleyebilece\u011finiz bir\u00e7ok sembol vard\u0131r ve onay i\u015fareti bunlardan biridir.<\/p><p> Semboller&#8217;den bir h\u00fccreye sembol eklemek \u00e7ocuk oyunca\u011f\u0131d\u0131r, a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulaman\u0131z yeterlidir:<\/p><ol><li> \u00d6ncelikle eklemek istedi\u011finiz <strong>h\u00fccreyi se\u00e7meniz<\/strong> gerekir.<\/li><li> Bundan sonra <strong>Ekle sekmesi \u279c Semboller \u279c Sembol&#8217;e gidin<\/strong> . <br><img decoding=\"async\" title=\"excel-min-sembol\u00fcnden-onay i\u015fareti ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-a-partir-du-symbole-min-1.png\" sizes=\"\" srcset=\"\" alt=\"insert checkmark in excel from symbol min\"><\/li><li> <strong>Sembol butonuna t\u0131klad\u0131\u011f\u0131n\u0131zda<\/strong> bir pencere a\u00e7\u0131lacakt\u0131r.<\/li><li> \u015eimdi bu pencereden yaz\u0131 tipi a\u00e7\u0131l\u0131r listesinden <strong>\u201cWinding\u201d se\u00e7ene\u011fini se\u00e7in<\/strong> .<\/li><li> Ve karakter kodu kutusuna \u201c252\u201d girin.<\/li><li> Bunu yapt\u0131\u011f\u0131n\u0131zda, onay i\u015fareti sembol\u00fcn\u00fc an\u0131nda se\u00e7ecektir ve sizin onu bulman\u0131z gerekmeyecektir. <br><img decoding=\"async\" title=\"Excel'de-se\u00e7im-sembol-dakikas\u0131ndan-onay i\u015fareti ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-a-partir-du-symbole-de-selection-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Sonunda <strong>\u201cEkle\u201d ye t\u0131klay\u0131n<\/strong> ve pencereyi kapat\u0131n.<\/li><\/ol><p> Bu bir &#8220;Sarma&#8221; yaz\u0131 tipi oldu\u011fundan ve onu bir h\u00fccreye ekledi\u011finiz anda Excel, h\u00fccrenin yaz\u0131 tipi stilini &#8220;Sarma&#8221; olarak de\u011fi\u015ftirir.<\/p><p> Basit bir onay i\u015faretinin yan\u0131 s\u0131ra kullanabilece\u011finiz <strong>kutulu bir onay i\u015fareti<\/strong> (254) de bulunmaktad\u0131r.<\/p><p> Zaten metninizin bulundu\u011fu bir h\u00fccreye onay i\u015fareti sembol\u00fc eklemek istiyorsan\u0131z, o h\u00fccreyi d\u00fczenlemeniz gerekir (F2&#8217;yi kullan\u0131n).<\/p><p> Yukar\u0131daki y\u00f6ntem biraz uzundur ancak herhangi bir form\u00fcl veya k\u0131sayol tu\u015fu kullanman\u0131za gerek yoktur ve bunu bir h\u00fccreye ekledikten sonra kopyalay\u0131p yap\u0131\u015ft\u0131rabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> 4. Onay i\u015faretine d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in bir <span style=\"color: #ea493f;\">OTOMAT\u0130K D\u00dcZELTME<\/span> olu\u015fturun<\/h2><p> Klavye k\u0131sayolundan sonra en h\u0131zl\u0131 yol, h\u00fccreye bir onay\/onay sembol\u00fc eklemek, yani OTOMAT\u0130K D\u00dcZELTME olu\u015fturmakt\u0131r.<\/p><p> Excel&#8217;de yanl\u0131\u015f yaz\u0131lan s\u00f6zc\u00fckleri d\u00fczelten bir se\u00e7enek vard\u0131r. Yani &#8220;temizle&#8221; yazd\u0131\u011f\u0131n\u0131zda, onu &#8220;Temizle&#8221;ye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve bu do\u011fru kelimedir.<\/p><p> Art\u0131k bu size bir kelime i\u00e7in OTOMAT\u0130K D\u00dcZELTME olu\u015fturma se\u00e7ene\u011fini sunar ve Excel&#8217;in onay i\u015faretine d\u00f6n\u00fc\u015ft\u00fcrmesini istedi\u011finiz bir kelimeyi tan\u0131mlars\u0131n\u0131z.<\/p><p> Kullanman\u0131z gereken ad\u0131mlar \u015funlard\u0131r:<\/p><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve <strong>Excel Se\u00e7enekleri&#8217;ni a\u00e7\u0131n<\/strong> . <br><img decoding=\"async\" title=\"excel'de-onay i\u015fareti-eklemek i\u00e7in-dosya-se\u00e7enekleri-sekmesini a\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-les-options-de-longlet-fichier-pour-ajouter-une-coche-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"open-options-from-file-tab-to-add-checkmark-in-excel\"><\/li><li> Bundan sonra \u201cProva Yapma\u201d ya gidin ve <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-duzeltme\/\"><strong>Otomatik D\u00fczeltme se\u00e7ene\u011fini a\u00e7\u0131n<\/strong><\/a> . <br><img decoding=\"async\" title=\"h\u00fccrede onay i\u015fareti olu\u015fturmak i\u00e7in otomatik d\u00fczeltme se\u00e7ene\u011fini a\u00e7\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-loption-de-correction-automatique-pour-creer-une-coche-dans-une-cellule-1.png\" sizes=\"\" srcset=\"\" alt=\"open-autocorrect-option-to-create-checkmark-in-a-cell\"><\/li><li> \u015eimdi bu ileti\u015fim kutusundaki &#8220;De\u011fi\u015ftir&#8221; kutusuna, Excel&#8217;in bir onay i\u015fareti sembol\u00fc d\u00f6nd\u00fcrece\u011fi <strong>yazmak istedi\u011finiz kelimeyi girin<\/strong> (burada CMRK kullan\u0131yorum).<\/li><li> Daha sonra \u201cWith:\u201d alan\u0131na buradan kopyalayabilece\u011finiz onay i\u015faretini girin. <br><img decoding=\"async\" title=\"Excel'de otomatik d\u00fczeltme se\u00e7ene\u011fi ekleme onay i\u015faretine de\u011fi\u015ftirme ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-remplacement-dans-loption-de-correction-automatique-inserer-une-coche-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"add-a-replacement-in-autocorrect-option-insert-a-checkmark-in-excel\"><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Art\u0131k CHMRK&#8217;ye her girdi\u011finizde Excel bunu ger\u00e7ek bir onay i\u015faretine d\u00f6n\u00fc\u015ft\u00fcrecek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-en-utilisant-la-correction-automatique-1.gif\" sizes=\"\" srcset=\"\" alt=\"otomatik d\u00fczeltmeyi kullanarak Excel'e onay i\u015fareti ekleyin\"><\/figure><\/div><p> Otomatik olarak d\u00fczeltilen bu onay i\u015faretiyle ilgili dikkat etmeniz gereken birka\u00e7 \u015fey var.<\/p><ul><li> Otomatik d\u00fczeltme olu\u015fturdu\u011funuzda, bunun b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 oldu\u011funu hat\u0131rlaman\u0131z gerekir. Dolay\u0131s\u0131yla en iyi yol, ayn\u0131 kelimeyi kullanarak iki farkl\u0131 otomatik d\u00fczeltme olu\u015fturmak olabilir.<\/li><li> Onay i\u015fareti olarak d\u00fczeltilmesini belirtti\u011finiz kelime, yaln\u0131zca ayr\u0131 bir kelime olarak girmeniz durumunda d\u00f6n\u00fc\u015ft\u00fcr\u00fclecektir. Diyelim ki Task1CHMRK girerseniz Task1&#8217;e d\u00f6n\u00fc\u015fmeyecek. Yani metin G\u00f6rev1 CHMRK olmal\u0131d\u0131r.<\/li><li> OTOMAT\u0130K d\u00fczeltme se\u00e7ene\u011fi t\u00fcm Office uygulamalar\u0131na uygulan\u0131r. Yani bir onay i\u015fareti i\u00e7in otomatik d\u00fczeltme olu\u015fturdu\u011funuzda, bunu di\u011fer uygulamalarda da kullanabilirsiniz.<\/li><\/ul><h2 class=\"wp-block-heading\"> 5. H\u00fccreye onay i\u015fareti eklemek i\u00e7in makro<\/h2><p> \u00c7abalar\u0131n\u0131zdan ve zamandan tasarruf etmek istiyorsan\u0131z onay i\u015fareti eklemek i\u00e7in VBA kodunu kullanabilirsiniz. \u0130\u015fte kod:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub addCheckMark() Dim rng As Range For Each rng In Selection With rng .Font.Name = \"Wingdings\" .Value = \"\u00fc\" End With Next rng End Sub<\/code><\/pre><p class=\"qt-tip\"> <strong><span style=\"color: #000000;\">Profesyonel \u0130pucu:<\/span><\/strong> Bu kodu t\u00fcm dosyalarda kullanmak i\u00e7in onu <a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">ki\u015fisel makrolar klas\u00f6r\u00fcn\u00fcze<\/a> ekleyin.<\/p><h3 class=\"wp-block-heading\"> Bu kodun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131 a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r.<\/h3><p> Bir h\u00fccreyi veya h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ip bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, h\u00fccrelerin her birinin i\u00e7inden ge\u00e7erek yaz\u0131 stilini \u201cWingdings\u201d olarak de\u011fi\u015ftiriyor ve i\u00e7ine \u201c\u00fc\u201d de\u011ferini giriyor.<\/p><h3 class=\"wp-block-heading\"> QAT&#8217;a makro kodu ekleme<\/h3><p> Bu, bu kodu i\u015finizde daha s\u0131k kullanacaksan\u0131z kullanabilece\u011finiz bir PRO ipucudur. Bunu yapmak i\u00e7in \u015fu basit ad\u0131mlar\u0131 izleyin:<\/p><ol><li> \u00d6ncelikle \u201c <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-erisim-cubugu\/\">H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu<\/a> \u201dnun a\u015fa\u011f\u0131 okuna t\u0131klay\u0131n ve \u201cDi\u011fer Komutlar\u201d\u0131 a\u00e7\u0131n.<\/li><li> \u015eimdi, \u201cKomutlar\u0131 \u015euradan Se\u00e7in\u201d k\u0131sm\u0131ndan \u201cMakrolar\u201d\u0131 se\u00e7in ve bu makro kodunu QAT\u2019a eklemek i\u00e7in \u201cEkle&gt;&gt;\u201dye t\u0131klay\u0131n.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><h3 class=\"wp-block-heading\"> <span style=\"color: #0000ee;\">VBA ile \u00e7ift t\u0131klama y\u00f6ntemi<\/span><\/h3><p> Diyelim ki, h\u00fccreye \u00e7ift t\u0131klayarak bir onay i\u015fareti eklemek istedi\u011finiz bir yap\u0131lacaklar listeniz var.<\/p><p> Bunu VBA&#8217;n\u0131n \u00e7ift t\u0131klama olay\u0131n\u0131 kullanarak ba\u015farabilirsiniz. Burada ayn\u0131 kodu a\u015fa\u011f\u0131daki kodu kullan\u0131yorum: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserez-une-coche-dans-exce-en-utilisant-la-methode-1-du-double-clic-vba.gif\" sizes=\"\" srcset=\"\" alt=\"vba-\u00e7ift t\u0131klama y\u00f6ntemini kullanarak exce'ye onay i\u015fareti ekleme\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 2 Then Cancel = True Target.Font.Name = \"Wingdings\" If Target.Value = \"\" Then Target.Value = \"\u00fc\" Else Target.Value = \"\" End If End If End Sub<\/code><\/pre><h4 class=\"wp-block-heading\"> <strong>Bu kod nas\u0131l kullan\u0131l\u0131r?<\/strong><\/h4><ol><li> \u00d6ncelikle \u00e7al\u0131\u015fma sayfas\u0131 VBA kodu penceresini a\u00e7man\u0131z ve bunun i\u00e7in \u00e7al\u0131\u015fma sayfas\u0131 sekmesine sa\u011f t\u0131klay\u0131p g\u00f6r\u00fcn\u00fcm kodunu se\u00e7meniz gerekiyor. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-la-fenetre-de-code-pour-ajouter-du-code-dans-la-feuille-de-calcul-pour-ajouter-une-coche-dans-une-cellule-en-double-cliquant-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00e7ift t\u0131klayarak bir h\u00fccreye-onay i\u015fareti eklemek i\u00e7in \u00e7al\u0131\u015fma sayfas\u0131na-kod eklemek i\u00e7in kod penceresini a\u00e7\u0131n\"><\/li><li> Daha sonra bu kodu buraya yap\u0131\u015ft\u0131r\u0131n ve VB edit\u00f6r\u00fcn\u00fc kapat\u0131n.<\/li><li> \u015eimdi \u00e7al\u0131\u015fma sayfas\u0131na d\u00f6n\u00fcn ve B s\u00fctunundaki herhangi bir h\u00fccreye \u00e7ift t\u0131klayarak onay i\u015fareti ekleyin.<\/li><\/ol><h4 class=\"wp-block-heading\"> Bu kod nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h4><p> Bir h\u00fccreye \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda bu kod devreye girecek ve \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131z h\u00fccrenin 2. s\u00fctunda olup olmad\u0131\u011f\u0131n\u0131 kontrol edecektir.<\/p><p> Ve bu h\u00fccre 2. s\u00fctundan ise yaz\u0131 stilini \u201cWrap\u201d olarak de\u011fi\u015ftirin. Daha sonra bu h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol eder, h\u00fccre bo\u015fsa onay i\u015faretine d\u00f6n\u00fc\u015fen \u201c\u00fc\u201d de\u011ferini girin. yaz\u0131 tipi stilini h\u00fccreye zaten uygulam\u0131\u015ft\u0131r.<\/p><p> Ve e\u011fer bir h\u00fccrede zaten bir onay i\u015fareti varsa, onu \u00e7ift t\u0131klayarak kald\u0131rabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> 6. Ko\u015fullu Bi\u00e7imlendirmeyle <span style=\"color: #44b682;\">Ye\u015fil Onay \u0130\u015fareti<\/span> Ekleyin<\/h2><p> Daha e\u011flenceli ve yarat\u0131c\u0131 olmak istiyorsan\u0131z, onay i\u015fareti i\u00e7in ko\u015fullu bi\u00e7imlendirmeyi kullanabilirsiniz.<\/p><p> Diyelim ki a\u015fa\u011f\u0131da, bir s\u00fctunda bir g\u00f6revin bulundu\u011fu ve g\u00f6rev tamamland\u0131\u011f\u0131nda bir onay i\u015fareti eklemek istedi\u011finiz ikinci bir g\u00f6revin bulundu\u011fu g\u00f6revlerin listesi var.<\/p><p> \u0130zlenecek ad\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir: <\/p><ul id=\"block-07017e43-b219-485c-9f14-ebfb8d24ef79\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"07017e43-b219-485c-9f14-ebfb8d24ef79\" data-type=\"core\/list\" data-title=\"List\"><li> \u00d6ncelikle ko\u015fullu bi\u00e7imlendirmeyi uygulamak istedi\u011finiz <strong>hedef h\u00fccreyi veya h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in<\/strong> .<\/li><li> Bundan sonra Ana Sayfa sekmesine gidin \u279c Stiller \u279c Ko\u015fullu Bi\u00e7imlendirme \u279c Simge Setleri \u279c Di\u011fer Kurallar.<\/li><li> \u015eimdi cetvel penceresinde a\u015fa\u011f\u0131dakileri yap\u0131n: <br><img decoding=\"async\" title=\"excel-ko\u015fullu-min-bi\u00e7imlendirmede onay i\u015fareti ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-la-mise-en-forme-conditionnelle-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li> Simge setinden ye\u015fil onay i\u015fareti stilini se\u00e7in.<\/li><li> \u201cYaln\u0131zca simgeyi g\u00f6ster\u201d se\u00e7ene\u011fini i\u015faretleyin.<\/li><li> Ye\u015fil onay i\u015faretinin de\u011feri olarak \u201c1\u201d girin ve t\u00fcrden bir say\u0131 se\u00e7in.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Bunu yapt\u0131ktan sonra, onay i\u015fareti girmeniz gereken h\u00fccreye 1 girin; ko\u015fullu bi\u00e7imlendirme nedeniyle ger\u00e7ek h\u00fccre de\u011feri olmadan ye\u015fil bir onay i\u015fareti al\u0131rs\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-vert-avec-mise-en-forme-conditionnelle-min-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de-ko\u015fullu-bi\u00e7imlendirme-min ile-ye\u015fil-onay i\u015fareti ekle\"><\/figure><\/div><p> Bu formatlamay\u0131 bir h\u00fccreden veya aral\u0131ktan ba\u015fka bir aral\u0131\u011fa uygulamak istiyorsan\u0131z bunu <a href=\"https:\/\/exceladvisor.org\/tr\/ressam-formati\/\" data-wpel-link=\"internal\">format boyay\u0131c\u0131s\u0131n\u0131 kullanarak<\/a> yapabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> 7. Onay i\u015fareti eklemek i\u00e7in bir <span style=\"color: #ea493f;\">a\u00e7\u0131l\u0131r liste<\/span> olu\u015fturun<\/h2><p> Onay i\u015faretini kopyalay\u0131p yap\u0131\u015ft\u0131rmak ve hatta form\u00fcl\u00fc eklemek istemiyorsan\u0131z, en iyi yol, veri do\u011frulamay\u0131 kullanarak bir a\u00e7\u0131l\u0131r men\u00fc olu\u015fturmak ve bu a\u00e7\u0131l\u0131r listeyi kullanarak bir onay i\u015fareti eklemek olabilir.<\/p><p> Ba\u015flamadan \u00f6nce, <strong><span style=\"color: #ff0000;\">bir onay i\u015fareti sembol\u00fcn\u00fc \u2713 kopyalad\u0131\u011f\u0131n\u0131zdan emin olun<\/span><\/strong> , ard\u0131ndan bu a\u00e7\u0131l\u0131r listeyi olu\u015fturmak istedi\u011finiz h\u00fccreyi se\u00e7in. Bundan sonra, onay i\u015fareti eklemek \u00fczere bir a\u00e7\u0131l\u0131r liste olu\u015fturmak i\u00e7in \u015fu basit ad\u0131mlar\u0131 izleyin: <\/p><ul id=\"block-0336b7f1-e9f7-4a57-8ec5-8ef77980d5e5\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"0336b7f1-e9f7-4a57-8ec5-8ef77980d5e5\" data-type=\"core\/list\" data-title=\"List\"><li> \u00d6ncelikle Veri sekmesi \u27a8 Veri Ara\u00e7lar\u0131 \u27a8 Veri Do\u011frulama \u27a8 Veri Do\u011frulama&#8217;ya gidin. <br><img decoding=\"async\" title=\"a\u00e7\u0131k veri do\u011frulama-ileti\u015fim kutusu-olu\u015fturmak i\u00e7in-a\u00e7\u0131l\u0131r-liste-eklemek i\u00e7in-onay i\u015fareti\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-la-boite-de-dialogue-de-validation-des-donnees-pour-creer-une-liste-deroulante-pour-inserer-une-coche-1.png\" sizes=\"\" srcset=\"\" alt=\"open-the-data-validation-dialog-box-to-create-a-drop-down-for-inserting-a-checkmark\"><\/li><li> \u015eimdi ileti\u015fim kutusunda a\u00e7\u0131l\u0131r listeden \u201cListe\u201dyi se\u00e7in.<\/li><li> Bundan sonra kopyalanan onay i\u015faretini \u201cKaynak\u201d a yap\u0131\u015ft\u0131r\u0131n. <br><img decoding=\"async\" title=\"liste-ve-yap\u0131\u015ft\u0131r-onay i\u015fareti-sembol\u00fcn\u00fc se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-la-liste-et-collez-le-symbole-de-coche-1.png\" sizes=\"\" srcset=\"\" alt=\"select-list-and-paste-the-checkmark-symbol\"><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"a\u00e7\u0131l\u0131r men\u00fcl\u00fc onay i\u015fareti ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-avec-un-menu-deroulant-1.png\" sizes=\"\" srcset=\"\" alt=\"insert-a-check-mark-with-a-drop-down\"><\/li><\/ul><p> \u0130htiya\u00e7 duydu\u011funuzda bunlardan birini kullanabilmeniz i\u00e7in onay i\u015faretiyle birlikte bir \u00e7arp\u0131 i\u015fareti \u2716 eklemek istiyorsan\u0131z, virg\u00fclle birlikte bir \u00e7arp\u0131 i\u015fareti ekleyin ve Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/p><p> A\u00e7\u0131l\u0131r listenin sa\u011flad\u0131\u011f\u0131 ba\u015fka bir avantaj daha vard\u0131r; h\u00fccrede onay i\u015fareti ve \u00e7arp\u0131 i\u015fareti d\u0131\u015f\u0131nda herhangi bir de\u011fere izin vermeyebilirsiniz.<\/p><p> Tek yapman\u0131z gereken \u201cHata Uyar\u0131s\u0131\u201d sekmesine gidip \u201cGe\u00e7ersiz veri giri\u015finden sonra hata uyar\u0131s\u0131n\u0131 g\u00f6ster\u201d kutusunu i\u015faretlemek, ard\u0131ndan t\u00fcr\u00fc, ba\u015fl\u0131\u011f\u0131 ve farkl\u0131 bir de\u011fer girildi\u011finde g\u00f6r\u00fcnt\u00fclenecek mesaj\u0131 se\u00e7mek.<\/p><p> <strong>\u0130lgili<\/strong><\/p><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\" data-wpel-link=\"internal\">Excel&#8217;de ba\u011f\u0131ml\u0131 bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\" data-wpel-link=\"internal\">Excel&#8217;de Dinamik A\u00e7\u0131l\u0131r Liste Nas\u0131l Olu\u015fturulur<\/a><\/li><\/ul><h2 class=\"wp-block-heading\"> 8. CHAR fonksiyonunu kullan\u0131n<\/h2><p> Her zaman kendinizin bir onay i\u015fareti girmenize gerek yoktur. Ayr\u0131ca bir form\u00fcl kullanarak bunu otomatikle\u015ftirebilirsiniz. Ba\u015fka bir h\u00fccredeki de\u011fere dayal\u0131 olarak bir onay i\u015fareti eklemek istedi\u011finizi varsayal\u0131m.<\/p><p> A\u015fa\u011f\u0131daki gibi C s\u00fctununa yap\u0131lan de\u011feri girdi\u011finizde form\u00fcl A s\u00fctununda bir onay i\u015fareti d\u00f6nd\u00fcrecektir. Bunun gibi bir form\u00fcl olu\u015fturmak i\u00e7in CHAR fonksiyonunu kullanmam\u0131z gerekir.<\/p><p> CHAR(say\u0131) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-via-la-formule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h3 class=\"wp-block-heading\"> H\u0131zl\u0131 G\u0130R\u0130\u015e: CHAR \u0130\u015flevi<\/h3><p> CHAR i\u015flevi, ASCII de\u011ferine ve Macintosh karakter k\u00fcmesine g\u00f6re karakteri d\u00f6nd\u00fcr\u00fcr.<\/p><p> S\u00f6zdizimi:<\/p><p> CHAR(say\u0131)<\/p><h3 class=\"wp-block-heading\"> \u2026Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> S\u00f6yledi\u011fim gibi CHAR, bir say\u0131y\u0131 ANSI karakterlerine (Windows) ve Macintosh karakter setine (Mac) d\u00f6n\u00fc\u015ft\u00fcren bir i\u015flevdir. Yani bir onay i\u015faretinin ANSI kodu olan 252&#8217;yi girdi\u011finizde form\u00fcl bir onay i\u015fareti d\u00f6nd\u00fcr\u00fcr.<\/p><h2 class=\"wp-block-heading\"> 9. <span style=\"color: #ea493f;\">Grafik onay i\u015fareti<\/span><\/h2><p> E\u011fer benim gibi OFFICE 365 kullan\u0131yorsan\u0131z \u015feridinizde &#8220;Draw&#8221; ad\u0131nda yeni bir sekmenin oldu\u011funu g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/dessinez-une-coche-dans-un-tableur-a-laide-dun-stylo-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"kalem kullanarak-e-tablo-setinde-onay-i\u015fareti \u00e7iz\" width=\"697\" height=\"134\"><\/figure><\/div><p> \u015eimdi olay \u015fu: Bu sekmede do\u011frudan e-tablonuzda \u00e7izim yapma se\u00e7ene\u011finiz var. Kullanabilece\u011finiz farkl\u0131 kalemler ve i\u015faretleyiciler var.<\/p><p> Basit bir onay i\u015fareti \u00e7izebilirsiniz ve Excel bunu grafik olarak ekleyecektir.<\/p><p> <strong><span style=\"color: #000000;\">En iyi yan\u0131<\/span><\/strong> , bunu ba\u015fkalar\u0131yla payla\u015ft\u0131\u011f\u0131n\u0131zda, Excel&#8217;in farkl\u0131 bir s\u00fcr\u00fcm\u00fcn\u00fc kullansalar bile grafik olarak g\u00f6r\u00fcnt\u00fclenmesidir. Ayr\u0131ca silmek i\u00e7in bir d\u00fc\u011fme de var. Devam edip bu &#8220;\u00c7izim&#8221; sekmesini ke\u015ffetmeniz gerekiyor, onunla yapabilece\u011finiz pek \u00e7ok harika \u015fey var.<\/p><h2 class=\"wp-block-heading\"> 10. Onay kutusunu h\u00fccrede onay i\u015fareti olarak kullan\u0131n<\/h2><p> Onay kutusunu onay i\u015fareti olarak da kullanabilirsiniz. Fakat ikisi aras\u0131nda k\u00fc\u00e7\u00fck bir fark var:<\/p><ol><li> Onay kutusu, \u00e7al\u0131\u015fma sayfas\u0131n\u0131n \u00fcst\u00fcne yerle\u015ftirilen katman benzeri bir nesnedir, ancak onay i\u015fareti, h\u00fccreye ekleyebilece\u011finiz bir sembold\u00fcr.<\/li><li> Onay kutusu ayr\u0131 bir nesnedir ve bir h\u00fccrenin i\u00e7eri\u011fini silerseniz onay kutusu da onunla birlikte silinmez. \u00d6te yandan onay i\u015fareti, h\u00fccrenin i\u00e7ine yerle\u015ftirdi\u011finiz bir simgedir.<\/li><\/ol><p> <a href=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\" data-wpel-link=\"internal\">Burada bir onay kutusu hakk\u0131nda bilgi edinmenize ve onu do\u011fru \u015fekilde kullanman\u0131za yard\u0131mc\u0131 olabilecek ayr\u0131nt\u0131l\u0131 k\u0131lavuz bulunmaktad\u0131r<\/a> .<\/p><h2 class=\"wp-block-heading\"> 11. Bir onay i\u015fareti ekleyin (sat\u0131r i\u00e7i)<\/h2><p> Excel&#8217;in \u00e7evrimi\u00e7i uygulamas\u0131n\u0131 kullan\u0131yorsan\u0131z bir h\u00fccreye onay i\u015fareti koymak i\u00e7in farkl\u0131 bir y\u00f6ntem izlemelisiniz.<\/p><p> Sorun \u015fu ki, k\u0131sayol tu\u015funu kullanabilirsiniz ancak &#8220;Winding&#8221; yaz\u0131 tipi yoktur, dolay\u0131s\u0131yla onu onay i\u015faretine d\u00f6n\u00fc\u015ft\u00fcremezsiniz. CHAR i\u015flevini kullansan\u0131z bile onay i\u015faretine d\u00f6n\u00fc\u015fmeyecektir.<\/p><p> Gol\u2026Gol\u2026Gol\u2026<\/p><p> Sembollerin onay i\u015faretlerini eklemesini sa\u011flamak i\u00e7in \u00e7evrimi\u00e7i Excel&#8217;e bir uygulama y\u00fckleyerek basit bir yol buldum. \u0130zlenecek ad\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir: <\/p><ul id=\"block-1628af31-3129-4f27-a04a-1e1d605f4b63\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"1628af31-3129-4f27-a04a-1e1d605f4b63\" data-type=\"core\/list\" data-title=\"List\"><li> \u0130lk olarak Ekle \u279c Eklentiler sekmesine gidin ve ard\u0131ndan Office Eklentileri&#8217;ni t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"\u00e7evrimi\u00e7i-excel'e-onay i\u015fareti-eklemek i\u00e7in-bir-uygulamay\u0131-eklemek i\u00e7in-eklentileri a\u00e7\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-des-complements-pour-inserer-une-application-pour-ajouter-une-coche-dans-Excel-en-ligne-1.png\" sizes=\"\" srcset=\"\" alt=\"open-add-ins-to-insert-an-app-to-add-checkmark-in-online-excel\"><\/li><li> \u015eimdi eklentiler penceresinde ma\u011fazaya t\u0131klay\u0131n ve \u201cSimge\u201dyi aray\u0131n.<\/li><li> Burada \u201cSembol ve Karakterler\u201d ad\u0131nda bir eklentiniz olacak, y\u00fcklemek i\u00e7in Ekle butonuna t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"arama-sembol-uygulama-arama \u00e7ubu\u011fundan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rechercher-lapplication-de-symboles-dans-la-barre-de-recherche-1.png\" sizes=\"\" srcset=\"\" alt=\"search-for-the-symbol-app-from-the-search-bar\"><\/li><li> Bundan sonra Eklentiler sekmesine gidin ve yeni y\u00fckledi\u011finiz eklentiyi a\u00e7\u0131n.<\/li><li> Bu noktada, onay i\u015fareti sembol\u00fcn\u00fc bulabilece\u011finiz ve onu h\u00fccreye eklemek i\u00e7in \u00e7ift t\u0131klayabilece\u011finiz bir yan b\u00f6lmeniz var. <br><img decoding=\"async\" title=\"arama \u00e7ubu\u011fundan onay i\u015faretini aray\u0131n ve eklemek i\u00e7in t\u0131klay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherchez-la-coche-dans-la-barre-de-recherche-et-cliquez-dessus-pour-linserer-1.png\" sizes=\"\" srcset=\"\" alt=\"search-for-the-checkmark-from-the-searchbar-and-click-on-it-to-insert-it\"><\/li><\/ul><p> Evet, bu o.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coche.zip\" rel=\"nofollow\" data-wpel-link=\"internal\"><strong>\u2026Devam etmek ve kendiniz denemek i\u00e7in bu \u00f6rnek dosyay\u0131 buradan almay\u0131 unutmay\u0131n<\/strong><\/a><\/p><h2 class=\"wp-block-heading\"> \u00d6\u011frenmeniz gereken <span style=\"color: #ea493f;\">\u00d6NEML\u0130 noktalardan<\/span> baz\u0131lar\u0131<\/h2><p> Onay i\u015faretlerini kullanma hakk\u0131nda \u00f6\u011frenmeniz gereken baz\u0131 \u015feyler.<\/p><h3 class=\"wp-block-heading\"> 1. Onay i\u015faretini bi\u00e7imlendirin<\/h3><p> Bir onay i\u015faretini bi\u00e7imlendirmek bazen gerekli olabilir, \u00f6zellikle de bir \u015feyi do\u011frulad\u0131\u011f\u0131n\u0131z verilerle \u00e7al\u0131\u015f\u0131rken. Onay i\u015faretiyle yapabilecekleriniz \u015funlard\u0131r:<\/p><ul><li> <strong>Kal\u0131n<\/strong> ve <em>italik<\/em> yap\u0131n.<\/li><li> Rengini de\u011fi\u015ftirin.<\/li><li> Yaz\u0131 tipi boyutunu art\u0131r\u0131n ve azalt\u0131n.<\/li><li> Alt \u00e7izgi uygulay\u0131n.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2. Onay i\u015faretini kald\u0131r\u0131n<\/h3><p> Onay i\u015faretini kald\u0131rmak basittir ve tek yapman\u0131z gereken i\u015faretin bulundu\u011fu h\u00fccreyi se\u00e7ip Sil tu\u015funa basmakt\u0131r.<\/p><p> Veya bir h\u00fccrede onay i\u015fareti bulunan bir metniniz varsa a\u015fa\u011f\u0131daki y\u00f6ntemlerden birini kullanabilirsiniz.<\/p><ol><li> <strong><span style=\"color: #000000;\">\u00d6ncelikle<\/span><\/strong> h\u00fccreyi (F2) d\u00fczenleyin ve onay i\u015faretini kald\u0131r\u0131n.<\/li><li> <strong><span style=\"color: #000000;\">\u0130kinci olarak<\/span><\/strong> , <a href=\"https:\/\/exceladvisor.org\/tr\/bul-degistir\/\" data-wpil=\"url\" data-wpel-link=\"internal\">Bul ve De\u011fi\u015ftir se\u00e7ene\u011fini<\/a> kullanarak onay i\u015faretini karakter i\u00e7ermeyen \u015fekilde de\u011fi\u015ftirin.<\/li><\/ol><h3 class=\"wp-block-heading\"> 3. Onay i\u015faretlerini say\u0131n<\/h3><p> Diyelim ki bir h\u00fccre aral\u0131\u011f\u0131ndaki onay i\u015fareti simgelerini saymak istiyorsunuz. COUNTIF ve CHAR&#8217;\u0131 birle\u015ftirerek form\u00fcl\u00fc kullanman\u0131z gerekir; form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">=COUNTIF(G3:G9,CHAR(252))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-simple-formule-countif-pour-compter-les-symboles-de-coche-a-partir-dune-plage-de-cellules-1.png\" sizes=\"\" srcset=\"\" alt=\"bir h\u00fccre aral\u0131\u011f\u0131n\u0131n-onay i\u015faretlerini-saymak i\u00e7in-basit-e\u011fer-sayma form\u00fcl\u00fc\" width=\"-476\" height=\"-319\"><\/figure><\/div><p> Bu form\u00fclde CHAR&#8217;\u0131n d\u00f6nd\u00fcrd\u00fc\u011f\u00fc karakterleri saymak i\u00e7in COUNTIF kulland\u0131m.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coche.zip\" rel=\"nofollow\" data-wpel-link=\"internal\"><strong>\u2026takip etmek ve kendiniz denemek i\u00e7in buradaki \u00f6rnek dosyaya g\u00f6z atmay\u0131 unutmay\u0131n<\/strong><\/a><\/p><h2 class=\"wp-block-heading\"> Sonunda,<\/h2><p> <span style=\"font-size: 1em; letter-spacing: 0px;\">Listeleri y\u00f6netirken onay i\u015fareti kullan\u0131\u015fl\u0131d\u0131r.<\/span><\/p><p> Ve Excel&#8217;de onay i\u015faretli bir liste olu\u015fturmak art\u0131k sorun de\u011fil \u00e7\u00fcnk\u00fc bunun i\u00e7in 10&#8217;dan fazla y\u00f6ntem biliyorsunuz. Yukar\u0131daki t\u00fcm y\u00f6ntemler aras\u0131nda her zaman ko\u015fullu bi\u00e7imlendirmeyi kullanmay\u0131 ve bazen kopyalay\u0131p yap\u0131\u015ft\u0131rmay\u0131 severim.<\/p><p> Sizin i\u00e7in m\u00fckemmel oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcn\u00fcz herhangi birini kullanabilirsiniz. Bu ipucunun g\u00fcnl\u00fck i\u015flerinizde size yard\u0131mc\u0131 olaca\u011f\u0131n\u0131 umuyorum. Ama \u015fimdi bana bir \u015feyi s\u00f6yle.<\/p><p> <strong>Yukar\u0131daki y\u00f6ntemlerden herhangi birini hi\u00e7 kulland\u0131n\u0131z m\u0131? En sevdi\u011finiz y\u00f6ntem hangisi?<\/strong><\/p><p> <strong>D\u00fc\u015f\u00fcncelerinizi yorum k\u0131sm\u0131nda benimle payla\u015fmay\u0131<\/strong> unutmay\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bundan keyif alacaklard\u0131r.<\/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\/excelin-temelleri\/\">Microsoft Excel Temelleri (Bile\u015fenler, Par\u00e7alar ve Bilgi Notlar\u0131)<\/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\/negatif-sayiyi-pozitife-cevir\/\">Negatif bir say\u0131y\u0131 Excel&#8217;de pozitife d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-damgasi\/\">Excel&#8217;e zaman damgas\u0131 ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pire\/\">Excel&#8217;e madde i\u015faretleri ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-ok-ekle\/\">Excel&#8217;de bir h\u00fccreye ok ekleme<\/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-1491","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;e onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde Excel&#039;de bir h\u00fccreye onay i\u015fareti eklemenin en kolay yollar\u0131ndan baz\u0131lar\u0131n\u0131 \u00f6\u011freneceksiniz. Y\u00f6ntemlerim\" \/>\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-isareti-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;e onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde Excel&#039;de bir h\u00fccreye onay i\u015fareti eklemenin en kolay yollar\u0131ndan baz\u0131lar\u0131n\u0131 \u00f6\u011freneceksiniz. Y\u00f6ntemlerim\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-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=\"15 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/\",\"name\":\"\u25b7 Excel&#39;e onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\",\"datePublished\":\"2023-11-21T11:44:20+00:00\",\"dateModified\":\"2023-12-10T06:01:49+00:00\",\"description\":\"Bu e\u011fitimde Excel&#39;de bir h\u00fccreye onay i\u015fareti eklemenin en kolay yollar\u0131ndan baz\u0131lar\u0131n\u0131 \u00f6\u011freneceksiniz. Y\u00f6ntemlerim\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de onay i\u015fareti sembol\u00fc (\u2713) 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":"\u25b7 Excel&#39;e onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?","description":"Bu e\u011fitimde Excel&#39;de bir h\u00fccreye onay i\u015fareti eklemenin en kolay yollar\u0131ndan baz\u0131lar\u0131n\u0131 \u00f6\u011freneceksiniz. Y\u00f6ntemlerim","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-isareti-2\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;e onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?","og_description":"Bu e\u011fitimde Excel&#39;de bir h\u00fccreye onay i\u015fareti eklemenin en kolay yollar\u0131ndan baz\u0131lar\u0131n\u0131 \u00f6\u011freneceksiniz. Y\u00f6ntemlerim","og_url":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:49+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"15 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/","url":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/","name":"\u25b7 Excel&#39;e onay i\u015fareti sembol\u00fc (\u2713) nas\u0131l eklenir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif","datePublished":"2023-11-21T11:44:20+00:00","dateModified":"2023-12-10T06:01:49+00:00","description":"Bu e\u011fitimde Excel&#39;de bir h\u00fccreye onay i\u015fareti eklemenin en kolay yollar\u0131ndan baz\u0131lar\u0131n\u0131 \u00f6\u011freneceksiniz. Y\u00f6ntemlerim","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de onay i\u015fareti sembol\u00fc (\u2713) 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\/1491","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=1491"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1491\/revisions"}],"predecessor-version":[{"id":2560,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1491\/revisions\/2560"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}