{"id":2163,"date":"2023-09-27T13:31:42","date_gmt":"2023-09-27T13:31:42","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/"},"modified":"2023-12-10T05:59:58","modified_gmt":"2023-12-10T05:59:58","slug":"deklansoru-dondur","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/","title":{"rendered":"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3170023072\"><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 B\u00f6lmeyi Dondur, dondurulan verileri g\u00f6r\u00fcn\u00fcr k\u0131lmak i\u00e7in sayfada herhangi bir yere kayd\u0131r\u0131rken b\u00f6lmeleri dondurmak veya kilitlemek i\u00e7in kullan\u0131lan bir \u00f6zelliktir.<\/p><p> Kullan\u0131c\u0131lar b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken, sayfan\u0131n herhangi bir b\u00f6l\u00fcm\u00fcne kayd\u0131rd\u0131klar\u0131nda her zaman g\u00f6r\u00fcn\u00fcr olmalar\u0131 i\u00e7in ba\u015fl\u0131\u011f\u0131 veya baz\u0131 belirli sat\u0131r ve s\u00fctunlar\u0131 dondurmay\u0131 tercih ederler.<\/p><p> Dondur b\u00f6lmesiyle kullan\u0131c\u0131lar, ihtiya\u00e7lar\u0131na g\u00f6re yaln\u0131zca ba\u015fl\u0131\u011f\u0131 veya yaln\u0131zca ilk s\u00fctunu ya da belirli sat\u0131r ve s\u00fctunlar\u0131n kombinasyonunu dondurabilir.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de b\u00f6lmeyi dondurmak i\u00e7in klavye k\u0131sayolu<\/h2><p> <kbd>Di\u011fer<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>R<\/kbd> (yaln\u0131zca ba\u015fl\u0131\u011f\u0131 dondur) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69452\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctunu dondurman\u0131n k\u0131sayolu\" width=\"781\" height=\"306\"><\/figure><\/div><p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>C<\/kbd> (Yaln\u0131zca ilk s\u00fctunu dondurmak i\u00e7in) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69453\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-pour-geler-len-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"dondurulmu\u015f ba\u015fl\u0131\u011fa k\u0131sayol\" width=\"781\" height=\"306\"><\/figure><\/div><p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>F<\/kbd> (Sat\u0131r ve s\u00fctun kombinasyonunu dondurmak veya \u00f6nceden donmu\u015f olan b\u00f6lmeyi \u00e7\u00f6zmek i\u00e7in) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69454\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourci-pour-figer-les-lignes-et-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 dondurman\u0131n k\u0131sayolu\" width=\"793\" height=\"311\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Klavye K\u0131sayolunu Kullanarak B\u00f6lmeyi Dondurma Ad\u0131mlar\u0131<\/h2><ol><li> Yaln\u0131zca ba\u015fl\u0131k sat\u0131r\u0131n\u0131 (ilk sat\u0131r) dondurmak i\u00e7in sayfada herhangi bir yere t\u0131klay\u0131n ve s\u0131rayla &#8220;Alt \u2192 W \u2192 F \u2192 R&#8221; tu\u015flar\u0131na bas\u0131n; ba\u015fl\u0131k sat\u0131r\u0131n\u0131z donacak ve herhangi bir yere kayd\u0131rd\u0131\u011f\u0131n\u0131zda bile her zaman g\u00f6r\u00fcn\u00fcr olacakt\u0131r. sayfada.<\/li><li> Sa\u011fa kayd\u0131r\u0131p sat\u0131r yerine ilk s\u00fctunu dondurmak istiyorsan\u0131z sayfada herhangi bir yere t\u0131klay\u0131p s\u0131ras\u0131yla &#8220;Alt \u2192 W \u2192 F \u2192 C&#8221; tu\u015flar\u0131na basman\u0131z yeterlidir; ilk s\u00fctununuz donacakt\u0131r.<\/li><li> Belirli sat\u0131r ve s\u00fctun kombinasyonunu dondurmak i\u00e7in, dondurmak istedi\u011finiz s\u00fctun ve sat\u0131rlar\u0131n solundaki ve \u00fcst\u00fcndeki h\u00fccreye gidin, ard\u0131ndan &#8220;Alt \u2192 W \u2192 F \u2192 F&#8221; tu\u015flar\u0131na bas\u0131n; sat\u0131r kombinasyonunuz ve s\u00fctunlar\u0131n\u0131z birlikte donacakt\u0131r.<\/li><li> B\u00f6lmeyi \u00e7\u00f6zmek i\u00e7in \u201cAlt \u2192 W \u2192 F \u2192 F\u201d tu\u015flar\u0131na basman\u0131z yeterlidir. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69455\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-colonnes-pour-figer-les-lignes-et-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctundan-sat\u0131rlar\u0131-ve-s\u00fctunlar\u0131-dondurmak\" width=\"565\" height=\"195\"><\/figure><\/div><p> Yukar\u0131daki g\u00f6rselde \u00f6nce C3 h\u00fccresine gittik ve ard\u0131ndan Alt \u2192 W \u2192 F \u2192 F tu\u015flar\u0131na bast\u0131k, bu h\u00fccrenin \u00fcst\u00fcndeki sat\u0131rlar ve bu h\u00fccrenin solundaki s\u00fctunlar art\u0131k donmu\u015f durumda, ilk iki sat\u0131r\u0131 a\u015fa\u011f\u0131 kayd\u0131r\u0131rsak her zaman g\u00f6r\u00fcn\u00fcr olacak ve sa\u011fa kayd\u0131r\u0131rsak ilk iki s\u00fctun her zaman g\u00f6r\u00fcn\u00fcr olacakt\u0131r. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Daha fazla e\u011fitim <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-55\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle\/\">Yeni bir sayfa ekle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-sayfayi-sil\/\">Sayfay\u0131 sil<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bul-degistir-1\/\">Bul ve De\u011fi\u015ftir<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopru-2\/\">K\u00f6pr\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yaklastir-uzaklastir\/\">Yakla\u015ft\u0131r, uzakla\u015ft\u0131r<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">Excel k\u0131sayollar\u0131na geri d\u00f6n\u00fcn (PDF kopya sayfas\u0131)<\/a><\/p><\/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-2163","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 klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;de dondurma b\u00f6lmesini uygulamak i\u00e7in klavye k\u0131sayolunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. \u015eimdi bu k\u0131sayol\" \/>\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\/deklansoru-dondur\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;de dondurma b\u00f6lmesini uygulamak i\u00e7in klavye k\u0131sayolunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. \u015eimdi bu k\u0131sayol\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.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\/deklansoru-dondur\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/\",\"name\":\"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\",\"datePublished\":\"2023-09-27T13:31:42+00:00\",\"dateModified\":\"2023-12-10T05:59:58+00:00\",\"description\":\"Bu e\u011fitimde, Excel&#39;de dondurma b\u00f6lmesini uygulamak i\u00e7in klavye k\u0131sayolunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. \u015eimdi bu k\u0131sayol\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?\"}]},{\"@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 klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?","description":"Bu e\u011fitimde, Excel&#39;de dondurma b\u00f6lmesini uygulamak i\u00e7in klavye k\u0131sayolunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. \u015eimdi bu k\u0131sayol","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\/deklansoru-dondur\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?","og_description":"Bu e\u011fitimde, Excel&#39;de dondurma b\u00f6lmesini uygulamak i\u00e7in klavye k\u0131sayolunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. \u015eimdi bu k\u0131sayol","og_url":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.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\/deklansoru-dondur\/","url":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/","name":"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png","datePublished":"2023-09-27T13:31:42+00:00","dateModified":"2023-12-10T05:59:58+00:00","description":"Bu e\u011fitimde, Excel&#39;de dondurma b\u00f6lmesini uygulamak i\u00e7in klavye k\u0131sayolunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. \u015eimdi bu k\u0131sayol","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/deklansoru-dondur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel klavye k\u0131sayolunu kullanarak b\u00f6lme nas\u0131l dondurulur?"}]},{"@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\/2163","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=2163"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2163\/revisions"}],"predecessor-version":[{"id":2369,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2163\/revisions\/2369"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}