{"id":1146,"date":"2016-04-18T14:32:19","date_gmt":"2016-04-18T12:32:19","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1146"},"modified":"2024-02-06T16:17:38","modified_gmt":"2024-02-06T15:17:38","slug":"find-blank-cells-in-excel-with-a-color","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-blank-cells-in-excel-with-a-color\/","title":{"rendered":"Find Blank Cells In Excel With A Color"},"content":{"rendered":"<p>In Excel you can have a data set that comes from an external source which isn&#8217;t always formatted to your liking.<\/p>\n<p>One of the most common things you may encounter are blank cells in your Excel data which can hinder your analysis, especially if you are using a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> to analyze the data.<\/p>\n<p>To find these annoying blank cells in Excel you will need to highlight all your data set (CTRL+*) and bring up the <strong>Go To<\/strong> <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a>:\u00a0 <em>CTRL+G &gt; Special &gt; Blanks.<\/em><\/p>\n<p>Then you can fill in the blank cells with a color red and filter by that same color to drill down to these blank cells and take some formatting action.<\/p>\n<p>I show you how easy this can be done below.<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/aKPTsS0KT64?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><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><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/04\/Go-To-Blanks-By-Color.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/04\/Go-To-Blanks-By-Color.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Go-To-Blanks-By-Color.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><span style=\"color: #000000;\">Make sure your entire table is selected. We will select all the blank cells.<\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\"  class=\"alignnone size-full wp-image-14078\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-01.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"1030\" height=\"502\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-01.png 1030w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-01-300x146.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-01-1024x499.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-01-768x374.png 768w\" sizes=\"(max-width: 1030px) 100vw, 1030px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><span style=\"color: #000000;\">Press <em><strong>Ctrl + G <\/strong><\/em>to open the <strong>Go To Window<\/strong>. <strong>Click\u00a0<\/strong><em><strong>Special.<\/strong><\/em><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\"  class=\"alignnone size-full wp-image-14079\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-02.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"377\" height=\"334\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-02.png 377w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-02-300x266.png 300w\" sizes=\"(max-width: 377px) 100vw, 377px\" \/><\/p>\n<p>Select\u00a0<strong>Blanks. Click OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\"  class=\"alignnone size-full wp-image-14080\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-03.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"314\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-03.png 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-03-285x300.png 285w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><span style=\"color: #000000;\">The blank cells are now selected. Go to\u00a0<em><strong>Home &gt; Font &gt; Fill &gt; <span style=\"color: #ff0000;\">Color Red<\/span><\/strong><\/em><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\"  class=\"alignnone size-full wp-image-14081\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-04.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"821\" height=\"687\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-04.png 821w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-04-300x251.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-04-768x643.png 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><span style=\"color: #000000;\">Let us try it out! Try filtering the Customer column by selecting\u00a0<em><strong>Filter by Color &gt; <span style=\"color: #ff0000;\">Color Red<\/span><\/strong><\/em><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\"  class=\"alignnone size-full wp-image-14082\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-05.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"842\" height=\"418\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-05.png 842w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-05-300x149.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-05-768x381.png 768w\" sizes=\"(max-width: 842px) 100vw, 842px\" \/><\/p>\n<p>Our filtering has worked to show the blank cells!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\"  class=\"alignnone size-full wp-image-14083\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-06.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"766\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-06.png 766w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/Find-Blank-Cells-In-Excel-With-A-Color-06-300x63.png 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/p>\n<p><span style=\"color: #0000ff;\"><strong>How to Find Blank Cells In Excel With A Color<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\">HELPFUL RESOURCE:<\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-66.html\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Resize All Charts Using Macros In Excel\"  class=\"alignnone size-full wp-image-13266\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png\" alt=\"Resize All Charts Using Macros In Excel\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel you can have a data set that comes from an external source which isn&#8217;t always formatted to your liking. One of the most common things you may encounter are blank cells in your Excel data which can hinder your analysis, especially if you are using a Pivot Table to analyze the data. To [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17392,"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,53],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1146"}],"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=1146"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1146\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17392"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}