{"id":486,"date":"2021-04-18T10:59:16","date_gmt":"2021-04-18T09:59:16","guid":{"rendered":"https:\/\/www.filippoboninsegna.com\/?p=486"},"modified":"2021-04-18T10:59:16","modified_gmt":"2021-04-18T09:59:16","slug":"google-sheets","status":"publish","type":"post","link":"https:\/\/www.filippoboninsegna.com\/google-sheets\/","title":{"rendered":"Google Sheets"},"content":{"rendered":"\n<p><a href=\"https:\/\/gsuitetips.com\/tips\/sheets\/how-to-delete-empty-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to delete empty rows<\/a><\/p>\n\n\n\n<ol><li>Select the entire sheet or dataset and go to\u00a0<strong>Data\u00a0<\/strong>>\u00a0<strong>Create a filter<\/strong><\/li><li>Click on the\u00a0<strong>Filter icon\u00a0<\/strong>at the top of any column, then<strong>\u00a0click on\u00a0Clear\u00a0<\/strong>and\u00a0<strong>select\u00a0(Blanks)<\/strong>.<\/li><li>Now you can only see the empty rows.\u00a0<strong>Click on the first empty row from the top, press and hold the Shift key and select the last empty row.<\/strong> <strong>Right click on any selected<\/strong>\u00a0row and click\u00a0<strong>Delete Rows<\/strong>.<\/li><li>Finally, go back to the\u00a0<strong>Data\u00a0<\/strong>tab and\u00a0<strong>click Turn off filter.<\/strong><\/li><\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to delete empty rows Select the entire sheet or dataset and go to\u00a0Data\u00a0>\u00a0Create a filter Click on the\u00a0Filter icon\u00a0at the top of any column, then\u00a0click on\u00a0Clear\u00a0and\u00a0select\u00a0(Blanks). Now you can only see the empty rows.\u00a0Click on the first empty row from the top, press and hold the Shift key and select the last empty row. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[95],"tags":[109,12,110],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Sheets - Filippo Boninsegna<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets - Filippo Boninsegna\" \/>\n<meta property=\"og:description\" content=\"How to delete empty rows Select the entire sheet or dataset and go to\u00a0Data\u00a0&gt;\u00a0Create a filter Click on the\u00a0Filter icon\u00a0at the top of any column, then\u00a0click on\u00a0Clear\u00a0and\u00a0select\u00a0(Blanks). Now you can only see the empty rows.\u00a0Click on the first empty row from the top, press and hold the Shift key and select the last empty row. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Filippo Boninsegna\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-18T09:59:16+00:00\" \/>\n<meta name=\"author\" content=\"Filippo Boninsegna\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fboninsegna\" \/>\n<meta name=\"twitter:site\" content=\"@fboninsegna\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Filippo Boninsegna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\"},\"author\":{\"name\":\"Filippo Boninsegna\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\"},\"headline\":\"Google Sheets\",\"datePublished\":\"2021-04-18T09:59:16+00:00\",\"dateModified\":\"2021-04-18T09:59:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\"},\"wordCount\":89,\"publisher\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\"},\"keywords\":[\"google sheets\",\"how-to\",\"tips\"],\"articleSection\":[\"Bookmarks\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\",\"url\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\",\"name\":\"Google Sheets - Filippo Boninsegna\",\"isPartOf\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#website\"},\"datePublished\":\"2021-04-18T09:59:16+00:00\",\"dateModified\":\"2021-04-18T09:59:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.filippoboninsegna.com\/google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.filippoboninsegna.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/#website\",\"url\":\"https:\/\/www.filippoboninsegna.com\/\",\"name\":\"Filippo Boninsegna\",\"description\":\"Investing, content marketing, automation\",\"publisher\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.filippoboninsegna.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6\",\"name\":\"Filippo Boninsegna\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png\",\"contentUrl\":\"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png\",\"width\":512,\"height\":512,\"caption\":\"Filippo Boninsegna\"},\"logo\":{\"@id\":\"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Sheets - Filippo Boninsegna","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:\/\/www.filippoboninsegna.com\/google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Google Sheets - Filippo Boninsegna","og_description":"How to delete empty rows Select the entire sheet or dataset and go to\u00a0Data\u00a0>\u00a0Create a filter Click on the\u00a0Filter icon\u00a0at the top of any column, then\u00a0click on\u00a0Clear\u00a0and\u00a0select\u00a0(Blanks). Now you can only see the empty rows.\u00a0Click on the first empty row from the top, press and hold the Shift key and select the last empty row. [&hellip;]","og_url":"https:\/\/www.filippoboninsegna.com\/google-sheets\/","og_site_name":"Filippo Boninsegna","article_published_time":"2021-04-18T09:59:16+00:00","author":"Filippo Boninsegna","twitter_card":"summary_large_image","twitter_creator":"@fboninsegna","twitter_site":"@fboninsegna","twitter_misc":{"Written by":"Filippo Boninsegna","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.filippoboninsegna.com\/google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.filippoboninsegna.com\/google-sheets\/"},"author":{"name":"Filippo Boninsegna","@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6"},"headline":"Google Sheets","datePublished":"2021-04-18T09:59:16+00:00","dateModified":"2021-04-18T09:59:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.filippoboninsegna.com\/google-sheets\/"},"wordCount":89,"publisher":{"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6"},"keywords":["google sheets","how-to","tips"],"articleSection":["Bookmarks"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.filippoboninsegna.com\/google-sheets\/","url":"https:\/\/www.filippoboninsegna.com\/google-sheets\/","name":"Google Sheets - Filippo Boninsegna","isPartOf":{"@id":"https:\/\/www.filippoboninsegna.com\/#website"},"datePublished":"2021-04-18T09:59:16+00:00","dateModified":"2021-04-18T09:59:16+00:00","breadcrumb":{"@id":"https:\/\/www.filippoboninsegna.com\/google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.filippoboninsegna.com\/google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.filippoboninsegna.com\/google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.filippoboninsegna.com\/"},{"@type":"ListItem","position":2,"name":"Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.filippoboninsegna.com\/#website","url":"https:\/\/www.filippoboninsegna.com\/","name":"Filippo Boninsegna","description":"Investing, content marketing, automation","publisher":{"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.filippoboninsegna.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/0c080001e2a7830b55ff5a9b4d14d1c6","name":"Filippo Boninsegna","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/","url":"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png","contentUrl":"https:\/\/www.filippoboninsegna.com\/wp-content\/uploads\/2020\/04\/cropped-Filippo-Boninsegna-1-1.png","width":512,"height":512,"caption":"Filippo Boninsegna"},"logo":{"@id":"https:\/\/www.filippoboninsegna.com\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts\/486"}],"collection":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/comments?post=486"}],"version-history":[{"count":0,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/posts\/486\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/media?parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/categories?post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filippoboninsegna.com\/wp-json\/wp\/v2\/tags?post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}