\u00d6rne\u011fin, bir ma\u011fazan\u0131n art arda sekiz y\u0131ldaki sat\u0131\u015f de\u011ferlerini i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011funuzu varsayal\u0131m:<\/span> <\/p>\n A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, yaln\u0131zca 1. y\u0131l, 3. y\u0131l, 5. y\u0131l ve 7. y\u0131l kalacak \u015fekilde di\u011fer t\u00fcm s\u00fctunlar\u0131n nas\u0131l kald\u0131r\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Hadi gidelim!<\/span><\/p>\n A\u015fa\u011f\u0131daki verileri Excel’e girerek ba\u015flayal\u0131m:<\/span> <\/p>\n Ard\u0131ndan, ilk sat\u0131ra sa\u011f t\u0131klay\u0131n ve a\u00e7\u0131l\u0131r men\u00fcden Ekle’ye<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Daha sonra A1<\/strong> h\u00fccresine Tut<\/strong> ve B1<\/strong> h\u00fccresine Sil<\/strong> yaz\u0131n.<\/span><\/p>\n Ard\u0131ndan A1<\/strong> ve B1<\/strong> h\u00fccrelerini vurgulay\u0131n ve alternatif h\u00fccrelerde Sakla<\/strong> ve Sil’i<\/strong> otomatik olarak doldurmak i\u00e7in form\u00fcl\u00fc sa\u011fa s\u00fcr\u00fckleyin:<\/span> <\/p>\n Ard\u0131ndan, A1:H7<\/strong> aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n, ard\u0131ndan \u00fcst \u015feritteki Veri<\/strong> sekmesine t\u0131klay\u0131n, ard\u0131ndan S\u0131rala ve Filtrele<\/strong> grubundaki S\u0131rala<\/strong> simgesine t\u0131klay\u0131n:<\/span> <\/p>\n G\u00f6r\u00fcnt\u00fclenen yeni S\u0131rala penceresinde Se\u00e7enekler<\/strong> d\u00fc\u011fmesini t\u0131klay\u0131n, ard\u0131ndan Soldan Sa\u011fa S\u0131rala’y\u0131<\/strong> ve ard\u0131ndan Tamam’\u0131<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Ard\u0131ndan, S\u0131ralama<\/strong> \u00f6l\u00e7\u00fct\u00fc kutusunda 1. Sat\u0131r’\u0131<\/strong> se\u00e7in ve Tamam’\u0131<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Tamam’\u0131<\/strong> t\u0131klatt\u0131\u011f\u0131n\u0131zda, s\u00fctunlar otomatik olarak t\u00fcm S\u00fctunlar\u0131 sil<\/strong> ilk \u00f6nce g\u00f6r\u00fcnt\u00fclenecek \u015fekilde s\u0131ralan\u0131r:<\/span> <\/p>\n Ard\u0131ndan, ilk d\u00f6rt s\u00fctunu vurgulay\u0131n, ard\u0131ndan sa\u011f t\u0131klay\u0131n ve a\u00e7\u0131l\u0131r men\u00fcden Sil’i<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n \u0130lk d\u00f6rt s\u00fctun kald\u0131r\u0131lacak ve yaln\u0131zca 1. y\u0131l, 3. y\u0131l, 5. y\u0131l ve 7. y\u0131l s\u00fctunlar\u0131 korunacakt\u0131r:<\/span> <\/p>\n Not<\/strong> : \u0130sterseniz Keep<\/strong> de\u011ferlerini i\u00e7eren ilk sat\u0131r\u0131 da silebilirsiniz, \u00e7\u00fcnk\u00fc bu sat\u0131r\u0131 yaln\u0131zca hangi s\u00fctunlar\u0131n saklanaca\u011f\u0131n\u0131 bilmek i\u00e7in bir yard\u0131m hatt\u0131 olarak olu\u015fturduk.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de belirli bir metin i\u00e7eren sat\u0131rlar nas\u0131l silinir<\/a> Genellikle Excel’deki di\u011fer t\u00fcm s\u00fctunlar\u0131 silmek isteyebilirsiniz. \u00d6rne\u011fin, bir ma\u011fazan\u0131n art arda sekiz y\u0131ldaki sat\u0131\u015f de\u011ferlerini i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011funuzu varsayal\u0131m: A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, yaln\u0131zca 1. y\u0131l, 3. y\u0131l, 5. y\u0131l ve 7. y\u0131l kalacak \u015fekilde di\u011fer t\u00fcm s\u00fctunlar\u0131n nas\u0131l kald\u0131r\u0131laca\u011f\u0131n\u0131 g\u00f6sterir: Hadi gidelim! 1. Ad\u0131m: Verileri girin A\u015fa\u011f\u0131daki verileri Excel’e girerek […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4993","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev1.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev9.png\")
<\/p>\n 1. Ad\u0131m: Verileri girin<\/span><\/strong><\/h2>\n
<\/p>\n Ad\u0131m 2: Yeni bir sat\u0131r ekleyin<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev2.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev3.png\")
<\/p>\n 3. Ad\u0131m: Verileri soldan sa\u011fa s\u0131ralay\u0131n<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sort.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev4.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev5.png\")
<\/p>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev6.png\")
<\/p>\n Ad\u0131m 4: S\u00fctunlar\u0131 Kald\u0131r<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev7.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev8.png\")
<\/p>\n Ek kaynaklar<\/span><\/strong><\/h2>\n
Excel’de filtrelenen sat\u0131rlar nas\u0131l silinir<\/a>
Excel’de bir tablo nas\u0131l silinir<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"