An easy method to fill the missing values in excel is to make use of the ‘Go to special’ option.
Step1: Select the rows and columns to be filled
Step 2: Now press Ctrl+G to open the ‘Got to’ dialog box
Click in the ‘Special’ button
Step 3: select the ‘Go To Special’ button from the ‘Find and Search’ tab in the left corner of the excel.
Step 4: Click the Blanks option and click OK
Step 5: Press F2 button in the keyboard (or) click the formula bar.
Now you can enter the value you want in the space provided. The active cell (blank cells) will get this value. If you want the same value in all the blank cells, Press Ctrl+Enter
Now you are done!