{"id":351,"date":"2014-09-26T12:07:53","date_gmt":"2014-09-26T10:07:53","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=351"},"modified":"2024-02-06T16:05:59","modified_gmt":"2024-02-06T15:05:59","slug":"excel-go-to-blanks","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-go-to-blanks\/","title":{"rendered":"Go To Blanks"},"content":{"rendered":"<p>The<em> Go To Special<\/em> tool within Excel is a must for any serious Excel user as it has an array of useful <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"spreadsheet\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a> formatting and clean up tools.<\/p>\n<p>One that I use all the time is the<em> Go To Special &gt; Blanks<\/em>.\u00a0 This allows you to delete multiple blank rows\/column within seconds.\u00a0 I show you how below.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/T8QykSsBBv8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-To-Blanks.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Go-To-Blanks.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select the entire table containing your data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Go To Blanks\"  class=\"alignnone size-full wp-image-19856\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-01.jpg\" alt=\"Go To Blanks\" width=\"793\" height=\"564\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-01.jpg 793w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-01-300x213.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-01-768x546.jpg 768w\" sizes=\"(max-width: 793px) 100vw, 793px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Press\u00a0<strong>CTRL + G\u00a0<\/strong>to open the\u00a0<strong>Go To Dialog<\/strong>. Click\u00a0<strong>Special<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Go To Blanks\"  class=\"alignnone size-full wp-image-19857\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-02.jpg\" alt=\"Go To Blanks\" width=\"283\" height=\"269\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>Select\u00a0<strong>Blanks <\/strong>and click <strong>OK<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" title=\"Go To Blanks\"  class=\"alignnone size-full wp-image-19858\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-03.jpg\" alt=\"Go To Blanks\" width=\"314\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-03.jpg 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-03-285x300.jpg 285w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Now we have the blank rows selected<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Go To Blanks\"  class=\"alignnone size-full wp-image-19859\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-04.jpg\" alt=\"Go To Blanks\" width=\"799\" height=\"560\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-04.jpg 799w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-04-300x210.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-04-768x538.jpg 768w\" sizes=\"(max-width: 799px) 100vw, 799px\" \/><\/p>\n<p>Right click on a blank row, and go to\u00a0<em><strong>Delete &gt; Table Rows<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Go To Blanks\"  class=\"alignnone size-full wp-image-19860\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-05.jpg\" alt=\"Go To Blanks\" width=\"789\" height=\"573\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-05.jpg 789w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-05-300x218.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-05-768x558.jpg 768w\" sizes=\"(max-width: 789px) 100vw, 789px\" \/><\/p>\n<p>Now your blank rows are now deleted in a blink of an eye!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Go To Blanks\"  class=\"alignnone size-full wp-image-19861\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-06.jpg\" alt=\"Go To Blanks\" width=\"784\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-06.jpg 784w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-06-300x150.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Go-to-blanks-06-768x383.jpg 768w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Go To Special tool within Excel is a must for any serious Excel user as it has an array of useful spreadsheet formatting and clean up tools. One that I use all the time is the Go To Special &gt; Blanks.\u00a0 This allows you to delete multiple blank rows\/column within seconds.\u00a0 I show you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17688,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,37],"tags":[88,54,53],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/351"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17688"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}