\u00d6rne\u011fin, bir form\u00fcldeki ba\u015fvuruyu A1<\/strong> h\u00fccresine kilitlemek i\u00e7in $A$1<\/strong> yazabilirsiniz; b\u00f6ylece form\u00fcl\u00fc ba\u015fka bir h\u00fccreye s\u00fcr\u00fckledi\u011finizde her zaman A1 kullan\u0131l\u0131r.<\/span><\/p>\n Ancak, bir Excel tablosundaki bir s\u00fctun ad\u0131na yap\u0131lan ba\u015fvuruyu kilitlemek istiyorsan\u0131z bunun yerine k\u00f6\u015feli parantez kullanmal\u0131s\u0131n\u0131z.<\/span><\/p>\n \u00d6rne\u011fin, ba\u015fvuruyu bir Excel sayfas\u0131ndaki Tablo1<\/strong> adl\u0131 tablodaki Noktalar<\/strong> adl\u0131 s\u00fctuna kilitlemek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, D1<\/strong> h\u00fccresindeki de\u011feri Tablo1’in<\/strong> Puanlar<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011ferle \u00e7arpacakt\u0131r.<\/span><\/p>\n Bu form\u00fcl\u00fc di\u011fer h\u00fccrelere s\u00fcr\u00fckledi\u011finizde, bu s\u00fctunun referans\u0131n\u0131 kilitlemek i\u00e7in parantez kulland\u0131\u011f\u0131m\u0131zdan, Puanlar<\/strong> s\u00fctunundaki de\u011ferler form\u00fclde kullan\u0131lmaya devam edecektir.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n Farkl\u0131 tak\u0131mlardaki basketbolcular\u0131n att\u0131\u011f\u0131 puanlar hakk\u0131nda bilgi i\u00e7eren Excel’de Tablo1<\/strong> adl\u0131 a\u015fa\u011f\u0131daki tabloya sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki 5, 10 ve 20. Nokta<\/strong> s\u00fctunundaki de\u011ferleri \u00e7arparak elde edilen bu de\u011ferleri yeni s\u00fctunlarda g\u00f6r\u00fcnt\u00fclemek istiyoruz.<\/span><\/p>\n Bunu yapmak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p F s\u00fctununa ula\u015fana kadar sa\u011fa s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Yeni s\u00fctunlar, Tablo 1’in<\/strong> Puanlar<\/strong> s\u00fctununda kar\u015f\u0131l\u0131k gelen de\u011ferleri 5, 10 ve 20 ile \u00e7arp\u0131larak g\u00f6sterir.<\/span><\/span><\/p>\n Table1[[Points]:[Points]]<\/strong> s\u00f6zdizimini kullanarak referans\u0131 Table1’in<\/strong> Puanlar<\/strong> s\u00fctununa kilitleyebiliriz.<\/span><\/p>\n Yani form\u00fcl\u00fc sa\u011fa s\u00fcr\u00fckledi\u011fimizde Puan<\/strong> s\u00fctununu kilitli tutuyoruz ve ilk sat\u0131rda kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z yeni de\u011ferlerle \u00e7arp\u0131yoruz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: Aral\u0131ktaki metni bulun ve h\u00fccre referans\u0131n\u0131 d\u00f6nd\u00fcr\u00fcn<\/a> Normal Excel form\u00fcllerinde h\u00fccre referanslar\u0131n\u0131 kilitlemek i\u00e7in dolar i\u015faretlerini kullanabilirsiniz. \u00d6rne\u011fin, bir form\u00fcldeki ba\u015fvuruyu A1 h\u00fccresine kilitlemek i\u00e7in $A$1 yazabilirsiniz; b\u00f6ylece form\u00fcl\u00fc ba\u015fka bir h\u00fccreye s\u00fcr\u00fckledi\u011finizde her zaman A1 kullan\u0131l\u0131r. Ancak, bir Excel tablosundaki bir s\u00fctun ad\u0131na yap\u0131lan ba\u015fvuruyu kilitlemek istiyorsan\u0131z bunun yerine k\u00f6\u015feli parantez kullanmal\u0131s\u0131n\u0131z. \u00d6rne\u011fin, ba\u015fvuruyu bir Excel sayfas\u0131ndaki Tablo1 adl\u0131 tablodaki Noktalar […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4889","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n = Table1[[Points]:[Points]]<\/span> * D1\n<\/span><\/strong><\/pre>\n \u00d6rnek: Excel’de bir tablo referans\u0131 nas\u0131l kilitlenir<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/languette-de-verrouillage1.png\")
<\/p>\n = Table1[[Points]:[Points]]<\/span> * D1<\/span><\/strong><\/pre>\n![\"Form\u00fclde](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/languette-de-verrouillage2.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: DOLAYLI’n\u0131n sayfa adlar\u0131yla nas\u0131l kullan\u0131laca\u011f\u0131<\/a>
Excel: kayan tablo nas\u0131l olu\u015fturulur<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"