Fill The Blank Cells In A Column From The Cell Values Above Them

The post demonstrates how to fill the blank values from the values that are written above them as explained in the post below.

Capture

As you can see in the data above we have Products in column A but is not continuous, the data value is there for only one date and we would want to fill the blanks  with the product data that is just above the blank cell till we have reached the end of  data in column B(Date).

This is one of the situation that you come across in excel and I rarely found any solution to this in the internet (without using VB programming).




I will present a very simple solution to do that.

Step 1

Select the Product column till we have the date as shown below-

Capture

Step 2

Press F5 to get the go to box-

Capture

Step 3

Press “Special” at the bottom left corner and Go To Special Box will appear and select “Blanks” and press OK-

Capture

Step 4

After Pressing OK, all the blanks cells will be highlighted as shown below-

Capture




Step 5

Now press F2 and insert the formula in A3 and do not click anywhere otherwise the selected blank cells will be deselected.

Capture

Step 6

After inserting the formula in A3, press Ctrl+Enter to populate all the blank cells with the previous Products.

Capture




Hope this helped. You could use this technique for similar other stuffs.

Share The Knowledge

Random Posts

  • Paste VBA Code From One Sheet To A Different Sheet

    paste vba code from one sheet to different sheet, vba code to copy code from source to destination, excel copy vba code from one sheet to a different sheet

    Share The Knowledge
  • Convert Date Into Week Number In VBA

    convert a date into week number in vba, how to get week number from today’s date, vba to convert date into week number, excel date to week number

    Share The Knowledge
  • Hide Content Of A Cell In Excel

    Let’s see how to hide the content of a cell in excel. Suppose we want to hide the content in […]

    Share The Knowledge
  • Return Font Name And Font Size In VBA

    return font size i excel return font name inn excel, vba to find font size, vba to find font name, get font size in excel, get font name in excel

    Share The Knowledge

Leave a Reply