{"id":2094,"date":"2023-10-18T02:34:04","date_gmt":"2023-10-18T02:34:04","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/hat-2\/"},"modified":"2023-12-10T06:02:15","modified_gmt":"2023-12-10T06:02:15","slug":"hat-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/hat-2\/","title":{"rendered":"Excel&#39;de sat\u0131r nedir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-26328050\"><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> <h2 class=\"wp-block-heading\">Excel&#8217;de sat\u0131r<\/h2><p> Excel&#8217;deki bir sat\u0131r, h\u00fccrelerin yatay olarak hizalanmas\u0131d\u0131r ve \u00e7al\u0131\u015fma sayfas\u0131nda soldan sa\u011fa do\u011fru uzan\u0131r. Her sat\u0131r, ba\u015flad\u0131\u011f\u0131 yerden itibaren sol taraftaki benzersiz numarayla tan\u0131mlan\u0131r. Tek bir sayfada sahip oldu\u011funuz toplam sat\u0131r say\u0131s\u0131 1.048.576&#8217;d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78175\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel'de sat\u0131r1\" width=\"637\" height=\"269\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bir sat\u0131r se\u00e7in<\/h2><p> Bir sat\u0131r\u0131 se\u00e7mek i\u00e7in say\u0131sal de\u011ferin bulundu\u011fu sat\u0131r ba\u015fl\u0131\u011f\u0131na t\u0131klaman\u0131z yeterlidir. Daha sonra ilk h\u00fccreden sonuncuya kadar t\u00fcm sat\u0131r\u0131 se\u00e7ecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78176\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionnez-la-ligne-de-len-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"ba\u015fl\u0131k sat\u0131r\u0131n\u0131 se\u00e7\" width=\"608\" height=\"287\"><\/figure><\/div><p> S\u00fctunun tamam\u0131n\u0131 se\u00e7menin ba\u015fka bir yolu da klavye k\u0131sayolunu kullanmakt\u0131r. \u00d6ncelikle se\u00e7mek istedi\u011finiz sat\u0131rdaki h\u00fccrelerden birini se\u00e7in. Daha sonra Shift tu\u015funu bas\u0131l\u0131 tutun ve bo\u015fluk \u00e7ubu\u011funa bas\u0131n. \u015eimdi bu sat\u0131r\u0131n tamam\u0131n\u0131 se\u00e7ecektir.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de bir sat\u0131ra referans verme<\/h2><p> Yukar\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde g\u00f6rebilece\u011finiz gibi, her sat\u0131r\u0131n 1 ile ba\u015flayan kendine \u00f6zg\u00fc bir numaras\u0131 vard\u0131r. Ve bir sat\u0131ra at\u0131fta bulunmak i\u00e7in o numaray\u0131 kullanman\u0131z gerekir. Yani 1. sat\u0131ra at\u0131fta bulunmak istiyorsan\u0131z bu adresi 2:2 olarak kullanmal\u0131s\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78177\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-referents-simple-rangee.png\" sizes=\"auto, \" srcset=\"\" alt=\"tek bir sat\u0131ra at\u0131fta bulunarak\" width=\"440\" height=\"364\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte toplam fonksiyonundaki adresini kullanarak 1. sat\u0131ra at\u0131fta bulundu\u011fumuzu g\u00f6rebilirsiniz. Art\u0131k birden fazla sat\u0131ra referans vermek istiyorsan\u0131z, birden fazla sat\u0131ra referans veren bir adres kullanman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78178\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-se-referant-a-plusieurs-lignes-continues.png\" sizes=\"auto, \" srcset=\"\" alt=\"referans-\u00e7oklu-s\u00fcrekli-sat\u0131rlar\" width=\"453\" height=\"392\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte 2&#8217;den 4&#8217;e kadar olan \u00fc\u00e7 sat\u0131rdan bahsediyoruz ve adreste 2. sat\u0131rdan 4. sat\u0131ra kadar olan toplam fonksiyonunu (2:4) kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78179\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-non-continues-referentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fcrekli olmayan \u00e7izgiler referans\u0131\" width=\"462\" height=\"403\"><\/figure><\/div><p> Son olarak s\u00fcrekli olmayan \u00fc\u00e7 sat\u0131r\u0131 kastediyoruz ve bu sat\u0131rlara at\u0131fta bulunmak i\u00e7in aralar\u0131na virg\u00fcl koyarak adreslerini ayr\u0131 ayr\u0131 kulland\u0131k.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;deki son sat\u0131r nedir<\/h2><p> Tek bir e-tabloda toplam 1.048.576 sat\u0131r vard\u0131r. Ve Excel&#8217;deki son sat\u0131r numaras\u0131 1.048.576&#8217;d\u0131r. Bu say\u0131 sabittir ve bir sayfaya daha fazla sat\u0131r ekleyemezsiniz. Daha fazla veri eklemek istiyorsan\u0131z ayn\u0131 say\u0131da sat\u0131ra sahip yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklemeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78180\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-derniere-ligne-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel elektronik tablosundaki son sat\u0131r\" width=\"443\" height=\"191\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\">Microsoft Excel Temelleri (Bile\u015fenler, Par\u00e7alar ve Bilgi Notlar\u0131)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-2\/\">Excel&#8217;de s\u00fctun nedir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cizgileri-goster\/\">Excel&#8217;de sat\u0131rlar\u0131 g\u00f6ster<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/menzil\/\">Excel&#8217;deki aral\u0131k<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/araligi-sec\/\">Excel&#8217;de aral\u0131\u011f\u0131 se\u00e7in<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aktif-hucre\/\">Excel&#8217;de h\u00fccreyi etkinle\u015ftir<\/a><\/li><\/ul><\/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-2094","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>Excel&#039;de sat\u0131r nedir? \u2013 Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"Bu derste Excel&#039;de bir sat\u0131r\u0131n ne oldu\u011funu, bir fonksiyondaki bir sat\u0131ra nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.\" \/>\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\/hat-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de sat\u0131r nedir? \u2013 Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"Bu derste Excel&#039;de bir sat\u0131r\u0131n ne oldu\u011funu, bir fonksiyondaki bir sat\u0131ra nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/hat-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/\",\"name\":\"Excel&#39;de sat\u0131r nedir? \u2013 Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\",\"datePublished\":\"2023-10-18T02:34:04+00:00\",\"dateModified\":\"2023-12-10T06:02:15+00:00\",\"description\":\"Bu derste Excel&#39;de bir sat\u0131r\u0131n ne oldu\u011funu, bir fonksiyondaki bir sat\u0131ra nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/hat-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hat-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de sat\u0131r nedir?\"}]},{\"@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":"Excel&#39;de sat\u0131r nedir? \u2013 Excel Dan\u0131\u015fman\u0131","description":"Bu derste Excel&#39;de bir sat\u0131r\u0131n ne oldu\u011funu, bir fonksiyondaki bir sat\u0131ra nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.","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\/hat-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de sat\u0131r nedir? \u2013 Excel Dan\u0131\u015fman\u0131","og_description":"Bu derste Excel&#39;de bir sat\u0131r\u0131n ne oldu\u011funu, bir fonksiyondaki bir sat\u0131ra nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.","og_url":"https:\/\/exceladvisor.org\/tr\/hat-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/hat-2\/","url":"https:\/\/exceladvisor.org\/tr\/hat-2\/","name":"Excel&#39;de sat\u0131r nedir? \u2013 Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/hat-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/hat-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png","datePublished":"2023-10-18T02:34:04+00:00","dateModified":"2023-12-10T06:02:15+00:00","description":"Bu derste Excel&#39;de bir sat\u0131r\u0131n ne oldu\u011funu, bir fonksiyondaki bir sat\u0131ra nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/hat-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/hat-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/hat-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/hat-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de sat\u0131r nedir?"}]},{"@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\/2094","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=2094"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2094\/revisions"}],"predecessor-version":[{"id":2586,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2094\/revisions\/2586"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}