{"id":1408,"date":"2022-12-23T15:58:58","date_gmt":"2022-12-23T15:58:58","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1408"},"modified":"2024-01-30T22:22:50","modified_gmt":"2024-01-30T22:22:50","slug":"how-to-highlight-blank-cells-and-fill-down-blank-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-highlight-blank-cells-and-fill-down-blank-cells-in-excel\/","title":{"rendered":"How to Highlight Blank Cells and Fill Down Blank Cells in Excel? 3 Easy Methods."},"content":{"rendered":"<p>Highlight blank cells in Excel to quickly navigate and manage data within your spreadsheets effectively. Whether you&#8217;re tidying up data entry, preparing for a presentation, or conducting data analysis, knowing how to mark these cells can streamline your workflow. This guide will walk you through the process of highlighting and filling down blank cells, ensuring your datasets are clean and comprehensively utilized. By mastering these simple steps, you&#8217;ll enhance your Excel proficiency and ensure that no detail, no matter how small, is overlooked in your data-driven tasks.<\/p>\n<p>Blank cells in a dataset can occur for a variety of causes, including the following:<\/p>\n<ul>\n<li>The information is unavailable.<\/li>\n<li>Data points were unintentionally deleted.<\/li>\n<li>A blank cell is produced when a formula returns a string that is empty.<\/li>\n<\/ul>\n<p>First, we must fill in the blanks. If not, it might lead to certain issues. Naturally, you can manually type into the empty cells. But if you have a huge dataset, it will be really tiresome. Our methods will enable you to quickly fill in the blanks in this situation.<\/p>\n<p><strong>\u00a0<\/strong><strong>This Tutorial Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#highlight-or-select-blank-cells-in-excel\"><strong>Highlight or Select Blank Cells in Excel<\/strong><\/a>\n<ul>\n<li><strong>Highlight blank cells using conditional Formatting<\/strong><\/li>\n<li><strong>Select and Highlight Blank Cells in Excel<\/strong><\/li>\n<li><strong>Using VBA to Highlight Blank Cells<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-fill-down-blank-cells-in-excel\"><strong>How to Fill down blank cells in Excel<\/strong><\/a>\n<ul>\n<li><strong>Way -01: Fill down using Formula (GoTo Special + Formula)<\/strong><\/li>\n<li><strong>Way -02: Fill down using easy VBA Code<\/strong><\/li>\n<li><strong>Way -03: Fill down using easy Power Query<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2><strong id=\"highlight-or-select-blank-cells-in-excel\">1. Highlight Blank Cells in Excel<\/strong><\/h2>\n<p>While it&#8217;s simple to identify these blank cells in a small dataset, doing so manually in a large dataset with hundreds of rows and columns would be extremely time-consuming and error-prone. There are various ways to highlight blank cells in Excel. They are:<\/p>\n<ul>\n<li>Highlight blank cells using conditional Formatting<\/li>\n<li>Select and Highlight Blank Cells in Excel<\/li>\n<li>Using VBA to Highlight Blank Cells<\/li>\n<\/ul>\n<h3><strong>Highlight blank cells using conditional Formatting<\/strong><\/h3>\n<p>When the specified condition is satisfied, conditional formatting is an excellent way to highlight cells based on their value.<\/p>\n<p><strong>Step 1:<\/strong> Simply select the data to start, outlined in Red below.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-1409\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-1.png\" alt=\"Highlight and Fill down blank cells\" width=\"639\" height=\"264\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-1.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-1-300x124.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Select the Home tab. Select &#8220;New Rule&#8221; from the Conditional Formatting drop-down menu, outlined in Red below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1410\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-2.png\" alt=\"Highlight and Fill down blank cells\" width=\"740\" height=\"331\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-2.png 740w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-2-300x134.png 300w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Select &#8220;Format only cells that contain&#8221; in the &#8220;New Formatting Rules&#8221; dialog box, outlined in Red below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1411\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-3.png\" alt=\"Highlight and Fill down blank cells\" width=\"641\" height=\"369\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-3.png 641w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-3-300x173.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Choose &#8220;Blanks&#8221; from the drop-down menu, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1412\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-4.png\" alt=\"Highlight and Fill down blank cells\" width=\"647\" height=\"370\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-4.png 647w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-4-300x172.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Click \u201cFormat\u201d, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1413\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-5.png\" alt=\"Highlight and Fill down blank cells\" width=\"378\" height=\"375\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-5.png 378w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-5-300x298.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-5-150x150.png 150w\" sizes=\"(max-width: 378px) 100vw, 378px\" \/><\/p>\n<p><strong>Step 6:<\/strong> Go to \u201cFill\u201d option and select color and then click ok, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1414\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-6.png\" alt=\"Highlight and Fill down blank cells\" width=\"483\" height=\"474\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-6.png 483w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-6-300x294.png 300w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><\/p>\n<p><strong>Step 7:<\/strong> Click ok, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1415\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-7.png\" alt=\"Highlight and Fill down blank cells\" width=\"413\" height=\"399\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-7.png 413w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-7-300x290.png 300w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/p>\n<p>After clicking ok, the result looks like below, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1416\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-8.png\" alt=\"Highlight and Fill down blank cells\" width=\"527\" height=\"274\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-8.png 527w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-8-300x156.png 300w\" sizes=\"(max-width: 527px) 100vw, 527px\" \/><\/p>\n<p>Be aware that conditional formatting for blank cells\u00a0is dynamic. This implies that if conditional formatting is used and a data point is deleted, that cell will be automatically highlighted.<\/p>\n<p>But there is a cost associated with this dynamic behavior. When used on huge data sets, conditional formatting for blank cells\/conditional formatting blank cells can be unstable and slow down your workbook.<\/p>\n<h3><strong>Select and Highlight Blank Cells in Excel:<\/strong><\/h3>\n<p>You can use the &#8220;Go to Special&#8221; technique to quickly select blank cells in Excel and highlight them.<\/p>\n<p><strong>Step 1:<\/strong> Simply select the data to start, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1417\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-9.png\" alt=\"Highlight and Fill down blank cells\" width=\"691\" height=\"281\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-9.png 691w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-9-300x122.png 300w\" sizes=\"(max-width: 691px) 100vw, 691px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Hit the F5 key on the keyboard. The \u201cGo To\u201d dialog box will appear as a result. After that select the \u201cSpecial\u201d button in the \u201cGo To\u201d dialog box, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1418\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-10.png\" alt=\"Highlight and Fill down blank cells\" width=\"324\" height=\"307\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-10.png 324w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-10-300x284.png 300w\" sizes=\"(max-width: 324px) 100vw, 324px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Choose Blanks from the \u201cGo To Special\u201d dialog box and the click ok, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1419\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-11.png\" alt=\"Highlight and Fill down blank cells\" width=\"352\" height=\"367\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-11.png 352w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-11-288x300.png 288w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/p>\n<p>After clicking ok, with all the blank cells selected, highlight these by giving them a cell color.<\/p>\n<p>The result looks like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1420\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-12.png\" alt=\"Highlight and Fill down blank cells\" width=\"524\" height=\"273\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-12.png 524w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-12-300x156.png 300w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/p>\n<p>As previously indicated, this technique is helpful for swiftly selecting and highlighting all of the blank cells. The same procedures can also be used to pick every empty cell and then type 0 or NA or any other pertinent text into it.<\/p>\n<p>Be aware that this approach is not dynamic, unlike conditional formatting. Once you do it, if you accidentally erase a data point, it won&#8217;t be marked.<\/p>\n<h3><strong>Using VBA to Highlight Blank Cells<\/strong><\/h3>\n<p>A short VBA script can be used to highlight empty cells in a chosen dataset.<\/p>\n<p>When you frequently need to locate and highlight empty cells in data sets, this method is more appropriate. The code below can be used to create an add-in or be saved in your own macro workbook with ease.<strong>\u00a0<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Click \u201cVisual Basic\u201d under the Developer tab (or use the ALT + F11 keyboard shortcut), outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1421\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-13.png\" alt=\"Highlight and Fill down blank cells\" width=\"656\" height=\"165\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-13.png 656w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-13-300x75.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Right-click any of the sheet names in the Project Explorer of the VB Editor (if Project Explorer is not visible, press CONTROL + R). After that select \u201cModule\u201d by clicking on \u201cInsert\u201d, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1422\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-14.png\" alt=\"Highlight and Fill down blank cells\" width=\"411\" height=\"426\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-14.png 411w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-14-289x300.png 289w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Copy the VBA code as shown below, then paste it in the Module code window.<\/p>\n<p>Option Explicit<\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Sub HighlightBlankcell ()<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Dim cell As Range<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Dim rng As Range<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Set rng = Sheet1.Range(&#8220;A1:F9&#8221;)<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">For Each cell In rng<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">If cell.Value = &#8220;&#8221; Then<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">cell.Interior.Color = vbRed<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">End If<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Next cell<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">End Sub<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1423\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-15.png\" alt=\"Highlight and Fill down blank cells\" width=\"589\" height=\"319\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-15.png 589w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-15-300x162.png 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Go to the Developer tab after exiting VB Editor, then select &#8220;Macros.&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1424\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-16.png\" alt=\"Highlight and Fill down blank cells\" width=\"665\" height=\"163\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-16.png 665w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-16-300x74.png 300w\" sizes=\"(max-width: 665px) 100vw, 665px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Choose the &#8216;HighlightBlankCells&#8217; macro from the Macro dialog box, then click Run.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1425\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-17.png\" alt=\"Highlight and Fill down blank cells\" width=\"419\" height=\"404\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-17.png 419w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-17-300x289.png 300w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/p>\n<p>After that, the result looks like below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1426\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-18.png\" alt=\"Highlight and Fill down blank cells\" width=\"527\" height=\"260\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-18.png 527w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-18-300x148.png 300w\" sizes=\"(max-width: 527px) 100vw, 527px\" \/><\/p>\n<h3><strong>Using the VB Editor:<\/strong><\/h3>\n<p><strong>Step 1:<\/strong> Click \u201cVisual Basic\u201d under the Developer tab (or use the ALT + F11 keyboard shortcut), outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1427\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-19.png\" alt=\"Highlight and Fill down blank cells\" width=\"653\" height=\"162\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-19.png 653w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-19-300x74.png 300w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/p>\n<p><strong>Step 2: <\/strong>In the toolbar, select the Green Triangle button (or hit the F5 key), outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1428\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-20.png\" alt=\"Highlight and Fill down blank cells\" width=\"373\" height=\"168\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-20.png 373w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-20-300x135.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Choose the &#8216;HighlightBlankCells&#8217; macro from the Macro dialog box, then click Run.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1429\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-21.png\" alt=\"Highlight and Fill down blank cells\" width=\"420\" height=\"405\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-21.png 420w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-21-300x289.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p>After that the result looks like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1430\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-22.png\" alt=\"Highlight and Fill down blank cells\" width=\"522\" height=\"256\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-22.png 522w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-22-300x147.png 300w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/p>\n<h3><strong id=\"how-to-fill-down-blank-cells-in-excel\">2. How to Fill down blank cells in Excel?<\/strong><\/h3>\n<p>You may frequently come across a data set with only one cell containing data and blank cells up until the next value. Filling down or copying down a value into the cells below is simple with Excel. To copy a cell&#8217;s contents to the cells below it, just double-click on the copied cell or drag the fill handle downward.<\/p>\n<p>There are 3 ways to fill down blank cells in Excel. They are:<\/p>\n<ul>\n<li>Using Formula<\/li>\n<li>Using easy VBA Code<\/li>\n<li>Using easy Power Query<\/li>\n<li><strong>Way -01: Fill down using Formula (GoTo Special + Formula)<\/strong><\/li>\n<\/ul>\n<p><strong>Procedure of filling down using Formula (GoTo Special + Formula)<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Simply select the data to start, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1431\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-23.png\" alt=\"Highlight and Fill down blank cells\" width=\"672\" height=\"310\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-23.png 672w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-23-300x138.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Hit the F5 key on the keyboard. The \u201cGo To\u201d dialog box will appear as a result. After that select the \u201cSpecial\u201d button in the \u201cGo To\u201d dialog box, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1432\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-24.png\" alt=\"Highlight and Fill down blank cells\" width=\"325\" height=\"309\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-24.png 325w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-24-300x285.png 300w\" sizes=\"(max-width: 325px) 100vw, 325px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Choose Blanks from the \u201cGo To Special\u201d dialog box and the click ok, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1433\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-25.png\" alt=\"Highlight and Fill down blank cells\" width=\"351\" height=\"368\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-25.png 351w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-25-286x300.png 286w\" sizes=\"(max-width: 351px) 100vw, 351px\" \/><\/p>\n<p>After that, the result looks like below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1434\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-26.png\" alt=\"Highlight and Fill down blank cells\" width=\"509\" height=\"254\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-26.png 509w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-26-300x150.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/p>\n<p>You would observe that one blank cell is lighter than the other blank cells in the selection of blank cells. The active cell for the formula we&#8217;re going to enter is this one.<\/p>\n<p>No matter where the cell is in the selection, our approach would still function.<strong>\u00a0<\/strong><\/p>\n<p><strong>Here are the steps to fill the selected blank cells with data:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Press the keyboard&#8217;s equal-to (=) key. In the active cell, this will insert an equal to sign.<\/p>\n<p>After that Use the up arrow to move up. By doing so, the cell reference of the cell above the active cell will be inserted. For instance, in our scenario, the active cell is B3, and after doing these two procedures, =B2 is entered in the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1435\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-27.png\" alt=\"Highlight and Fill down blank cells\" width=\"479\" height=\"295\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-27.png 479w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-27-300x185.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Press the Enter key while holding down the Control key. The aforementioned actions would automatically insert the value above all of the blank cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1436\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-28.png\" alt=\"Highlight and Fill down blank cells\" width=\"491\" height=\"296\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-28.png 491w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-28-300x181.png 300w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/p>\n<p>Note that we filled the empty cells in this example using formulae. Paste Values in the same column after Copying the one where the process was completed. The information will be kept in the dataset as values. If you don&#8217;t copy and paste values, sorting will be difficult.<\/p>\n<p>Even though it may seem like there are too many steps, once you master this technique, you&#8217;ll be able to fill down data in Excel quickly and within a few seconds.<\/p>\n<p>When employing this strategy, you now have two more considerations to make.<\/p>\n<ul>\n<li><strong>Way -02: Fill down <\/strong><strong>using easy VBA Code<\/strong><\/li>\n<\/ul>\n<p>Another method to fill in empty cells is Excel VBA. Visual Basic for Applications is the official name. It is employed to carry out numerous operations and automate processes. We&#8217;ll utilize the same dataset once again here.<\/p>\n<h3><strong>The procedure of filling down using easy VBA Code<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Simply select the data to start, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1437\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-29.png\" alt=\"Highlight and Fill down blank cells\" width=\"671\" height=\"309\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-29.png 671w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-29-300x138.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Click \u201cVisual Basic\u201d under the Developer tab (or use the ALT + F11 keyboard shortcut), outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1438\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-30.png\" alt=\"Highlight and Fill down blank cells\" width=\"657\" height=\"153\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-30.png 657w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-30-300x70.png 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Right-click any of the sheet names in the Project Explorer of the VB Editor (if Project Explorer is not visible, press CONTROL + R). After that select \u201cModule\u201d by clicking on \u201cInsert\u201d, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1439\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-31.png\" alt=\"Highlight and Fill down blank cells\" width=\"511\" height=\"518\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-31.png 511w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-31-296x300.png 296w\" sizes=\"(max-width: 511px) 100vw, 511px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Copy the VBA code as shown below, then paste it in the Module code window.<\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Sub FillDown()<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">For Each cell In Selection<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">If cell = &#8220;&#8221; Then<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">cell.FillDown<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">End If<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">Next<\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\">End Sub<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1440\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-32.png\" alt=\"Highlight and Fill down blank cells\" width=\"450\" height=\"268\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-32.png 450w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-32-300x179.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Go to the Developer tab after exiting VB Editor, then select &#8220;Macros.&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1441\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-33.png\" alt=\"Highlight and Fill down blank cells\" width=\"668\" height=\"167\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-33.png 668w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-33-300x75.png 300w\" sizes=\"(max-width: 668px) 100vw, 668px\" \/><\/p>\n<p><strong>Step 6:<\/strong> Choose the &#8216;FillDown&#8217; macro from the Macro dialog box, then click Run, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1442\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-34.png\" alt=\"Highlight and Fill down blank cells\" width=\"408\" height=\"404\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-34.png 408w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-34-300x297.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-34-150x150.png 150w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/p>\n<p>After that the result looks like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1443\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-35.png\" alt=\"Highlight and Fill down blank cells\" width=\"514\" height=\"256\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-35.png 514w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-35-300x149.png 300w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/p>\n<p>The VBA code would be run as a result of the steps above, and your data would be put in.<\/p>\n<p>You must save this file as a macro-enabled Excel worksheet if you plan to use this VBA code again in the future (with a .XLSM extension).<\/p>\n<p>You can also make this macro a part of your Quick Access Toolbar, which is constantly visible and accessible with just one click (in the workbook where you have the code in the backend).<\/p>\n<p>Therefore, all you have to do the next time you have data that needs to be filled-down is make the selection and then click the macro button on the Quick Access Toolbar.<\/p>\n<p>This macro can also be included in the Personal Macro Workbook, where it can then be used in any workbook on your computer.<\/p>\n<ul>\n<li><strong>Way -03: Fill down <\/strong><strong>using easy Power Query<\/strong><\/li>\n<\/ul>\n<p>Filling in the blanks is made very simple by Excel Power Query. One of the fastest approaches is this. You must turn the dataset into a table in order to use this technique.<\/p>\n<h3><strong>Procedure of filling down using easy Power Query<\/strong><\/h3>\n<p><strong>Step 1:<\/strong> First of all, simply choose any cell in the dataset. We have selected Cell A1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1444\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-36.png\" alt=\"Highlight and Fill down blank cells\" width=\"533\" height=\"305\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-36.png 533w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-36-300x172.png 300w\" sizes=\"(max-width: 533px) 100vw, 533px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Select the \u201cInsert\u201d tab from ribbon and select \u201cTable\u201d, outlined in Red below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1445\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-37.png\" alt=\"Highlight and Fill down blank cells\" width=\"392\" height=\"164\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-37.png 392w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-37-300x126.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/p>\n<p><strong>Step 3:<\/strong> It will launch a Create Table window. Check the box next to &#8220;My table has headers.&#8221; Click OK to continue.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1446\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-38.png\" alt=\"Highlight and Fill down blank cells\" width=\"244\" height=\"153\" \/><\/p>\n<p>After that, the result looks like below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1447\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-39.png\" alt=\"Highlight and Fill down blank cells\" width=\"576\" height=\"260\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-39.png 576w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-39-300x135.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Now select any cell from the table by doing so. Here, Cell B3 has been chosen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1448\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-40.png\" alt=\"Highlight and Fill down blank cells\" width=\"621\" height=\"307\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-40.png 621w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-40-300x148.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Then, go to the &#8220;Data&#8221; tab from ribbon and select \u2018From Table\/Range\u2019.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1449\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-41.png\" alt=\"Highlight and Fill down blank cells\" width=\"488\" height=\"160\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-41.png 488w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-41-300x98.png 300w\" sizes=\"(max-width: 488px) 100vw, 488px\" \/><\/p>\n<p><strong>Step 6:<\/strong> It will then open a Power Query Editor window. Our table will be inside of it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1450\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-42.png\" alt=\"Highlight and Fill down blank cells\" width=\"699\" height=\"354\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-42.png 699w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-42-300x152.png 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/p>\n<p><strong>Step 7:<\/strong> Right-click the column headers that have empty cells and then choose \u201cFill\u201d and \u201cDown\u201d from the drop-down menu, respectively.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1451\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-43.png\" alt=\"Highlight and Fill down blank cells\" width=\"436\" height=\"472\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-43.png 436w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-43-277x300.png 277w\" sizes=\"(max-width: 436px) 100vw, 436px\" \/><\/p>\n<p><strong>Step 8:<\/strong> After that, select \u2018Close &amp; Load\u2019.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1452\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-44.png\" alt=\"Highlight and Fill down blank cells\" width=\"462\" height=\"175\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-44.png 462w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-44-300x114.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/p>\n<p><strong>Step 9:<\/strong> Following that, a new sheet containing a table with the modifications we made in the Power Query Editor will appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1453\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-45.png\" alt=\"Highlight and Fill down blank cells\" width=\"437\" height=\"240\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-45.png 437w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Highlight-and-Fill-down-blank-cells-45-300x165.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/p>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Highlight blank cells in Excel to quickly navigate and manage data within your spreadsheets effectively. Whether you&#8217;re tidying up data entry, preparing for a presentation, or conducting data analysis, knowing how to mark these cells can streamline your workflow. This guide will walk you through the process of highlighting and filling down blank cells, ensuring [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[295],"tags":[297,296],"class_list":["post-1408","post","type-post","status-publish","format-standard","hentry","category-highlight-blank-cells-and-fill-down-blank-cells","tag-highlight-blank-cells-and-fill-down-blank-cells","tag-highlight-blank-cells-and-fill-down-blank-cells-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=1408"}],"version-history":[{"count":7,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1408\/revisions"}],"predecessor-version":[{"id":8336,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1408\/revisions\/8336"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=1408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=1408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=1408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}