{"id":1628,"date":"2023-11-14T19:39:30","date_gmt":"2023-11-14T19:39:30","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/"},"modified":"2023-12-10T06:01:29","modified_gmt":"2023-12-10T06:01:29","slug":"gizli-satir-sutunlarini-kaldir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/","title":{"rendered":"Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3330148937\"><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>Bazen kullan\u0131c\u0131lar Excel verileri \u00fczerinde \u00e7al\u0131\u015f\u0131rken g\u00f6rmek istemedikleri birden \u00e7ok sat\u0131r ve s\u00fctunu gizlerler ve daha sonra verileri haz\u0131rlad\u0131ktan sonra verilerdeki bu birden \u00e7ok gizli sat\u0131r ve s\u00fctunu kald\u0131rmak s\u0131k\u0131c\u0131 bir i\u015ftir.<\/p><p> Bunun \u00fcstesinden gelmek i\u00e7in Excel&#8217;de gizli sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 tek seferde bulup kald\u0131ran yerle\u015fik bir i\u015flev vard\u0131r. Excel&#8217;deki t\u00fcm gizli sat\u0131rlar\u0131 veya s\u00fctunlar\u0131 kald\u0131rmak i\u00e7in baz\u0131 h\u0131zl\u0131 ve kolay ad\u0131mlar\u0131 burada bulabilirsiniz. <\/p><h2 id=\"delete-all-hidden-rows-or-columns-in-excel-using-inspect-document\" class=\"wp-block-heading\">Belgeyi \u0130ncele&#8217;yi kullanarak Excel&#8217;deki t\u00fcm gizli sat\u0131rlar\u0131 veya s\u00fctunlar\u0131 kald\u0131r\u0131n<\/h2><ol><li> \u0130lk \u00f6nce \u201cDosya\u201d sekmesine t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"1 dosya sekmesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-tab\" width=\"544\" height=\"120\"><\/li><li> Bundan sonra i\u00e7erik men\u00fcs\u00fcnde \u201cBilgi\u201dye t\u0131klay\u0131n, ard\u0131ndan \u201cSorunlar\u0131 Kontrol Et\u201de ve ard\u0131ndan \u201cBelgeyi \u0130ncele\u201dye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-inceleme-belgesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inspecter-le-document.png\" sizes=\"auto, \" srcset=\"\" alt=\"inspect-document\" width=\"602\" height=\"506\"><\/li><li> \u201cBelgeyi \u0130ncele\u201d se\u00e7ene\u011fine t\u0131klad\u0131\u011f\u0131n\u0131zda Excel, \u201cBelge Denet\u00e7isi\u201d men\u00fcs\u00fcn\u00fc a\u00e7ar.<\/li><li> \u015eimdi sadece \u201c\u0130ncele\u201d butonuna t\u0131klaman\u0131z yeterli. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-belge denet\u00e7isi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-inspecteur-de-documents.png\" sizes=\"auto, \" srcset=\"\" alt=\"document-inspector\" width=\"450\" height=\"417\"><\/li><li> Sonunda \u201cGizli Sat\u0131rlar ve S\u00fctunlar\u201d se\u00e7iminde \u201cT\u00fcm\u00fcn\u00fc Sil\u201d i t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-hepsini sil\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-supprimer-tout.png\" sizes=\"auto, \" srcset=\"\" alt=\"remove-all\" width=\"452\" height=\"421\"><\/li><li> Bu noktada Excel&#8217;deki t\u00fcm gizli sat\u0131rlar veya s\u00fctunlar silinmi\u015ftir. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 gizli sat\u0131r ve s\u00fctunlar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-et-colonnes-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"hidden-rows-and-columns\" width=\"451\" height=\"415\"><\/li><\/ol><h2 id=\"delete-all-hidden-rows-or-column-using-vba-macros\" class=\"wp-block-heading\"> VBA&#8217;y\u0131 kullanarak t\u00fcm gizli sat\u0131rlar\u0131 veya s\u00fctunlar\u0131 kald\u0131r\u0131n<\/h2><p> A\u015fa\u011f\u0131daki iki kodda kullan\u0131lan aral\u0131ktaki gizli olan sat\u0131r ve s\u00fctunlar\u0131 kald\u0131rabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub delete_hidden_columns() Dim ws As Worksheet Dim iCol As Integer Set ws = ActiveSheet iCol = ws.UsedRange.Columns(ws.UsedRange.Columns.Count).Column For i = iCol To 1 Step -1 If Columns(i).Hidden = True Then Columns(i).EntireColumn.Delete Next End Sub '------------------------------------------------- Sub delete_hidden_rows() Dim ws As Worksheet Dim iRow As Integer Set ws = ActiveSheet iRow = ws.UsedRange.Columns(ws.UsedRange.Rows.Count).Row For i = iRow To 1 Step -1 If Rows(i).Hidden = True Then Rows(i).EntireRow.Delete Next End Sub<\/code><\/pre><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-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopruleri-ekle-kaldir\/\">Excel&#8217;de k\u00f6pr\u00fc ekleme ve kald\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/filigran-ekle\/\">Excel&#8217;e filigran ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucrelerin-secimini-kaldir\/\">Excel&#8217;de h\u00fccrelerin se\u00e7imini kald\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-ekle\/\">Excel&#8217;de s\u00fctun ekleme<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satirlari-sil\/\">Excel&#8217;de bir sat\u0131r\u0131 veya birden \u00e7ok sat\u0131r\u0131 silme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutunu-kopyala\/\">Excel&#8217;de bir s\u00fctunu kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sutununu-tasi\/\">Excel&#8217;de bir sat\u0131r\u0131 ve s\u00fctunu ta\u015f\u0131ma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-genisligi\/\">Excel&#8217;de s\u00fctun geni\u015flikleri nas\u0131l de\u011fi\u015ftirilir?<\/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-1628","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>\u25b7 Excel&#039;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, t\u00fcm gizli sat\u0131r ve s\u00fctunlar\u0131 iki farkl\u0131 y\u00f6ntem kullanarak nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/gizli-satir-sutunlarini-kaldir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, t\u00fcm gizli sat\u0131r ve s\u00fctunlar\u0131 iki farkl\u0131 y\u00f6ntem kullanarak nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.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\/gizli-satir-sutunlarini-kaldir\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/\",\"name\":\"\u25b7 Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\",\"datePublished\":\"2023-11-14T19:39:30+00:00\",\"dateModified\":\"2023-12-10T06:01:29+00:00\",\"description\":\"Bu e\u011fitimde, t\u00fcm gizli sat\u0131r ve s\u00fctunlar\u0131 iki farkl\u0131 y\u00f6ntem kullanarak nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?\"}]},{\"@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":"\u25b7 Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?","description":"Bu e\u011fitimde, t\u00fcm gizli sat\u0131r ve s\u00fctunlar\u0131 iki farkl\u0131 y\u00f6ntem kullanarak nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","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\/gizli-satir-sutunlarini-kaldir\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?","og_description":"Bu e\u011fitimde, t\u00fcm gizli sat\u0131r ve s\u00fctunlar\u0131 iki farkl\u0131 y\u00f6ntem kullanarak nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.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\/gizli-satir-sutunlarini-kaldir\/","url":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/","name":"\u25b7 Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","datePublished":"2023-11-14T19:39:30+00:00","dateModified":"2023-12-10T06:01:29+00:00","description":"Bu e\u011fitimde, t\u00fcm gizli sat\u0131r ve s\u00fctunlar\u0131 iki farkl\u0131 y\u00f6ntem kullanarak nas\u0131l kald\u0131raca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/gizli-satir-sutunlarini-kaldir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de gizli sat\u0131rlar nas\u0131l kald\u0131r\u0131l\u0131r?"}]},{"@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\/1628","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=1628"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1628\/revisions"}],"predecessor-version":[{"id":2528,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1628\/revisions\/2528"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}