Step 3: Open the “Find and Replace” dialogue box either by press Ctrl+H or click on the Home tab > Click on the Find & Select command > Click on the “Replace” command. Must Read: How to Age calculation From Date of Birth – MS EXCEL Step 2: Take cursor on any blank cell and press Ctrl+C. Step 1: Open the existing worksheet in which you have lot of blank cells.
Now, you will see all the blank cells fill with 0 or any specific value in the active worksheet of Excel.
Step 4: Fill any specific value or 0 in the blank cell after that press Ctrl+Enter.
Step 3: Select “Blanks” option and click on the OK button.
