{"id":15451,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kopru\/"},"modified":"2021-02-25T16:28:32","modified_gmt":"2021-02-25T16:28:32","slug":"hyperlink","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/hyperlink\/","title":{"rendered":"K\u00d6PR\u00dc"},"content":{"rendered":"

\u0130\u015f d\u00fcnyas\u0131 ve akademik \u00e7al\u0131\u015fmalarda s\u0131k\u00e7a kullan\u0131lan kapsaml\u0131 iki ara\u00e7 olan MS Excel ve Google E-Tablolar, veri i\u015fleme ve analizi konular\u0131nda olduk\u00e7a fonksiyoneldir. Bu ara\u00e7larda kullan\u0131lan farkl\u0131 i\u015flevler, kullan\u0131c\u0131lar\u0131n karma\u015f\u0131k g\u00f6revleri kolayl\u0131kla yerine getirmelerine olanak tan\u0131r. \u00d6zellikle, veri tablolar\u0131n\u0131zda gezinmeyi ve internet kaynaklar\u0131na h\u0131zl\u0131 eri\u015fimi sa\u011flayan “HYPERLINK” ya da T\u00fcrk\u00e7e ad\u0131yla “K\u00d6PR\u00dc” i\u015flevi, bu i\u015flevlerden biridir. Bu rehber, HYPERLINK i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6rneklerle birlikte detayland\u0131racakt\u0131r.<\/p>\n

K\u00d6PR\u00dc \u0130\u015flevinin Temel Kullan\u0131m\u0131<\/h2>\n

“HYPERLINK” fonksiyonu, bir h\u00fccreye t\u0131klanabilir bir ba\u011flant\u0131 eklemenizi sa\u011flar. Bu i\u015flev sayesinde, kullan\u0131c\u0131lar belirtti\u011finiz bir URL’ye ya da dosyan\u0131n kendisindeki farkl\u0131 bir h\u00fccreye kolayca y\u00f6nlendirilebilirler.<\/p>\n

  SYNTAX: MS Excel ve Google E-Tablolar: HYPERLINK(link_location, [friendly_name]) PARAMETRELER: link_location : Ba\u011flant\u0131n\u0131n y\u00f6nlendirece\u011fi URL veya h\u00fccre konumu. friendly_name : (Opsiyonel) Ba\u011flant\u0131 metnini tan\u0131mlar, belirtilmezse URL\/link_location g\u00f6r\u00fcnt\u00fclenir. <\/code> <\/pre>\n
\u00d6rnek kullan\u0131m:<\/p>\n
  =HYPERLINK(\"https:\/\/www.example.com\", \"Example Website\") <\/code> <\/pre>\n
Bu form\u00fcl, “Example Website” ad\u0131nda t\u0131klanabilir bir metin olu\u015fturur ve t\u0131kland\u0131\u011f\u0131nda kullan\u0131c\u0131y\u0131 “www.example.com” adresine y\u00f6nlendirir.<\/p>\n
Pratik Kullan\u0131mlar<\/h2>\n
K\u00d6PR\u00dc i\u015flevinin kullan\u0131ld\u0131\u011f\u0131 iki senaryo \u00fczerinden detayl\u0131 a\u00e7\u0131klamalar yapal\u0131m.<\/p>\n
    \n
  • Raporlar \u0130\u00e7inde H\u0131zl\u0131 Navigasyon:<\/strong> B\u00fcy\u00fck bir finansal rapor \u00e7al\u0131\u015fman\u0131z var diyelim ve belirli b\u00f6l\u00fcmlere h\u0131zl\u0131ca gitmek istiyorsunuz. Excel\u2019in i\u00e7inde bir i\u00e7indekiler sayfas\u0131 olu\u015fturup, her b\u00f6l\u00fcm ba\u015fl\u0131\u011f\u0131na bir HYPERLINK ekleyebilirsiniz.<\/li>\n
  • Web Kaynaklar\u0131na Ba\u011flant\u0131lar:<\/strong> Bir ara\u015ft\u0131rma veya pazar analizi yap\u0131yorsunuz ve toplad\u0131\u011f\u0131n\u0131z verilerin kaynaklar\u0131n\u0131 belirtmek istiyorsunuz. Her veri noktas\u0131n\u0131 do\u011frudan ilgili online kayna\u011fa ba\u011flayarak, verilerinizin do\u011frululu\u011funu ve eri\u015filebilirli\u011fini art\u0131rabilirsiniz.<\/li>\n<\/ul>\n
    \u00d6rnek \u00e7\u00f6z\u00fcm:<\/p>\n
      1. Rapor Navigasyonu: =HYPERLINK(\"#SAYFA!A1\", \"Giri\u015f B\u00f6l\u00fcm\u00fcne Git\") Bu form\u00fcl, \u00e7al\u0131\u015fma kitab\u0131ndaki \"SAYFA\" isimli sayfan\u0131n A1 h\u00fccresine ba\u011flant\u0131 i\u00e7erir. 2. Web Kaynaklar\u0131 Ba\u011flant\u0131s\u0131: =HYPERLINK(\"https:\/\/www.researchexample.com\/data-source\", \"Ara\u015ft\u0131rma Kayna\u011f\u0131\") Bu kullan\u0131m, belirlenen web sayfas\u0131na do\u011frudan link sa\u011flar. <\/code> <\/pre>\n
    Yukar\u0131daki \u00f6rnekler, HYPERLINK i\u015flevinin hem i\u00e7 rapor navigasyonu hem de d\u0131\u015f kaynak ba\u011flant\u0131s\u0131 olu\u015fturmakta nas\u0131l etkin bir \u015fekilde kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. Kullan\u0131c\u0131lar\u0131n ihtiya\u00e7lar\u0131 do\u011frultusunda i\u015flevsellikler ve h\u0131z kazand\u0131ran bu t\u00fcr i\u015flevler, Excel ve Google E-Tablolar’\u0131n vazge\u00e7ilmez \u00f6zelliklerindendir.<\/p>\n
    Bu rehber, HYPERLINK i\u015flevinin temel ve ileri d\u00fczey kullan\u0131mlar\u0131 hakk\u0131nda size fikir verecektir. \u0130ster basit bir web ba\u011flant\u0131s\u0131 ekleyin, ister b\u00fcy\u00fck veri tablolar\u0131n\u0131zda karma\u015f\u0131k navigasyonlar olu\u015fturun, HYPERLINK i\u015flevi bu s\u00fcre\u00e7leri basitle\u015ftirerek zaman kazand\u0131r\u0131r. Denemeler yaparak ve farkl\u0131 senaryolar\u0131 test ederek bu i\u015flevin t\u00fcm potansiyelinden faydalanabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    A\u011f sunucusunda, intranette ya da Internet’te depolanan bir belgeyi a\u00e7an bir k\u0131sayol ya da atlama olu\u015fturur<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15451","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da HYPERLINK (K\u00d6PR\u00dc) 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\/hyperlink\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da HYPERLINK (K\u00d6PR\u00dc) 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\/hyperlink\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:28:32+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 HYPERLINK (K\u00d6PR\u00dc) 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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hyperlink\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/hyperlink\/\",\"name\":\"Excel'de HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:28:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da HYPERLINK (K\u00d6PR\u00dc) 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\/hyperlink\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/hyperlink\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hyperlink\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arama ve ba\u015fvuru\",\"item\":\"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"K\u00d6PR\u00dc\"}]},{\"@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 HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da HYPERLINK (K\u00d6PR\u00dc) 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\/hyperlink\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da HYPERLINK (K\u00d6PR\u00dc) 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\/hyperlink\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:28:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/hyperlink\/","url":"https:\/\/functiontranslator.com\/tr\/hyperlink\/","name":"Excel'de HYPERLINK (K\u00d6PR\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:28:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da HYPERLINK (K\u00d6PR\u00dc) 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\/hyperlink\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/hyperlink\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/hyperlink\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Arama ve ba\u015fvuru","item":"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/"},{"@type":"ListItem","position":3,"name":"K\u00d6PR\u00dc"}]},{"@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\/15451","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=15451"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15451\/revisions"}],"predecessor-version":[{"id":26719,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15451\/revisions\/26719"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}