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.