{"id":38146,"date":"2026-08-27T08:01:05","date_gmt":"2026-08-27T07:01:05","guid":{"rendered":"https:\/\/keyfy.com\/blog\/excelde-sutunlari-carpma-4-yontem\/"},"modified":"2026-08-27T08:01:05","modified_gmt":"2026-08-27T07:01:05","slug":"excelde-sutunlari-carpma-4-yontem","status":"publish","type":"post","link":"https:\/\/keyfy.com\/tr\/blog\/excelde-sutunlari-carpma-4-yontem\/","title":{"rendered":"Excel\u2019de S\u00fctunlar\u0131 \u00c7arpma: 4 Y\u00f6ntem"},"content":{"rendered":"

A s\u00fctununda miktarlar, B s\u00fctununda birim fiyatlar bulunan bir elektronik tablo d\u00fc\u015f\u00fcn\u00fcn. C s\u00fctununu toplamlarla doldurmak basit bir i\u015f gibi g\u00f6r\u00fcnebilir. Excel\u2019de s\u00fctunlar\u0131 nas\u0131l \u00e7arpaca\u011f\u0131n\u0131z\u0131<\/strong> ar\u0131yorsan\u0131z, genellikle tamamlamaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z i\u015f budur. \u0130lk h\u00fccreye bir form\u00fcl yazars\u0131n\u0131z, a\u015fa\u011f\u0131 do\u011fru s\u00fcr\u00fckler ve say\u0131lar\u0131n yar\u0131s\u0131 yanl\u0131\u015f \u00e7\u0131kar. \u0130kinci sat\u0131r gayet iyi g\u00f6r\u00fcn\u00fcr. \u00dc\u00e7\u00fcnc\u00fc sat\u0131r anlams\u0131zd\u0131r ve yirminci sat\u0131ra gelindi\u011finde t\u00fcm s\u00fctun sessizce da\u011f\u0131l\u0131vermi\u015ftir. <\/p>\n

\u00c7o\u011fu ki\u015fi bu durumda kendini su\u00e7lar. Sonu\u00e7ta form\u00fcl do\u011fruydu. Asl\u0131nda sorun, bir form\u00fcl\u00fc kopyalad\u0131\u011f\u0131n\u0131zda Excel\u2019in kendi kendine yapt\u0131\u011f\u0131 bir i\u015flemden kaynaklan\u0131yor ve bu konuyu, sorunla kar\u015f\u0131la\u015fmadan \u00f6nce neredeyse hi\u00e7 kimse a\u00e7\u0131klam\u0131yor. <\/p>\n

\u0130\u015fte bu tek davran\u0131\u015f \u2013 mutlak referanslar<\/strong> ile g\u00f6receli referanslar<\/strong> aras\u0131ndaki fark \u2013 \u00e7al\u0131\u015fan bir \u00e7arpma form\u00fcl\u00fcn\u00fcn s\u00fctunun ortas\u0131nda birdenbire i\u015flevini yitirmesinin sebebidir. Bu k\u0131lavuz, s\u00fctunlar\u0131 \u00e7arpman\u0131n d\u00f6rt ger\u00e7ek y\u00f6ntemini ad\u0131m ad\u0131m anlat\u0131r ve her birinin tam olarak hangi noktada ba\u015far\u0131s\u0131zl\u0131\u011fa u\u011frad\u0131\u011f\u0131n\u0131 g\u00f6sterir; b\u00f6ylece hata yay\u0131lmadan \u00f6nce bunu fark edebilirsiniz. <\/p>\n

\n
H\u0131zl\u0131 \u00d6zet \u2013 TLDR<\/div>\n
Excel\u2019de iki s\u00fctunu \u00e7arpmak, bir y\u00f6ntem se\u00e7mek ve bu y\u00f6ntemin ne zaman i\u015fe yaramad\u0131\u011f\u0131n\u0131 bilmekle ilgilidir. Y\u0131ld\u0131z i\u015fareti form\u00fcl\u00fc ve a\u015fa\u011f\u0131 doldurma \u00e7o\u011fu durumu halleder, PRODUCT i\u015flevi \u00e7ok say\u0131da h\u00fccre i\u00e7in daha temiz bir \u00e7\u00f6z\u00fcm sunar ve \u00d6zel Yap\u0131\u015ft\u0131rma \u2013 \u00c7arpma se\u00e7ene\u011fi de\u011ferleri yerinde de\u011fi\u015ftirir. Neredeyse herkesin tak\u0131ld\u0131\u011f\u0131 nokta ise dolar i\u015faretidir: $<\/code> ile kilitlemeden tek bir sabit h\u00fccreyle \u00e7arpma i\u015flemi yaparsan\u0131z, referans s\u00fctun boyunca a\u015fa\u011f\u0131 kayar ve ilk sat\u0131rdan sonraki t\u00fcm sat\u0131rlarda hata olu\u015fur. <\/div>\n<\/div>\n

Geleneksel tavsiyelerin sessizce i\u015fe yaramad\u0131\u011f\u0131 durumlar<\/h2>\n

Bu konuyu arat\u0131rsan\u0131z d\u00fczenli bir listeyle kar\u015f\u0131la\u015facaks\u0131n\u0131z. \u201c =A2*B2<\/code> \u201d yaz\u0131n, k\u00f6\u015feyi s\u00fcr\u00fckleyin, i\u015fte bu kadar. PRODUCT komutunu kullan\u0131n. \u201c\u00d6zel Yap\u0131\u015ft\u0131r\u201d se\u00e7ene\u011fini deneyin. Hepsi do\u011fru, hepsi eksik. <\/p>\n

Sorun, bir form\u00fcl\u00fc a\u015fa\u011f\u0131ya do\u011fru kopyalad\u0131\u011f\u0131n\u0131zda ortaya \u00e7\u0131kan durumla ilgilidir. Excel, varsay\u0131lan olarak h\u00fccre referanslar\u0131n\u0131 g\u00f6receli olarak de\u011ferlendirir; yani her yeni sat\u0131ra uyacak \u015fekilde bunlar\u0131 kayd\u0131r\u0131r. Yan yana duran iki s\u00fctunu \u00e7arparken genellikle istedi\u011finiz de budur, \u00e7\u00fcnk\u00fc 3. sat\u0131rda 2. sat\u0131r\u0131n de\u011ferleri de\u011fil, 3. sat\u0131r\u0131n de\u011ferleri kullan\u0131lmal\u0131d\u0131r. <\/p>\n

Ancak \u00e7arpma i\u015fleminin bir taraf\u0131nda tek bir h\u00fccre oldu\u011funda \u2013 bir vergi oran\u0131, bir d\u00f6n\u00fc\u015ft\u00fcrme fakt\u00f6r\u00fc, sabit bir fiyat gibi \u2013 bu otomatik kayd\u0131rma bir hataya d\u00f6n\u00fc\u015f\u00fcr. 2. sat\u0131rdaki form\u00fcl\u00fcn\u00fcz oran h\u00fccresini i\u015faret ediyor. 3. sat\u0131ra kopyaland\u0131\u011f\u0131nda ise bir h\u00fccre a\u015fa\u011f\u0131ya, muhtemelen bo\u015f olan bir h\u00fccreye i\u015faret eder. Excel, s\u0131f\u0131rla \u00e7arpma i\u015flemi yapt\u0131\u011f\u0131nda sonu\u00e7 olarak s\u0131f\u0131r veya bir hata verir. <\/p>\n

K\u0131lavuzlarda y\u00f6ntemler s\u0131ralan\u0131yor ama bundan hi\u00e7 bahsedilmiyor. Dolay\u0131s\u0131yla okuyucu her \u015feyi \u201cdo\u011fru\u201d yap\u0131yor, s\u00fctunun \u00e7\u00f6kt\u00fc\u011f\u00fcn\u00fc g\u00f6r\u00fcyor ve d\u00f6rt ad\u0131mdan hangisinin buna neden oldu\u011funu hi\u00e7 bilemiyor. \u00c7\u00f6z\u00fcm tek bir karakterden ibaret. Sadece nereye yaz\u0131laca\u011f\u0131n\u0131 bilmeniz yeterli. <\/p>\n

Excel\u2019de s\u00fctunlar\u0131 nas\u0131l \u00e7arp\u0131l\u0131r: Ger\u00e7ekten i\u015fe yarayan d\u00f6rt y\u00f6ntem<\/h2>\n

En s\u0131k ba\u015fvuraca\u011f\u0131n\u0131z yakla\u015f\u0131mdan ba\u015flayarak, her bir yakla\u015f\u0131m\u0131 tek tek inceleyelim.<\/p>\n

Y\u00f6ntem 1: Y\u0131ld\u0131z i\u015fareti form\u00fcl\u00fc.<\/strong> Excel\u2019de ayr\u0131 bir \u00e7arpma d\u00fc\u011fmesi bulunmad\u0131\u011f\u0131ndan, \u00e7arpma i\u015flemi y\u0131ld\u0131z i\u015fareti kullan\u0131larak ger\u00e7ekle\u015ftirilir. \u0130ki s\u00fctunu Excel tarz\u0131nda \u00e7arpmak i\u00e7in, sonu\u00e7 s\u00fctunundaki ilk bo\u015f h\u00fccreye t\u0131klay\u0131n ve \u015funu yaz\u0131n: <\/p>\n

=A2*B2\n<\/code><\/pre>\n
Enter tu\u015funa bas\u0131n. Bu h\u00fccre art\u0131k A2 ile B2\u2019nin \u00e7arp\u0131m\u0131n\u0131 i\u00e7eriyor. Bu, bundan sonra anlat\u0131lacak hemen hemen her y\u00f6ntemin temelini olu\u015fturur ve Microsoft\u2019un kendi destek sayfalar\u0131nda da bir say\u0131 s\u00fctununu \u00e7arpmak<\/a> i\u00e7in varsay\u0131lan temel bile\u015fen olarak ele al\u0131n\u0131r.  <\/p>\n
Y\u00f6ntem 2: A\u015fa\u011f\u0131 do\u011fru doldurma.<\/strong>  Tek bir form\u00fcl, bir s\u00fctun say\u0131lmaz. Bir s\u00fctunun tamam\u0131n\u0131 \u00e7arpmak i\u00e7in Excel\u2019de bu form\u00fcl\u00fcn her sat\u0131ra tekrarlanmas\u0131 gerekir ve bunu elle s\u00fcr\u00fckleyerek yapmak \u00e7ok \u00e7abuk s\u0131k\u0131c\u0131 hale gelir. <\/p>\n
Form\u00fcl\u00fcn\u00fcz\u00fcn bulundu\u011fu h\u00fccreyi se\u00e7in. Sa\u011f alt k\u00f6\u015fedeki k\u00fc\u00e7\u00fck kareyi g\u00f6r\u00fcyor musunuz? O, doldurma tutama\u011f\u0131d\u0131r<\/strong>. Buna \u00e7ift t\u0131klay\u0131n; Excel, form\u00fcl\u00fc biti\u015fik verilerinizin uzand\u0131\u011f\u0131 kadar a\u015fa\u011f\u0131ya kopyalar. Daha fazla kontrol istiyorsan\u0131z, elle s\u00fcr\u00fckleyin. Her iki durumda da Excel, sat\u0131r ba\u015f\u0131na referanslar\u0131 ayarlar; b\u00f6ylece =A2*B2<\/code>, =A3*B3<\/code>, ard\u0131ndan =A4*B4<\/code> ve a\u015fa\u011f\u0131ya do\u011fru devam eder. DataCamp\u2019\u0131n h\u00fccreleri ve s\u00fctunlar\u0131 \u00e7arpma konusundaki<\/a> \u00f6\u011freticisinde de belirtildi\u011fi gibi, bu, e\u015fle\u015fen iki s\u00fctun i\u00e7in en h\u0131zl\u0131 yoldur.      <\/p>\n
\n
\u0130PUCU<\/div>\n
Y\u00f6ntem 3: PRODUCT i\u015flevi.<\/strong>  \u0130ki de\u011ferden fazlas\u0131n\u0131 \u00e7arparken ya da sadece daha sade bir s\u00f6zdizimini tercih ediyorsan\u0131z, Excel\u2019in sundu\u011fu \u00e7arp\u0131m form\u00fcl\u00fcn\u00fc \u00f6\u011frenmenizde fayda var:<\/div>\n<\/div>\n
=PRODUCT(A2,B2)\n<\/code><\/pre>\n
Ya da bir aral\u0131k boyunca:<\/p>\n
=PRODUCT(A2:D2)\n<\/code><\/pre>\n
PRODUCT i\u015flevi, kendisine girilen t\u00fcm de\u011ferleri \u00e7arpar. Bir sat\u0131rda d\u00f6rt veya be\u015f \u00e7arpan oldu\u011funda ve y\u0131ld\u0131z i\u015faretlerini zincirleme kullanmak istemedi\u011finizde bu i\u015flev \u00e7ok kullan\u0131\u015fl\u0131d\u0131r. Ayr\u0131ca, hata vermeden bo\u015f h\u00fccreleri ve metinleri g\u00f6z ard\u0131 eder; oysa basit y\u0131ld\u0131z i\u015fareti her zaman b\u00f6yle davranmaz. Di\u011fer form\u00fcllerle ayn\u0131 \u015fekilde a\u015fa\u011f\u0131ya do\u011fru doldurun.   <\/p>\n
Y\u00f6ntem 4: \u00d6zel Yap\u0131\u015ft\u0131rma\u2019y\u0131 birden fazla kez uygulamak.<\/strong>  \u0130lk \u00fc\u00e7\u00fc sonu\u00e7lar\u0131 yeni bir s\u00fctuna yazar. \u00d6zel Yap\u0131\u015ft\u0131r ise farkl\u0131d\u0131r \u2014 mevcut say\u0131lar\u0131 olduklar\u0131 yerde de\u011fi\u015ftirir, \u00fc\u00e7\u00fcnc\u00fc bir s\u00fctuna gerek yoktur. <\/p>\n
Diyelim ki A s\u00fctununda fiyatlar yer al\u0131yor ve her birine sabit bir katsay\u0131 \u00e7arpmak istiyorsunuz. Bu katsay\u0131y\u0131 bo\u015f bir h\u00fccreye yaz\u0131n, kopyalay\u0131n, fiyat s\u00fctununu se\u00e7in, ard\u0131ndan \u00d6zel Yap\u0131\u015ft\u0131r (Ctrl+Alt+V) se\u00e7ene\u011fini a\u00e7\u0131n, \u0130\u015flemler alt\u0131ndan \u00c7arpma\u2019y\u0131 se\u00e7in ve Tamam\u2019a t\u0131klay\u0131n. Excel, se\u00e7ilen her h\u00fccreyi kopyalanan de\u011ferle \u00e7arpar ve \u00fczerine yazar. How-To Geek\u2019in Excel\u2019de s\u00fctunlar\u0131 \u00e7arpma<\/a> konusundaki ad\u0131m ad\u0131m k\u0131lavuzu bu i\u015flemi ayr\u0131nt\u0131l\u0131 bir \u015fekilde ele almaktad\u0131r.   <\/p>\n
Ancak i\u015fin p\u00fcf noktas\u0131 \u015fu: \u201c\u00d6zel Yap\u0131\u015ft\u0131r\u201d i\u015flemi verileri siler.<\/strong> Form\u00fcl kalmaz; dolay\u0131s\u0131yla, fakt\u00f6rler daha sonra de\u011fi\u015firse her \u015feyi ba\u015ftan yapman\u0131z gerekir. Bu \u00f6zelli\u011fi, tek seferlik ayarlamalar i\u00e7in kullan\u0131n; s\u00fcrekli g\u00fcncellenen hesap tablolar\u0131 i\u00e7in de\u011fil. <\/p>\n
Dolar i\u015fareti sorunu, do\u011fru bir \u015fekilde a\u00e7\u0131klanm\u0131\u015f<\/h2>\n
Bu, di\u011fer k\u0131lavuzlar\u0131n atlad\u0131\u011f\u0131 k\u0131s\u0131md\u0131r ve s\u00fctununuzun k\u0131r\u0131lmas\u0131n\u0131n tek nedeni budur.<\/p>\n
Bir s\u00fctunu sabit bir say\u0131 ile \u00e7arpmak istiyorsunuz; \u00f6rne\u011fin, E1 h\u00fccresinde bulunan bir vergi oran\u0131yla. \u201c =A2*E1<\/code> \u201d yazd\u0131\u011f\u0131n\u0131zda do\u011fru sonucu al\u0131yorsunuz ve a\u015fa\u011f\u0131ya do\u011fru dolduruyorsunuz. 2. sat\u0131r do\u011fru. Onun alt\u0131ndaki her \u015fey yanl\u0131\u015f.   <\/p>\n
Excel\u2019in ne yapt\u0131\u011f\u0131n\u0131 izleyin. 3. sat\u0131rda form\u00fcl\u00fcn\u00fcz fark edilmeden =A3*E2<\/code> \u015feklinde de\u011fi\u015fiyor. A3 k\u0131sm\u0131 sorun de\u011fil \u2014 bu, beklendi\u011fi gibi \u00e7al\u0131\u015fan g\u00f6receli kayd\u0131rma i\u015flemidir. Ancak E1 de E2\u2019ye kaym\u0131\u015f ve bu h\u00fccre bo\u015f. 4. sat\u0131rda ise E3 kullan\u0131l\u0131yor. Art\u0131k her sat\u0131r bo\u015f bir h\u00fccreyle \u00e7arp\u0131l\u0131yor.     <\/p>\n
Form\u00fcl nereye kopyalan\u0131rsa kopyalans\u0131n, oran h\u00fccresine yap\u0131lan referans\u0131n yerinde kalmas\u0131 gerekir. Dolar i\u015faretinin g\u00f6revi budur. Kilitleme i\u015flemi \u015fu \u015fekilde yap\u0131l\u0131r:  <\/p>\n
=A2*$E$1\n<\/code><\/pre>\n
S\u00fctun harfinin \u00f6n\u00fcndeki \u201c $<\/code> \u201d (S\u00fctun kilidi) i\u015fareti, s\u00fctunu sabitler. Sat\u0131r numaras\u0131n\u0131n \u00f6n\u00fcndeki \u201c $<\/code> \u201d (Sat\u0131r kilidi) i\u015fareti ise sat\u0131r\u0131 sabitler. \u201c $E$1<\/code> \u201d (S\u00fctun kilidi) se\u00e7ene\u011fiyle Excel, her sat\u0131rda E1 h\u00fccresini i\u015faret etmeye devam ederken, A2 h\u00fccresi A3, A4 ve a\u015fa\u011f\u0131 do\u011fru kaymaya devam eder. Bir k\u0131sm\u0131 hareketli, bir k\u0131sm\u0131 sabit \u2013 i\u015fte sabit \u00e7arpanl\u0131 bir s\u00fctunun tam da ihtiyac\u0131 olan budur.   <\/p>\n
\n
UYARI<\/div>\n
Ablebits, Excel\u2019de s\u00fctunlar\u0131 \u00e7arpma konusunda<\/a> haz\u0131rlad\u0131\u011f\u0131 k\u0131lavuzunda bu referans davran\u0131\u015f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 bir \u015fekilde ele almaktad\u0131r ve a\u00e7\u0131k\u00e7as\u0131, bu, kopyaland\u0131\u011f\u0131nda da \u00e7al\u0131\u015fmaya devam eden bir form\u00fcl ile sessizce bozulup giden bir form\u00fcl aras\u0131ndaki en b\u00fcy\u00fck farkt\u0131r.<\/div>\n<\/div>\n
Ezberlemeye de\u011fer bir k\u0131sayol: Form\u00fcl \u00e7ubu\u011fundaki h\u00fccre referans\u0131na t\u0131klay\u0131n ve F4 tu\u015funa bas\u0131n. Excel, kilitleme se\u00e7enekleri aras\u0131nda s\u0131rayla ge\u00e7i\u015f yapar \u2014 E1<\/code>, $E$1<\/code>, E$1<\/code>, $E1<\/code> \u2014 b\u00f6ylece dolar i\u015faretlerini asla elle yazmak zorunda kalmazs\u0131n\u0131z. <\/p>\n
Hangi i\u015f i\u00e7in hangi y\u00f6ntem<\/h2>\n
\n\n\n\n\n\n\n\n\n
Y\u00f6ntem<\/th>\nEn uygun oldu\u011fu durum<\/th>\nNerede bozulur<\/th>\n<\/tr>\n<\/thead>\n
=A2*B2<\/code> y\u0131ld\u0131z i\u015fareti<\/td>\n\u0130ki s\u00fctun, sat\u0131r sat\u0131r<\/td>\nMetin hatalar\u0131 veya bo\u015fluklar<\/td>\n<\/tr>\n
A\u015fa\u011f\u0131ya do\u011fru doldur<\/td>\nBir form\u00fcl\u00fc t\u00fcm s\u00fctuna uygulama<\/td>\nSabit bir h\u00fccre kilitlenmemi\u015fse yanl\u0131\u015f sonu\u00e7lar elde edilir<\/td>\n<\/tr>\n
\u00dcR\u00dcN<\/td>\nSat\u0131r ba\u015f\u0131na \u00fc\u00e7 veya daha fazla fakt\u00f6r<\/td>\nBasit bir iki s\u00fctunlu \u00e7arpma i\u015flemi i\u00e7in a\u015f\u0131r\u0131 g\u00fc\u00e7<\/td>\n<\/tr>\n
\u00d6zel Yap\u0131\u015ft\u0131r<\/td>\nTek seferlik toplu ayarlama<\/td>\nKal\u0131c\u0131, form\u00fcl b\u0131rakmaz<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\u0130ki e\u015fle\u015fen s\u00fctun, miktar \u00e7arp\u0131 fiyat m\u0131? Asterisk form\u00fcl\u00fc, a\u015fa\u011f\u0131ya do\u011fru doldur. Tek bir sabit h\u00fccreyle \u00e7arpma m\u0131? Ayn\u0131 yakla\u015f\u0131m, ancak \u00f6nce o h\u00fccreyi $<\/code> ile kilitleyin. Sat\u0131r ba\u015f\u0131na birka\u00e7 fakt\u00f6r varsa bu \u00dcR\u00dcN anlam\u0131na gelir. Ve bir daha asla tekrar etmeyece\u011finiz tek seferlik bir fiyat art\u0131\u015f\u0131 ise \u00d6zel Yap\u0131\u015ft\u0131rma i\u015flemiyle halledilir.     <\/p>\n
S\u0131k kar\u015f\u0131la\u015f\u0131lan ar\u0131zalar\u0131n giderilmesi<\/h2>\n
Baz\u0131 hatalar tekrar tekrar ortaya \u00e7\u0131k\u0131yor.<\/p>\n
#VALUE! hatalar\u0131<\/strong>, neredeyse her zaman h\u00fccrelerinizden birinde metin ya da metin olarak kaydedilmi\u015f ve i\u00e7inde gereksiz bo\u015fluk veya para birimi sembol\u00fc bulunan bir say\u0131 oldu\u011fu anlam\u0131na gelir. Kaynak h\u00fccreyi temizleyin ya da say\u0131sal olmayan girdileri hata vermeden atlayan PRODUCT i\u015flevine ge\u00e7in. <\/p>\n
Say\u0131 bekledi\u011finiz yerlerdeki s\u0131f\u0131rlar<\/strong>, do\u011frudan dolar i\u015fareti sorununa i\u015faret ediyor. Bozuk bir sat\u0131r\u0131n form\u00fcl\u00fcne t\u0131klay\u0131n ve sabit referans\u0131n\u0131z\u0131n kay\u0131p kaymad\u0131\u011f\u0131n\u0131 kontrol edin. E\u011fer $E$1<\/code> bir yerde E2<\/code> \u2019ye d\u00f6n\u00fc\u015fm\u00fc\u015fse, bunu kilitlemeden a\u015fa\u011f\u0131ya do\u011fru doldurmu\u015fsunuz demektir.  <\/p>\n
Sonu\u00e7lar\u0131n g\u00fcncellenmemesi<\/strong> genellikle hesaplaman\u0131n manuel moda ge\u00e7ti\u011fi anlam\u0131na gelir. \u201cForm\u00fcller\u201de, ard\u0131ndan \u201cHesaplama Se\u00e7enekleri\u201dne gidin ve ayar\u0131 tekrar \u201cOtomatik\u201d olarak belirleyin. Nadiren de olsa, ba\u015fkalar\u0131ndan gelen dosyalar\u0131 a\u00e7t\u0131ktan sonra bu durum ortaya \u00e7\u0131kabilir.  <\/p>\n
Form\u00fcllerin metin olarak g\u00f6r\u00fcnt\u00fclenmesi<\/strong>, h\u00fccre bi\u00e7iminin \u201cMetin\u201d olarak ayarland\u0131\u011f\u0131 anlam\u0131na gelir; bu nedenle Excel, \u201c =A2*B2<\/code> \u201d ifadesini aynen bir metin dizesi olarak okur. Bi\u00e7imi \u201cGenel\u201d veya \u201cSay\u0131\u201d olarak de\u011fi\u015ftirin, ard\u0131ndan form\u00fcl\u00fc yeniden girin. <\/p>\n
Daha fazla \u00f6rnek g\u00f6rmek isterseniz, GeeksforGeeks\u2019in say\u0131lar\u0131, h\u00fccreleri ve s\u00fctunlar\u0131 \u00e7arpma<\/a> konusundaki yaz\u0131s\u0131nda bu istisnai durumlara ili\u015fkin kapsaml\u0131 bir \u00f6zet yer almaktad\u0131r.<\/p>\n
S\u0131k Sorulan Sorular<\/h2>\n
Form\u00fcl\u00fcm neden ilk sat\u0131rda \u00e7al\u0131\u015f\u0131yor da, onun alt\u0131ndaki sat\u0131rlarda \u00e7al\u0131\u015fm\u0131yor?<\/strong>
\nKilitlenmemi\u015f sabit bir h\u00fccreyle \u00e7arpma i\u015flemi yap\u0131yorsunuz. Excel, doldurma i\u015flemi s\u0131ras\u0131nda referans\u0131 a\u015fa\u011f\u0131 do\u011fru kayd\u0131rd\u0131\u011f\u0131 i\u00e7in, birinci sat\u0131rdan sonra do\u011fru h\u00fccreye i\u015faret etmeyi b\u0131rak\u0131r. Dolar i\u015faretleri ekleyin: $E$1<\/code>, ard\u0131ndan yeniden doldurun.  <\/p>\n
 =A2*B2<\/code> ile =PRODUCT(A2,B2)<\/code> aras\u0131ndaki fark nedir?<\/strong>
\n\u0130ki h\u00fccre s\u00f6z konusu oldu\u011funda hi\u00e7bir fark<\/strong> yoktur; her ikisi de ayn\u0131 sonucu verir. PRODUCT i\u015flevi, birka\u00e7 \u00e7arpan veya bir aral\u0131k oldu\u011funda ger\u00e7ek de\u011ferini g\u00f6sterir ve hata vermek yerine bo\u015f ve metin i\u00e7eren h\u00fccreleri nazik\u00e7e g\u00f6z ard\u0131 eder. <\/p>\n
S\u00fcr\u00fcklemeden bir s\u00fctunun tamam\u0131n\u0131 nas\u0131l \u00e7arpabilirim?<\/strong>
\nForm\u00fcl\u00fcn\u00fcz\u00fc ilk h\u00fccreye girin, ard\u0131ndan h\u00fccrenin sa\u011f alt k\u00f6\u015fesindeki doldurma tutamac\u0131na \u00e7ift t\u0131klay\u0131n. Excel, verilerinizin uzunlu\u011funa uyacak \u015fekilde form\u00fcl\u00fc otomatik olarak a\u015fa\u011f\u0131ya kopyalar. <\/p>\n
\u00dc\u00e7\u00fcnc\u00fc bir s\u00fctun olu\u015fturmadan iki s\u00fctunu \u00e7arpabilir miyim?<\/strong>
\nEvet, \u201c\u00d6zel Yap\u0131\u015ft\u0131r\u201d se\u00e7ene\u011finin \u201c\u00c7arpma\u201d i\u015fleviyle bu m\u00fcmk\u00fcn; ancak bu i\u015flem orijinal say\u0131lar\u0131n\u0131z\u0131 \u00fczerine yazar ve geride hi\u00e7bir form\u00fcl b\u0131rakmaz. Tek seferlik bir de\u011fi\u015fiklik i\u00e7in uygun, ancak daha sonra d\u00fczenleyece\u011finiz herhangi bir \u015fey i\u00e7in risklidir. <\/p>\n
F4, form\u00fclde ne i\u015fe yarar?<\/strong>
\nBu i\u015flev, h\u00fccre referans\u0131n\u0131 g\u00f6receli ve mutlak aras\u0131nda de\u011fi\u015ftirir. Form\u00fcl \u00e7ubu\u011fundaki bir h\u00fccre referans\u0131na t\u0131klay\u0131n, F4 tu\u015funa bas\u0131n; Excel, s\u0131ras\u0131yla E1<\/code>, $E$1<\/code>, E$1<\/code> ve $E1<\/code> se\u00e7enekleri aras\u0131nda ge\u00e7i\u015f yapar ve dolar i\u015faretlerini elle yazma zahmetinden sizi kurtar\u0131r. <\/p>\n
K\u0131sa \u00f6zet<\/h2>\n
D\u00f6rt y\u00f6ntem, tek bir tekrarlanan tuzak. Y\u0131ld\u0131z i\u015fareti form\u00fcl\u00fc ve a\u015fa\u011f\u0131 do\u011fru doldurma, s\u00fctun \u00e7arp\u0131mlar\u0131n\u0131n \u00e7o\u011funu halleder; PRODUCT i\u015flevi \u00e7ok fakt\u00f6rl\u00fc sat\u0131rlar\u0131 d\u00fczene sokar ve \u00d6zel Yap\u0131\u015ft\u0131r se\u00e7ene\u011fi de\u011ferleri yerinde ayarlar. \u0130\u015fte form\u00fcl\u00fcn yar\u0131da bozulmas\u0131na izin vermeden Excel\u2019de s\u00fctunlar\u0131 \u00e7arpmak i\u00e7in izlenecek yol budur. Denklemin bir taraf\u0131 tek bir sabit h\u00fccra ise, form\u00fcl\u00fc a\u015fa\u011f\u0131ya kopyalamadan \u00f6nce \u201d $<\/code> \u201d ile kilitleyin. Bu tek karakter, d\u00fczg\u00fcn \u00e7al\u0131\u015fan bir s\u00fctun ile ikinci sat\u0131rda bozulan bir s\u00fctun aras\u0131ndaki tek farkt\u0131r.    <\/p>\n
Excel\u2019in d\u00fczg\u00fcn \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flamak i\u00e7in \u00f6ncelikle Office\u2019in orijinal ve etkinle\u015ftirilmi\u015f bir kopyas\u0131na sahip olmak gerekir; b\u00f6ylece rahats\u0131z edici uyar\u0131 \u00e7ubuklar\u0131 ve \u00f6zellik k\u0131s\u0131tlamalar\u0131 olmaz.<\/p>\n
\n
\ud83d\ude80 B\u00fcy\u00fcmenizi H\u0131zland\u0131r\u0131n<\/div>\n
Excel\u2019i Orijinal Office Lisans\u0131 ile \u00c7al\u0131\u015ft\u0131r\u0131n<\/div>\n
Aktivasyonla ilgili s\u0131k\u0131nt\u0131lardan kurtulun ve e-posta kutunuza g\u00f6nderilen do\u011frulanm\u0131\u015f bir anahtarla program\u0131n t\u00fcm \u00f6zelliklerinden yararlan\u0131n.<\/div>\n
Microsoft Office\u2019i edinin \u2192<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Excel\u2019de d\u00f6rt farkl\u0131 y\u00f6ntemle s\u00fctunlar\u0131 nas\u0131l \u00e7arpaca\u011f\u0131n\u0131z\u0131 ve form\u00fcllerin neden s\u00fctunun ortas\u0131nda kesildi\u011fini \u00f6\u011frenin. \u00c7\u00f6z\u00fcm tek bir karakterden ibarettir: sabit referanslar\u0131 kilitlemek i\u00e7in bir dolar i\u015fareti. <\/p>\n","protected":false},"author":1483,"featured_media":38148,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[371,326],"tags":[],"class_list":["post-38146","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kilavuzlar","category-ofis"],"acf":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/keyfy.com\/wp-content\/uploads\/2026\/08\/magnific_realistic-closeup-photo-o_u5r3aggQLD.webp","_links":{"self":[{"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/posts\/38146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/users\/1483"}],"replies":[{"embeddable":true,"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/comments?post=38146"}],"version-history":[{"count":0,"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/posts\/38146\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/media\/38148"}],"wp:attachment":[{"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/media?parent=38146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/categories?post=38146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/keyfy.com\/tr\/wp-json\/wp\/v2\/tags?post=38146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}