Blank Cell - fill with required data from above cells

Blank Cell – selection and fill with required data from above cells

This feature is mostly used, for to select the blank cells in the excel.

How to do this –

Step 1 - Please click on GoTo or press F5 under Home tab, then click on special will open a new dialogue box

Step 2 - Choose the radio button Blanks

Step 3: Click on OK

You can also press F5 in keyboard to get Goto Menu.

Once blank cells are selected use formula, press = (is equal to) and selected the upper cell and press Ctrl + Enter.

So that blank cells are filled with required data.