{"id":1513,"date":"2023-11-18T17:51:00","date_gmt":"2023-11-18T17:51:00","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/r1c1\/"},"modified":"2023-12-10T06:02:04","modified_gmt":"2023-12-10T06:02:04","slug":"r1c1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/r1c1\/","title":{"rendered":"Excel&#39;de r1c1 referans stili nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2457027521\"><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>Excel&#8217;de iki t\u00fcr h\u00fccre referans stili vard\u0131r; birincisi A1 ve ikincisi R1C1&#8217;dir. \u00c7o\u011fu Excel kullan\u0131c\u0131s\u0131 R1C1 referans stilinin varl\u0131\u011f\u0131ndan bile haberdar de\u011fil.<\/p><p> Ancak baz\u0131 kullan\u0131c\u0131lar bunu kullanmay\u0131 seviyor ve A1&#8217;den daha kullan\u0131\u015fl\u0131 buluyor. R1C1 stili biraz eski.<\/p><p> <a href=\"https:\/\/en.wikipedia.org\/wiki\/Multiplan#Cell_addressing_differences\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\u0130lk olarak Microsoft&#8217;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#8217;da tan\u0131t\u0131ld\u0131<\/a> .<\/p><p> Ancak birka\u00e7 y\u0131l sonra Microsoft, A1 stilini kullanmaya ba\u015flad\u0131 ve Lotus&#8217;tan ge\u00e7i\u015f yapan ki\u015filer bunu tan\u0131d\u0131k buldu; ancak R1C1, Excel&#8217;de her zaman oradayd\u0131.<\/p><p> R1C1&#8217;de A1&#8217;e g\u00f6re daha az ek fayda vard\u0131r. Ve bug\u00fcn bu makalede sizinle R1C1 referans stilini kullanman\u0131n t\u00fcm y\u00f6nlerini payla\u015fmak istiyorum.<\/p><p> O halde daha fazla uzatmadan bu konuyu inceleyelim.<\/p><h2 class=\"wp-block-heading\"> Referans stili A1 ve R1C aras\u0131ndaki fark<\/h2><p> A1 referans stilinde, alfabe olarak s\u00fctun ad\u0131 ve say\u0131 olarak sat\u0131r ad\u0131 vard\u0131r ve A1 h\u00fccresini se\u00e7ti\u011finizde, A s\u00fctununda ve 1. sat\u0131rda oldu\u011funuz anlam\u0131na gelir.<\/p><p> Ancak R1C1&#8217;de s\u00fctun ve sat\u0131r say\u0131lardan olu\u015fuyor.<\/p><p> Yani A1 h\u00fccresini se\u00e7ti\u011finizde size R1C1&#8217;i g\u00f6steriyor, yani 1. sat\u0131r ve 1. s\u00fctun anlam\u0131na geliyor, A2&#8217;ye giderseniz R2C1 olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\" sizes=\"\" srcset=\"\" alt=\"Referans Stili A1 ile Referans Stili R1C1 aras\u0131ndaki fark\"><\/figure><\/div><p> Yukar\u0131daki her iki \u00f6rnekte de ayn\u0131 aktif h\u00fccreye sahipsiniz ancak h\u00fccre adresleri farkl\u0131. <strong><span style=\"color: #ea493f;\">Ger\u00e7ek fark,<\/span><\/strong> form\u00fcl yazd\u0131\u011f\u0131n\u0131zda ve di\u011fer h\u00fccrelere referans kulland\u0131\u011f\u0131n\u0131zda ortaya \u00e7\u0131kar.<\/p><p> R1C1&#8217;de bir h\u00fccreye ba\u015fvurdu\u011funuzda, <strong><span style=\"color: #000000;\">aktif h\u00fccreye olan uzakl\u0131\u011f\u0131n\u0131 kullanarak<\/span><\/strong> ba\u015fvurulan h\u00fccrenin adresini olu\u015fturur.<\/p><p> \u00d6rne\u011fin A1 h\u00fccresinden B5 h\u00fccresine ba\u015fvurursan\u0131z B5&#8217;in adresi R[4]C[1] olarak g\u00f6r\u00fcnt\u00fclenecektir. <\/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\/referer-b5-a-partir-de-a1-en-utilisant-le-style-de-reference-r1c1.png\" sizes=\"auto, \" srcset=\"\" alt=\"r1c1 referans stilini kullanarak a1'den b5'e bak\u0131n\" width=\"312\" height=\"201\"><\/figure><\/div><p> \u015eimdi \u015f\u00f6yle d\u00fc\u015f\u00fcn\u00fcn. B5 h\u00fccresi, A1 h\u00fccresinin 4 sat\u0131r a\u015fa\u011f\u0131s\u0131nda ve 1 s\u00fctun \u00f6n\u00fcndedir, bu nedenle adresi R[4]C[1]&#8217;dir.<\/p><p> Ama i\u015fte vurucu nokta. Ayn\u0131 h\u00fccreye farkl\u0131 bir h\u00fccreden ba\u015fvurursan\u0131z adresi farkl\u0131 olacakt\u0131r.<\/p><p> <strong>Anla\u015f\u0131lmas\u0131 gereken nokta<\/strong> , R1C1 referans stilinde, bir h\u00fccre i\u00e7in kal\u0131c\u0131 bir adres bulunmad\u0131\u011f\u0131d\u0131r (g\u00f6receli bir referans kullan\u0131yorsan\u0131z), dolay\u0131s\u0131yla bir h\u00fccrenin adresi, ona nereye ba\u015fvurdu\u011funuza ba\u011fl\u0131d\u0131r.<\/p><p> R1C1 referans\u0131n\u0131 kullanmak, h\u00fccre referanslar\u0131yla \u00e7al\u0131\u015fmaya ger\u00e7ek\u00e7i bir yakla\u015f\u0131md\u0131r.<\/p><p> Bu yaz\u0131dan \u00f6nce bu yakla\u015f\u0131m\u0131 detayland\u0131raca\u011f\u0131m. Ama \u00f6nce onu nas\u0131l etkinle\u015ftirece\u011fimizi \u00f6\u011frenelim.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de R1C1 H\u00fccre Referans\u0131n\u0131 Etkinle\u015ftirme &#8211; Basit Ad\u0131mlar<\/h2><p> R1C1&#8217;i kullanmak i\u00e7in ilk yapman\u0131z gereken onu aktif hale getirmektir ve bunun i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemlerden herhangi birini kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> Excel se\u00e7eneklerinden<\/h3><p> R1C1 referans\u0131n\u0131 varsay\u0131lan olarak ayarlamak i\u00e7in l\u00fctfen bu basit ad\u0131mlar\u0131 izleyin.<\/p><ol><li> Dosya sekmesine gidin \u279c Se\u00e7enek \u279c Form\u00fcller \u279c Form\u00fcllerle \u00e7al\u0131\u015f\u0131n.<\/li><li> \u201cReferans Stili R1C1\u201di kontrol edin.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/activer-le-style-de-reference-r1c1-a-partir-des-options-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel'deki se\u00e7eneklerden r1c1 referans stilini etkinle\u015ftirin\"><\/figure><\/div><h3 class=\"wp-block-heading\"> VBA kodunu kullan<\/h3><p> Makrolara a\u015finaysan\u0131z ve zamandan tasarruf etmek istiyorsan\u0131z h\u00fccre referans stilleri aras\u0131nda ge\u00e7i\u015f yapmak i\u00e7in a\u015fa\u011f\u0131daki makro kodunu kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub ChangeCellRef() If Application.ReferenceStyle = xlA1 Then Application.ReferenceStyle = xlR1C1 Else Application.ReferenceStyle = xlA1 End If End Sub<\/code><\/pre><p> R1C1&#8217;i varsay\u0131lan ba\u015fvuru stiliniz yapt\u0131\u011f\u0131n\u0131zda, t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131ndaki form\u00fcllerdeki t\u00fcm ba\u015fvurular de\u011fi\u015fecektir.<\/p><h2 class=\"wp-block-heading\"> R1C1 Referans Stili Nas\u0131l \u00c7al\u0131\u015f\u0131r?<\/h2><p> \u015eimdi bu noktada R1C1&#8217;de bir konuda netsiniz; sat\u0131r numaran\u0131z ve s\u00fctun numaran\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombres-pour-la-colonne-et-la-ligne-dans-le-style-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1 stilinde s\u00fctun ve sat\u0131r say\u0131lar\u0131\"><\/figure><\/div><p> Ancak nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak i\u00e7in t\u00fcm farkl\u0131 referans t\u00fcrlerini \u00f6\u011frenmeniz gerekir. <\/p><figure class=\"wp-block-table is-style-stripes\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\"> Referans stili A1 <\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> Referans stili R1C1<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> Referans t\u00fcr\u00fc <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\"> A1 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R[-4]C[-1]<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> G\u00f6reli referans <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\">$A$1 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R1C1<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> Mutlak referans <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\">$A1 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R[-4]C1<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> G\u00f6reli sat\u0131r ve mutlak s\u00fctun <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\">1 Avustralya Dolar\u0131 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R1C[-1]<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> Mutlak sat\u0131r ve g\u00f6reli s\u00fctun<\/div><\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\"> <em>farkl\u0131 referans t\u00fcrleri<\/em><\/figcaption><\/figure><p> T\u0131pk\u0131 A1&#8217;de oldu\u011fu gibi R1C1&#8217;de de yukar\u0131daki tabloda g\u00f6sterildi\u011fi gibi d\u00f6rt farkl\u0131 referans tipi kullanabilirsiniz. Ancak \u015fimdi her bir referans t\u00fcr\u00fcn\u00fc daha derinlemesine inceleyelim.<\/p><h3 class=\"wp-block-heading\"> 1. G\u00f6receli R1C1 referans\u0131<\/h3><p> R1C1&#8217;de g\u00f6receli referans\u0131 kullanmak olduk\u00e7a basittir. Bu referans stilinde, bir h\u00fccreye referans verdi\u011finizde, referans verilen h\u00fccrenin adresini, aktif h\u00fccreye olan uzakl\u0131\u011f\u0131n\u0131 kullanarak olu\u015fturur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-une-reference-relative-dans-le-style-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1 tarz\u0131nda g\u00f6receli bir referans kullanma\"><\/figure><\/div><p> Aktif h\u00fccrenin sa\u011f taraf\u0131ndaki bir s\u00fctuna gitmek istiyorsan\u0131z say\u0131 pozitif olacakt\u0131r, sol tarafta ise negatif bir say\u0131 olacakt\u0131r. Ve \u00e7izgi i\u00e7in de ayn\u0131s\u0131, alttaki aktif \u00e7izgi i\u00e7in pozitif bir say\u0131 ve yukar\u0131daki aktif \u00e7izgi i\u00e7in negatif bir say\u0131. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-pour-le-style-de-reference-r1c1-relatif.gif\" sizes=\"\" srcset=\"\" alt=\"g\u00f6receli r1c1 referans stiline bir \u00f6rnek\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, h\u00fccrenin 1 s\u00fctun ilerisindeki bir h\u00fccreyi, 2 s\u00fctun ilerideki bir h\u00fccreyle \u00e7arpmak i\u00e7in g\u00f6receli ba\u015fvuruyu kulland\u0131k.<\/p><p> Bu form\u00fcl\u00fc kopyalay\u0131p \u00e7al\u0131\u015fma sayfan\u0131zdaki ba\u015fka bir h\u00fccreye yap\u0131\u015ft\u0131r\u0131rsan\u0131z, her zaman aktif h\u00fccrenin 1 s\u00fctun \u00f6n\u00fcndeki h\u00fccreyi 2 s\u00fctun \u00f6nceki h\u00fccreyle \u00e7arpacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 2. Mutlak referans R1C1<\/h3><p> Eminim yukar\u0131daki \u00f6rnekte \u015funu fark etmi\u015fsinizdir <strong>, sat\u0131r ve s\u00fctun numaralar\u0131nda parantez var<\/strong> . H\u00fccre referans\u0131nda parantez kullanmad\u0131\u011f\u0131n\u0131zda ne olaca\u011f\u0131n\u0131 size g\u00f6stereyim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-simple-pour-comprendre-la-reference-absolue-dans-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1'deki mutlak referans\u0131 anlamak i\u00e7in basit bir \u00f6rnek\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte 2. sat\u0131r ve 1. s\u00fctunu parantezsiz kulland\u0131\u011f\u0131n\u0131zda, <strong><span style=\"color: #ea493f;\">bahsetti\u011finiz h\u00fccrenin tam olarak 2. sat\u0131r ve 1. s\u00fctunda yer ald\u0131\u011f\u0131<\/span><\/strong> anlam\u0131na gelir.<\/p><p> Ger\u00e7ek \u015fu ki: R1C1&#8217;de mutlak referans\u0131 kullanmak istedi\u011finizde k\u00f6\u015feli parantezlerin kullan\u0131m\u0131n\u0131 g\u00f6z ard\u0131 edebilirsiniz ve Excel, R1C1 h\u00fccresini (A1 h\u00fccresi) ba\u015flang\u0131\u00e7 noktas\u0131 olarak ele al\u0131r.<\/p><p> Size bir \u00f6rnek g\u00f6stereyim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-de-style-de-reference-r1c1-relatif-dans-Excel.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de g\u00f6receli r1c1 referans stili \u00f6rne\u011fi\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte R1C1&#8217;in 2. sat\u0131r\u0131nda ve 3. s\u00fctununda yer alan R2C3 h\u00fccresini (A1 h\u00fccresi) aktif h\u00fccrenin 1 s\u00fctun \u00f6n\u00fcnde bulunan bir h\u00fccreyle \u00e7arpt\u0131k.<\/p><p> R2C3 parantezsizdir ve form\u00fcl\u00fc s\u00fcr\u00fckledi\u011fimizde <strong><span style=\"color: #ea493f;\">h\u00fccre referans\u0131 da onunla birlikte de\u011fi\u015fmez<\/span><\/strong> .<\/p><h3 class=\"wp-block-heading\"> 3. R1C1 yar\u0131 mutlak\/g\u00f6receli<\/h3><p> Bu, tek bir s\u00fctunu veya sat\u0131r\u0131, mutlak veya g\u00f6receli olarak olu\u015fturabilece\u011finiz en \u00e7ok kullan\u0131lan referans stillerinden biridir. Size bir \u00f6rnek g\u00f6stereyim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-une-reference-semi-absolue-et-relative-avec-r1c1.gif\" sizes=\"\" srcset=\"\" alt=\"r1c1 ile yar\u0131 mutlak ve ba\u011f\u0131l referans kullanma\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte ilk sat\u0131rdaki de\u011feri ilk s\u00fctundaki de\u011ferle \u00e7arp\u0131yoruz.<\/p><ul><li> <strong>RC1:<\/strong> Sat\u0131r numaras\u0131n\u0131 belirtmeyi g\u00f6z ard\u0131 etti\u011finizde Excel, etkin h\u00fccredeki sat\u0131r\u0131 referans olarak kabul eder. Yani burada s\u00fctun ayn\u0131 kalacak ancak form\u00fcl\u00fc t\u00fcm h\u00fccrelere s\u00fcr\u00fckledi\u011finizde sat\u0131r de\u011fi\u015fecek.<\/li><li> <strong>Cevap1C:<\/strong> S\u00fctun numaras\u0131n\u0131 belirtmeyi g\u00f6z ard\u0131 etti\u011finizde Excel, etkin h\u00fccrenin s\u00fctununu referans olarak kabul eder. Yani burada sat\u0131r ayn\u0131 kalacak ancak form\u00fcl\u00fc t\u00fcm h\u00fccrelere s\u00fcr\u00fckledi\u011finizde s\u00fctun de\u011fi\u015fecek.<\/li><\/ul><h2 class=\"wp-block-heading\"> Form\u00fcllerde R1C1 referans\u0131n\u0131 kullanma<\/h2><p> A1 stilinden R1C1 stiline ge\u00e7ti\u011finizde elektronik tablonuzdaki t\u00fcm form\u00fcllerin de\u011fi\u015fti\u011fini g\u00f6receksiniz.<\/p><p> Bunlar\u0131 ilk kez kafa kar\u0131\u015ft\u0131r\u0131c\u0131 buluyor olabilirsiniz, ancak ger\u00e7ekte olduk\u00e7a basittirler. Size basit bir toplam form\u00fcl\u00fcyle bu \u015feyin nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6stereyim.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte, sonunda toplam s\u00fctunu bulunan 10 \u00fcr\u00fcn\u00fcn ayl\u0131k sat\u0131\u015f\u0131n\u0131 g\u00f6steren bir veri tablomuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-table-de-donnees-avec-le-style-a1.png\" sizes=\"\" srcset=\"\" alt=\"a1 stiline sahip bir veri tablosu\"><\/figure><\/div><p> Ve burada A1 referans stilini kullan\u0131yorsunuz.<\/p><p> Bu referans stilinde, her toplam h\u00fccre, farkl\u0131 bir h\u00fccre referans\u0131 kullanan farkl\u0131 bir form\u00fcle sahiptir.<\/p><p> Ancak referans\u0131 A1&#8217;den R1C1&#8217;e de\u011fi\u015ftirdi\u011finizde t\u00fcm form\u00fcller de\u011fi\u015fmi\u015ftir ve her toplam h\u00fccrede ayn\u0131d\u0131r.<\/p><p> On h\u00fccrenin tamam\u0131nda a\u015fa\u011f\u0131daki form\u00fcle sahibiz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(RC[-12]:RC[-1])<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-table-de-donnees-avec-le-style-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1 stiline sahip bir veri tablosu\"><\/figure><\/div><p> <strong>Bu form\u00fcl \u015funu s\u00f6yl\u00fcyor: \u201cAyn\u0131 sat\u0131rdaki 12 s\u00fctun sola (C[\u201312]) h\u00fccresinden, bir s\u00fctun sola (C[\u20131]) h\u00fccreye kadar olan de\u011fer aral\u0131\u011f\u0131n\u0131 toplay\u0131n. ayn\u0131 sat\u0131r. astar .<\/strong> \u201c<\/p><p> \u00c7\u00fcnk\u00fc toplam\u0131 hesaplad\u0131\u011f\u0131m\u0131z t\u00fcm h\u00fccrelerde de\u011fer aral\u0131\u011f\u0131 ayn\u0131 s\u0131radad\u0131r ve bu nedenle t\u00fcm h\u00fccreler i\u00e7in ayn\u0131 form\u00fcle sahibiz.<\/p><p> <em><strong><a href=\"http:\/\/amzn.to\/2wEgOEe\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Yeni Ba\u015flayanlar \u0130\u00e7in Excel 2016 Hepsi Bir Arada<\/a> \u0130pucu<\/strong> : T\u00fcm form\u00fclleri bir \u00e7al\u0131\u015fma sayfas\u0131 tablosuna do\u011fru \u015fekilde kopyalad\u0131\u011f\u0131n\u0131z\u0131 do\u011frulamak i\u00e7in R1C1 g\u00f6sterimini kullanabilirsiniz. H\u00fccre imlecini tabloya kopyalanan form\u00fclleri i\u00e7eren t\u00fcm h\u00fccreler \u00fczerinde hareket ettirin. R1C1 g\u00f6sterimi etkin oldu\u011funda, orijinal form\u00fcl\u00fcn tablonun t\u00fcm sat\u0131r\u0131ndaki veya s\u00fctunundaki t\u00fcm kopyalar\u0131, h\u00fccrelerini etkinle\u015ftirdi\u011finizde <a href=\"https:\/\/exceladvisor.org\/tr\/excel-formul-cubugu\/\">form\u00fcl<\/a> \u00e7ubu\u011funda g\u00f6r\u00fcnt\u00fclendi\u011finde ayn\u0131 olmal\u0131d\u0131r.<\/em><\/p><h2 class=\"wp-block-heading\"> VBA&#8217;da R1C1 referans\u0131n\u0131 kullanma<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\" target=\"_blank\" rel=\"noreferrer noopener\">Bir makro kaydetti\u011finizde<\/a> Excel&#8217;in h\u00fccrelere ve aral\u0131klara ba\u015fvuruda bulunmak i\u00e7in R1C1 form\u00fcl\u00fcn\u00fc kulland\u0131\u011f\u0131n\u0131 g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-la-reference-r1c1-dans-vba.gif\" sizes=\"\" srcset=\"\" alt=\"vba'da r1c1 referans\u0131n\u0131 kullanma\"><\/figure><\/div><p> Ayr\u0131ca, R1C1 konseptini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 biliyorsan\u0131z kay\u0131tl\u0131 makro kodlar\u0131n\u0131 kolayca d\u00fczenleyebilir ve \u00e7ok fazla zaman kazanabilirsiniz. Bunu yapmak i\u00e7in FormulaR1C1 y\u00f6nteminin nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlaman\u0131z gerekir.<\/p><p> Aktif h\u00fccrenin solunda bulunan iki h\u00fccreyi \u00e7arpman\u0131z gereken aktif h\u00fccreye bir form\u00fcl girmek istedi\u011finizi varsayal\u0131m.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub R1C1Style() Selection.FormulaR1C1 = \"=RC[-2]*RC[-1]\" End Sub<\/code><\/pre><p> Aktif h\u00fccrenin bir s\u00fctun solundaki h\u00fccreyi, iki s\u00fctun solundaki h\u00fccreyle \u00e7arpars\u0131n\u0131z. \u015eimdi bunun en iyi k\u0131sm\u0131:<\/p><p> Tablonuzun konumunu de\u011fi\u015ftirdi\u011finizde ayn\u0131 \u015femada \u00e7al\u0131\u015facakt\u0131r, kodunuzda herhangi bir de\u011fi\u015fiklik yapman\u0131za gerek yoktur. Ancak burada R1C1 yerine A1 referans\u0131n\u0131 kullan\u0131rsak ne olur:<\/p><p> H\u00fccre referans\u0131 sabit olaca\u011f\u0131ndan bu kodu her h\u00fccre i\u00e7in kullanamay\u0131z ( <strong>aksi takdirde <a href=\"https:\/\/exceladvisor.org\/tr\/menzil-kaymasi\/\">Offset \u00f6zelli\u011fini kullanmam\u0131z gerekir<\/a><\/strong> ). <a href=\"https:\/\/powerspreadsheets.com\/r1c1-formular1c1-vba\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Jorge&#8217;nin k\u0131lavuzundan<\/a> Formula.R1C1 y\u00f6ntemi hakk\u0131nda daha fazla bilgi edinin.<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> R1C1&#8217;i anlad\u0131\u011f\u0131n\u0131zda biraz korku hissedeceksiniz, ancak bunun \u00fcstesinden geldi\u011finizde Excel&#8217;de \u00e7al\u0131\u015fmaya y\u00f6nelik yeni ve esnek bir yakla\u015f\u0131ma sahip olacaks\u0131n\u0131z.<\/p><p> Size s\u00f6ylemeyi unuttu\u011fum \u015fey, g\u00f6receli, mutlak ve yar\u0131 g\u00f6receli h\u00fccre referanslar\u0131 aras\u0131nda ge\u00e7i\u015f yapmak i\u00e7in F4&#8217;\u00fc kullanabilece\u011finizdir. \u0130\u015fte bu e\u011fitimde ele ald\u0131\u011f\u0131m\u0131z ve akl\u0131n\u0131zda bulundurman\u0131z gereken baz\u0131 noktalar.<\/p><ol><li> R1C1&#8217;de <a href=\"https:\/\/exceladvisor.org\/tr\/satir-ve-sutun\/\">R bir sat\u0131r\u0131, C ise bir s\u00fctunu temsil eder<\/a> .<\/li><li> Etkin h\u00fccrenin alt\u0131ndaki bir sat\u0131ra ve \u00f6n\u00fcndeki bir s\u00fctuna at\u0131fta bulunmak i\u00e7in pozitif bir say\u0131 kullanabilirsiniz.<\/li><li> Etkin h\u00fccrenin \u00fcst\u00fcndeki bir sat\u0131ra ve arkas\u0131ndaki bir s\u00fctuna at\u0131fta bulunmak i\u00e7in negatif bir say\u0131 kullanabilirsiniz.<\/li><li> Bir sat\u0131r veya s\u00fctun numaras\u0131n\u0131 k\u00f6\u015feli ayra\u00e7 olmadan kulland\u0131\u011f\u0131n\u0131zda, Excel bunu mutlak bir referans olarak de\u011ferlendirir.<\/li><li> VBA&#8217;da R1C1&#8217;i kullanmak i\u00e7in FormulaR1C1 y\u00f6ntemini kullanman\u0131z gerekir.<\/li><\/ol><p> Umar\u0131m bu makaleyi faydal\u0131 bulmu\u015fsunuzdur ve \u015fimdi bana bir \u015fey s\u00f6yleyin.<\/p><p> <em>R1C1 kullanmaya ba\u015flayacak m\u0131s\u0131n\u0131z?<\/em><\/p><p> D\u00fc\u015f\u00fcncelerinizi yorum k\u0131sm\u0131nda benimle payla\u015fmay\u0131 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-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/referans-3d\/\">Excel&#8217;de 3 boyutlu referans<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\">Excel&#8217;de joker karakterler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/formulu-gizle\/\">Excel&#8217;de form\u00fcl\u00fc gizle<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1513","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Excel&#039;de R1C1 referans stili nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"R1C1 referans stili ilk olarak Microsoft&#039;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#039;da tan\u0131t\u0131ld\u0131.\" \/>\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\/r1c1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de R1C1 referans stili nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"R1C1 referans stili ilk olarak Microsoft&#039;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#039;da tan\u0131t\u0131ld\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/r1c1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.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=\"10 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/\",\"name\":\"\u25b7 Excel&#39;de R1C1 referans stili nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\",\"datePublished\":\"2023-11-18T17:51:00+00:00\",\"dateModified\":\"2023-12-10T06:02:04+00:00\",\"description\":\"R1C1 referans stili ilk olarak Microsoft&#39;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#39;da tan\u0131t\u0131ld\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/r1c1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/r1c1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de r1c1 referans stili nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Excel&#39;de R1C1 referans stili nas\u0131l kullan\u0131l\u0131r?","description":"R1C1 referans stili ilk olarak Microsoft&#39;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#39;da tan\u0131t\u0131ld\u0131.","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\/r1c1\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de R1C1 referans stili nas\u0131l kullan\u0131l\u0131r?","og_description":"R1C1 referans stili ilk olarak Microsoft&#39;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#39;da tan\u0131t\u0131ld\u0131.","og_url":"https:\/\/exceladvisor.org\/tr\/r1c1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"10 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/r1c1\/","url":"https:\/\/exceladvisor.org\/tr\/r1c1\/","name":"\u25b7 Excel&#39;de R1C1 referans stili nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/r1c1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/r1c1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png","datePublished":"2023-11-18T17:51:00+00:00","dateModified":"2023-12-10T06:02:04+00:00","description":"R1C1 referans stili ilk olarak Microsoft&#39;un Apple Macintosh i\u00e7in geli\u015ftirdi\u011fi Multiplan&#39;da tan\u0131t\u0131ld\u0131.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/r1c1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/r1c1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/r1c1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/r1c1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de r1c1 referans stili nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/1513","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=1513"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1513\/revisions"}],"predecessor-version":[{"id":2575,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1513\/revisions\/2575"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}