Fill blank cells in excel with value above

Fill blank cells in excel with value above 

If there is a data in a column and you want it to be automatically fill down in the blank cells in excel it can be  done in following very simple 7 steps.

Step 1 for Fill blank cells

  Select the column you want to fill down in the excel sheet.

Step 2 for Fill blank cells

 Press F5 button on the keyboard.(this step is the short cut way for “Go to” box
Or press “ctrl+g” keys on the keyboard

Now a message box naming “go to” will appear on the screen .  

 

 

Step 3 for Fill blank cells

      Click on the special (left bottom of the box)

                Or press “Alt+s” keys
 
A new window (go to special) will open

                                         

Step 4 for Fill blank cells

     Click on Blanks      

  Or press “Alt+k”

           

Step 5 for Fill blank cells 

       Press OK button

(in this way from 1^st to 5^th step we have selected the Blanks sells in our selected area)

.                       

 

Now the important task starts

Step 6 for Fill blank cells

     Press Plus sign “+” or equal sign “=” same way we write the formula in cell.
 

Step 7 for Fill blank cells

                         Press up arrow

   

Step 8 for Fill blank cells

                            Press "Ctrl+enter"

                                    Its done

      For more clarification video link is:

https://www.youtube.com/watch?v=QeQ3OI44Mt0