Excel’de bir onay i\u015fareti sembol\u00fc eklemenin basit bir yolu “Sembol” komutunu kullanmakt\u0131r. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131dakilere ihtiyac\u0131n\u0131z vard\u0131r:<\/p>\n\n\n\n
- \n
- Onay i\u015faretini eklemek istedi\u011finiz h\u00fccreyi se\u00e7in. Ard\u0131ndan, Excel \u015feridindeki “Ekle” sekmesine <\/strong>gidin ve “Semboller” grubundaki “Sembol” d\u00fc\u011fmesine t\u0131klay\u0131n<\/strong>.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-using-the-Symbol-button.webp\")
<\/figure>\n\n\n\n- \n
- \u00c7e\u015fitli sembolleri ve \u00f6zel karakterleri g\u00f6r\u00fcnt\u00fcleyen bir ileti\u015fim kutusu g\u00f6r\u00fcnecektir. Yaz\u0131 Tipi alan\u0131nda “Wingdings “i se\u00e7in. <\/strong>Mevcut se\u00e7enekler aras\u0131ndan onay i\u015fareti sembol\u00fcn\u00fc bulun <\/strong>veya h\u0131zl\u0131 bir \u015fekilde bulmak <\/strong>i\u00e7in arama i\u015flevini kullan\u0131n. Onay i\u015fareti sembol\u00fcn\u00fc buldu\u011funuzda, onu se\u00e7in ve “Ekle” <\/strong>d\u00fc\u011fmesine t\u0131klay\u0131n.<\/strong><\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-using-the-Symbol-button-2.webp\")
<\/figure>\n\n\n\nSembol se\u00e7ili h\u00fccreye eklenir ve gerekti\u011finde yeniden boyutland\u0131rabilir veya yeniden konumland\u0131rabilirsiniz. Bu y\u00f6ntem, yaln\u0131zca birka\u00e7 onay i\u015faretini manuel olarak eklemeniz gerekti\u011finde kullan\u0131\u015fl\u0131d\u0131r, ancak g\u00fcncellenecek \u00e7ok say\u0131da h\u00fccreniz varsa zaman al\u0131c\u0131 olabilir.<\/p>\n\n\n\n
<\/a>Otomatik D\u00fczeltme kullanarak Microsoft Excel’de onay i\u015faretleri nas\u0131l eklenir<\/strong><\/h2>\n\n\n\n
Excel’in Otomatik D\u00fczeltme \u00f6zelli\u011fi, elektronik tablonuza onay i\u015fareti eklemek i\u00e7in ba\u015fka bir etkili yol sa\u011flar. AutoCorrect’i yap\u0131land\u0131rarak, otomatik olarak bir onay i\u015fareti sembol\u00fcyle de\u011fi\u015ftirilecek belirli bir metin dizesi tan\u0131mlayabilirsiniz.<\/p>\n\n\n\n
- \n
- Otomatik D\u00fczeltme’yi ayarlamak i\u00e7in “Dosya” sekmesine gidin, “Se\u00e7enekler “i se\u00e7in <\/strong>ve ard\u0131ndan “Prova “y\u0131 se\u00e7in.<\/strong><\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-utilizing-AutoCorrect-1.webp\")
<\/figure>\n\n\n\n- \n
- Otomatik D\u00fczeltme se\u00e7eneklerinde, “Otomatik D\u00fczeltme Se\u00e7enekleri” <\/strong>d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-utilizing-AutoCorrect-2.webp\")
<\/figure>\n\n\n\n- \n
- “De\u011fi\u015ftir” alan\u0131na<\/strong>, de\u011fi\u015ftirmeyi tetiklemesini istedi\u011finiz bir metin dizesi <\/strong>(\u00f6rne\u011fin, “chk”) yaz\u0131n.<\/strong><\/li>\n\n\n\n
- “\u0130le” alan\u0131na onay i\u015fareti sembol\u00fcn\u00fc (\u2713) girin veya bir karakter haritas\u0131ndan kopyalay\u0131n.<\/li>\n\n\n\n
- De\u011fi\u015fiklikleri kaydetmek i\u00e7in “Ekle “<\/strong>ye ve ard\u0131ndan “Tamam “a <\/strong>t\u0131klay\u0131n.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-utilizing-AutoCorrect-3.webp\")
<\/figure>\n\n\n\nBundan sonra, tan\u0131mlanan metin dizesini bir h\u00fccreye yazd\u0131\u011f\u0131n\u0131zda, Excel otomatik olarak onay i\u015fareti sembol\u00fcyle de\u011fi\u015ftirir. Bu y\u00f6ntem \u00f6zellikle b\u00fcy\u00fck bir veri k\u00fcmeniz varsa ve s\u0131k s\u0131k onay i\u015fareti eklemeniz gerekiyorsa kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n\n\n\n
<\/a>Form\u00fcller kullanarak Microsoft Excel’de onay i\u015faretleri nas\u0131l eklenir<\/strong><\/h2>\n\n\n\n
Excel’in form\u00fclleri, belirli ko\u015fullara veya \u00f6l\u00e7\u00fctlere dayal\u0131 olarak onay i\u015faretleri eklemek i\u00e7in dinamik bir yol sa\u011flar. Bir yakla\u015f\u0131m, bir ko\u015ful kar\u015f\u0131land\u0131\u011f\u0131nda bir onay i\u015fareti g\u00f6r\u00fcnt\u00fclemek i\u00e7in E\u011eER i\u015flevini CHAR i\u015fleviyle birlikte kullanmakt\u0131r.<\/p>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-using-Formulas.webp\")
<\/figure>\n\n\n\n\u00d6rne\u011fin, A1 h\u00fccresindeki de\u011fer 50’den b\u00fcy\u00fckse h\u00fccreye bir onay i\u015fareti (\u2611)<\/strong> eklemek i\u00e7in “=IF(<\/strong>A1>50;CHAR(252); ” “)<\/strong>” form\u00fcl\u00fcn\u00fc kullanabilirsiniz. Form\u00fcl\u00fc ve ko\u015fulu \u00f6zel gereksinimlerinize g\u00f6re ayarlay\u0131n. Bu y\u00f6ntem, elektronik tablonuzdaki verilere dayal\u0131 olarak onay i\u015faretlerinin eklenmesini otomatikle\u015ftirmenize olanak tan\u0131yarak b\u00fcy\u00fck veri k\u00fcmeleri veya onay i\u015faretlerinin dinamik olarak g\u00fcncellenmesi gereken durumlar i\u00e7in idealdir.<\/p>\n\n\n\n
<\/a>Webdings Yaz\u0131 Tipi kullanarak Microsoft Excel’de onay i\u015faretleri nas\u0131l eklenir<\/strong><\/h2>\n\n\n\n
Excel’de onay i\u015fareti eklemenin bir ba\u015fka y\u00f6ntemi de Wingdings veya Webdings yaz\u0131 tipini kullanmakt\u0131r. Bu yaz\u0131 tipleri, onay i\u015faretleri de dahil olmak \u00fczere \u00e7e\u015fitli semboller i\u00e7erir.<\/p>\n\n\n\n
- \n
- \u0130lk olarak, onay i\u015faretini eklemek istedi\u011finiz h\u00fccreyi se\u00e7in.<\/strong><\/li>\n\n\n\n
- Ard\u0131ndan, yaz\u0131 tipi a\u00e7\u0131l\u0131r men\u00fcs\u00fcnden yaz\u0131 tipini Webdings olarak de\u011fi\u015ftirin.<\/strong> Ard\u0131ndan, onay i\u015fareti sembol\u00fc i\u00e7in ilgili harfi yaz\u0131n. \u00d6rne\u011fin, Webdings’te onay i\u015fareti (\u2714) i\u00e7in “a” <\/strong>kullanabilirsiniz.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-using-Webdings-Font.webp\")
<\/figure>\n\n\n\n - Ard\u0131ndan, yaz\u0131 tipi a\u00e7\u0131l\u0131r men\u00fcs\u00fcnden yaz\u0131 tipini Webdings olarak de\u011fi\u015ftirin.<\/strong> Ard\u0131ndan, onay i\u015fareti sembol\u00fc i\u00e7in ilgili harfi yaz\u0131n. \u00d6rne\u011fin, Webdings’te onay i\u015fareti (\u2714) i\u00e7in “a” <\/strong>kullanabilirsiniz.<\/li>\n<\/ul>\n\n\n\n
- “De\u011fi\u015ftir” alan\u0131na<\/strong>, de\u011fi\u015ftirmeyi tetiklemesini istedi\u011finiz bir metin dizesi <\/strong>(\u00f6rne\u011fin, “chk”) yaz\u0131n.<\/strong><\/li>\n\n\n\n
- Otomatik D\u00fczeltme se\u00e7eneklerinde, “Otomatik D\u00fczeltme Se\u00e7enekleri” <\/strong>d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li>\n<\/ul>\n\n\n\n
- Otomatik D\u00fczeltme’yi ayarlamak i\u00e7in “Dosya” sekmesine gidin, “Se\u00e7enekler “i se\u00e7in <\/strong>ve ard\u0131ndan “Prova “y\u0131 se\u00e7in.<\/strong><\/li>\n<\/ul>\n\n\n\n
- \u00c7e\u015fitli sembolleri ve \u00f6zel karakterleri g\u00f6r\u00fcnt\u00fcleyen bir ileti\u015fim kutusu g\u00f6r\u00fcnecektir. Yaz\u0131 Tipi alan\u0131nda “Wingdings “i se\u00e7in. <\/strong>Mevcut se\u00e7enekler aras\u0131ndan onay i\u015fareti sembol\u00fcn\u00fc bulun <\/strong>veya h\u0131zl\u0131 bir \u015fekilde bulmak <\/strong>i\u00e7in arama i\u015flevini kullan\u0131n. Onay i\u015fareti sembol\u00fcn\u00fc buldu\u011funuzda, onu se\u00e7in ve “Ekle” <\/strong>d\u00fc\u011fmesine t\u0131klay\u0131n.<\/strong><\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/global.tab-tv.com\/tr\/wp-content\/uploads\/sites\/9\/2023\/07\/How-to-insert-check-marks-in-Microsoft-Excel-using-the-keyboard-shortcut.webp\")
<\/figure>\n\n\n\n