{"id":15634,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/sayfa\/"},"modified":"2021-02-25T16:35:47","modified_gmt":"2021-02-25T16:35:47","slug":"sheet","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sheet\/","title":{"rendered":"SAYFA"},"content":{"rendered":"

SAYFA \u0130\u015flevinin Temelleri<\/h2>\n

Hem MS Excel hem de Google E-Tablolar, \u00e7e\u015fitli fonksiyonlar sunarak veri y\u00f6netimini ve analizini kolayla\u015ft\u0131r\u0131r. Bu fonksiyonlardan biri de SAYFA<\/code> (veya \u0130ngilizce ad\u0131yla SHEET<\/code>) fonksiyonudur. Bu i\u015flev, i\u00e7inde bulunan sayfan\u0131n (\u00e7al\u0131\u015fma tablosunun) sayfa numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Elbette bu, \u00e7oklu sayfa i\u00e7eren dosyalarda daha faydal\u0131d\u0131r. <\/p>\n

Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

SAYFA<\/code> i\u015flevi hem Excel hem de Google E-Tablolar’da benzer \u015fekilde \u00e7al\u0131\u015f\u0131r. A\u015fa\u011f\u0131da bu i\u015flevin s\u00f6zdizimi bulunmaktad\u0131r: <\/p>\n

SAYFA()<\/code><\/pre>\n
 Bu i\u015flevi kullan\u0131rken herhangi bir arg\u00fcman verilmez, i\u015flev bulundu\u011fu \u00e7al\u0131\u015fma sayfas\u0131n\u0131n indeks numaras\u0131n\u0131 otomatik olarak d\u00f6nd\u00fcr\u00fcr. <\/p>\n
Pratik Uygulamalar<\/h2>\n
 SAYFA<\/code> i\u015flevi, verilerin bulundu\u011fu sayfa numaras\u0131n\u0131 belirleyerek m\u00fclti-tablolu dosyalarda y\u00f6nlendirme ve analiz yapmay\u0131 kolayla\u015ft\u0131rabilir. \u0130ki \u00f6zg\u00fcn \u00f6rne\u011fi a\u015fa\u011f\u0131da inceleyelim: <\/p>\n
    \n
  • \n
    Sayfa Bazl\u0131 Referans G\u00fcncellemeler<\/h3>\n
     Diyelim ki, birden fazla sayfada benzer yap\u0131da veriler bulunan bir dosyan\u0131z var ve bu verilerden baz\u0131lar\u0131 belli sayfalara g\u00f6re g\u00fcncelleniyor. Her sayfan\u0131n ba\u015f\u0131nda bulunan bir h\u00fccreye =SAYFA()<\/code> yazarak, bu h\u00fccrenin sayfa numaras\u0131n\u0131 g\u00f6sterebilirsiniz. Sonras\u0131nda, ba\u015fka bir sayfada bu sayfa numaralar\u0131n\u0131 referans alarak belirli sayfalardaki verilere ula\u015fabilirsiniz. <\/p>\n
     ='Sayfa' & SAYFA() & '!A1'<\/code> <\/pre>\n
     Bu form\u00fcl, dinamik bir \u015fekilde ‘Sayfa1!A1’, ‘Sayfa2!A1’ gibi referanslar olu\u015fturur ve bu sayede \u00e7oklu sayfa g\u00fcncellemeleri otomatikle\u015fir. <\/p>\n<\/li>\n
  • \n
    Raporlama ve Dashboard Olu\u015fturma<\/h3>\n
     Birden fazla sayfada farkl\u0131 kategorilere ait veriler varsa ve bir \u00f6zet (dashboard) sayfas\u0131 haz\u0131rlamak istiyorsan\u0131z, SAYFA<\/code> fonksiyonunu kullanarak hangi sayfadan veri \u00e7ekti\u011finizi belirtebilirsiniz. B\u00f6ylece, \u00f6zet sayfan\u0131zda hangi sayfan\u0131n verilerinin g\u00f6sterildi\u011fini kolayl\u0131kla g\u00f6sterebilir ve hata yapma riskini azaltabilirsiniz. <\/p>\n
     'Sayfa' & SAYFA() & ' \u00dcr\u00fcnleri'<\/code> <\/pre>\n
     Bu form\u00fcl, ‘Sayfa 1 \u00dcr\u00fcnleri’, ‘Sayfa 2 \u00dcr\u00fcnleri’ gibi dinamik ba\u015fl\u0131klar olu\u015fturman\u0131za olanak sa\u011flar. <\/p>\n<\/li>\n<\/ul>\n
    Sonu\u00e7<\/h2>\n
     SAYFA<\/code> veya SHEET<\/code> i\u015flevinin kullan\u0131m\u0131, \u00f6zellikle b\u00fcy\u00fck ve \u00e7oklu sayfal\u0131 Excel dosyalar\u0131nda veri y\u00f6netimi a\u00e7\u0131s\u0131ndan olduk\u00e7a de\u011ferlidir. Bu i\u015flevi kullanarak referans verileri otomatikle\u015ftirebilir, hata oran\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcrebilir ve raporlama s\u00fcre\u00e7lerinizi h\u0131zland\u0131rabilirsiniz. \u0130ndeks numaralar\u0131 \u00fczerindeki bu basit i\u015flemle, \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131 daha etkin bir \u015fekilde y\u00f6netebilirsiniz. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Ba\u015fvurulan sayfan\u0131n sayfa numaras\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[586],"tags":[],"class_list":["post-15634","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SHEET (SAYFA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\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:\/\/functiontranslator.com\/tr\/sheet\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SHEET (SAYFA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:35:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sheet\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sheet\/\",\"name\":\"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:35:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SHEET (SAYFA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/sheet\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bilgi\",\"item\":\"https:\/\/functiontranslator.com\/tr\/bilgi\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SAYFA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SHEET (SAYFA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\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:\/\/functiontranslator.com\/tr\/sheet\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SHEET (SAYFA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/sheet\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:35:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/sheet\/","url":"https:\/\/functiontranslator.com\/tr\/sheet\/","name":"Excel'de SHEET (SAYFA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:35:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SHEET (SAYFA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/sheet\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Bilgi","item":"https:\/\/functiontranslator.com\/tr\/bilgi\/"},{"@type":"ListItem","position":3,"name":"SAYFA"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15634"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15634\/revisions"}],"predecessor-version":[{"id":26902,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15634\/revisions\/26902"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}