{"id":1554,"date":"2022-10-02T12:56:24","date_gmt":"2022-10-02T09:56:24","guid":{"rendered":"https:\/\/dnsbak.com\/blog\/?p=1554"},"modified":"2022-10-02T13:01:43","modified_gmt":"2022-10-02T10:01:43","slug":"excel-satir-sabitleme-baslik-sabitleme","status":"publish","type":"post","link":"https:\/\/dnsbak.com\/blog\/excel-satir-sabitleme-baslik-sabitleme\/","title":{"rendered":"Excel Sat\u0131r Sabitleme – Ba\u015fl\u0131k Sabitleme"},"content":{"rendered":"\n

Excel \u00fczerinde uzun bir \u00e7al\u0131\u015fma sayfas\u0131na veri giri\u015fi yap\u0131yorsan\u0131z yada tablo ba\u015fl\u0131klar\u0131n\u0131 sabitleyerek kolay bir kullan\u0131m ve g\u00f6r\u00fcn\u00fcm elde etmek i\u00e7in sat\u0131rlar\u0131 veya s\u00fctunlar\u0131 sabitleyebilirsiniz. Bu sayede sayfa i\u00e7erisinde yukar\u0131 a\u015fa\u011f\u0131 yapmadan ba\u015fl\u0131klar\u0131 g\u00f6r\u00fcnt\u00fcleyebilir, \u00f6nemli veya gerekli g\u00f6rd\u00fc\u011f\u00fcn\u00fcz yerleri sabitleyerek daha kolay veri giri\u015fi yapabilirsiniz. Bunun i\u00e7in \u00fcst men\u00fcde bulunan g\u00f6r\u00fcn\u00fcm sekmesi alt\u0131nda bulunan “B\u00f6lmeleri Dondur” se\u00e7ene\u011fini kullanabilirsiniz.<\/p>\n\n\n\n

\u00d6ncelikle sabitlemek istedi\u011fimiz sat\u0131r\u0131 veya s\u00fctunu yada b\u00f6lgeyi i\u015faretlememiz gerekiyor. Bu i\u015flem i\u00e7in sabitlenecek alan\u0131m\u0131z\u0131n bir alt\u0131ndaki sat\u0131r\u0131 se\u00e7iyoruz. Sat\u0131r\u0131n ba\u015f\u0131ndaki sat\u0131r say\u0131lar\u0131na yada s\u00fctun ba\u015fl\u0131klar\u0131ndaki harflere t\u0131klayabilirsiniz. Belirli b\u00f6lgeyi sabitlemek istiyorsan\u0131z o b\u00f6lgeyi direkt olarak i\u015faretleyebilirsiniz. Bu \u00f6rne\u011fimizde dnsbak.com yazan sat\u0131r\u0131m\u0131z\u0131 sabitleyece\u011fimiz i\u00e7in bir alt\u0131ndaki sat\u0131r\u0131 i\u015faretledik.<\/p>\n\n\n\n

\"\"<\/a>
Excel Sabitlenecek Sat\u0131r Se\u00e7me Ekran\u0131<\/figcaption><\/figure>\n\n\n\n

Sabitlenecek olan sat\u0131r\u0131 se\u00e7tikten sonra \u00fcst men\u00fcde bulunan “G\u00f6r\u00fcn\u00fcm” sekmesi alt\u0131na geliyoruz.<\/p>\n\n\n\n

\"\"<\/a>
Excel G\u00f6r\u00fcn\u00fcm sekmesi ve ayarlar\u0131<\/figcaption><\/figure>\n\n\n\n

Bu ekranda bulunan se\u00e7enekler \u00e7ok ama\u00e7l\u0131 olarak kullan\u0131labilir. Sabitlemek istedi\u011finiz sat\u0131r en \u00fcst veya ilk s\u00fctun ise alttaki se\u00e7enekler olan “\u00dcst Sat\u0131r\u0131 Dondur” veya “\u0130lk S\u00fctunu Dondur” b\u00f6l\u00fcmlerini kullanabilirsiniz. Bizler bu \u00f6rnekte kendimizin se\u00e7ti\u011fi sat\u0131r\u0131 dondurmak istedi\u011fimiz i\u00e7in direkt olarak “B\u00f6lmeleri Dondur” se\u00e7ene\u011fini kullanabilirsiniz. <\/p>\n\n\n\n

\"\"<\/a>
Excel B\u00f6lmeleri Dondur Se\u00e7ene\u011fi<\/figcaption><\/figure>\n\n\n\n

Art\u0131k istedi\u011fimiz alan\u0131 sabitlemi\u015f olduk. Sayfada a\u015fa\u011f\u0131 indi\u011finizde belirledi\u011fimiz sat\u0131r\u0131n sabitlendi\u011fini ve ekrandan kaybolmad\u0131\u011f\u0131n\u0131 g\u00f6rebilirsiniz. Bu sayede daha kolay veri giri\u015fi yapabilir. Sunum esnas\u0131nda g\u00f6sterilmek istenen yada tekrar tekrar bakmak gereken durumlarda sabitledi\u011fimiz bu verileri kullanabiliriz.<\/p>\n\n\n\n

NOT: <\/strong>E\u011fer kullanm\u0131\u015f oldu\u011funuz Excel \u00fczerinde “G\u00d6R\u00dcN\u00dcM” sekmesini g\u00f6r\u00fcnt\u00fcleyemiyorsan\u0131z Microsoft Office Starter (Ofis Ba\u015flang\u0131\u00e7) s\u00fcr\u00fcm\u00fcn\u00fc kullan\u0131yor olabilirsiniz. Bu versiyonda bir\u00e7ok \u00f6zellik kullan\u0131lamamaktad\u0131r.<\/h5>\n\n\n
\"MX<\/div>
Trending<\/span>
MX Kayd\u0131 Sorgulama – Mail Servislerini \u00d6\u011fren<\/a><\/div><\/div><\/div>

<\/p>","protected":false},"excerpt":{"rendered":"

Excel \u00fczerinde uzun bir \u00e7al\u0131\u015fma sayfas\u0131na veri giri\u015fi yap\u0131yorsan\u0131z yada tablo ba\u015fl\u0131klar\u0131n\u0131 sabitleyerek kolay bir kullan\u0131m ve g\u00f6r\u00fcn\u00fcm elde etmek<\/p>\n","protected":false},"author":2,"featured_media":1575,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1,19],"tags":[606,604,601,602,612,605,607,600,603,609,614,617,615,622,611,599,618,616,613,619,610,608,621,620],"ppma_author":[213],"class_list":["post-1554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel","category-nasil-yapilir","tag-excel","tag-excel-ac","tag-excel-baslik-sabitleme","tag-excel-dersleri-excel-egitimi","tag-excel-egitimi-ucretsiz","tag-excel-indir","tag-excel-kullanimi","tag-excel-nedir","tag-excel-online","tag-excel-satir-sabitleme-formulu","tag-excel-satir-sabitleme-ingilizce","tag-excelde-satir-araligi-sabitleme","tag-excelde-satir-basi-sabitleme","tag-excelde-satir-basligini-sabitleme","tag-excelde-satir-sabitleme-nasil-yapilir","tag-excell","tag-hucre-adresi-sabitleme","tag-hucre-adresi-sabitleme-formulu","tag-libreoffice-satir-sabitleme","tag-openoffice-satir-sabitleme","tag-satir-sabitleme","tag-satir-sabitlemek","tag-ust-satir-sabitleme","tag-ust-satiri-sabitleme"],"aioseo_notices":[],"authors":[{"term_id":213,"user_id":2,"is_guest":0,"slug":"yigitkazanc","display_name":"Yi\u011fit Kazan\u00e7","avatar_url":{"url":"https:\/\/dnsbak.com\/blog\/wp-content\/uploads\/2021\/08\/yigitkazanc.jpg","url2x":"https:\/\/dnsbak.com\/blog\/wp-content\/uploads\/2021\/08\/yigitkazanc.jpg"},"user_url":"http:\/\/yigitkazanc.com","last_name":"Kazan\u00e7","first_name":"Yi\u011fit","description":"dnsbak.com ipbak.net"}],"_links":{"self":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts\/1554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/comments?post=1554"}],"version-history":[{"count":13,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts\/1554\/revisions"}],"predecessor-version":[{"id":1583,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts\/1554\/revisions\/1583"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/media\/1575"}],"wp:attachment":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/media?parent=1554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/categories?post=1554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/tags?post=1554"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}