In Excel, sometimes it becomes important to fill cells with default values. In this article, I will show you how to fill empty cells with default value in Excel in 3 effective ways. I will show the methods with proper steps and illustrations.
How to Fill Empty Cells with Default Value in Excel: 3 Easy Methods
Let’s consider a dataset called the Final Result of ABC School. The dataset has two columns B & C regarding the Roll and Status of the students respectively. Also, it ranges from B4 to C11. we can see that cells C6 and C9 don’t have any value. This means that the status is unknown for rolls 2 and 5. So, further any delay, let’s jump into the problem and follow the steps to fill empty cells with default values in Excel.
1. Fill Cells with Default Value by Using Simple Formula
This is the first method we are going to describe in this article. We will use a simple formula to fill empty cells with default values in Excel. Here, I will show the method step by step.
Steps:
- First, select the cell D5.
- Then, write down the following formula in the formula bar.
=IF(C5="","Not Appeared",C5)
- Press the Enter.
- Further, use AutoFill to apply the same formula from D5 cell to D11.
- At last, You will find the result just like the picture given below. The blank cells are filled with data “Not Appeared”.
2. Use Find and Replace Method to Fill Cells with Default Value
In this portion of this article, I will apply the Find and Replace method to fill empty cells with default values in Excel. This is a quick and handy method. We will consider the same dataset for this method. From here, I will show the steps with the necessary illustrations of the steps.
Steps:
- First Press CTRL+H to open the Find & Replace dialog box.
- The “Find what” box should remain blank as we are searching for blank boxes.
- Write down “Not Appeared” in the Replace with.
- Then, Press the Replace.
- As a result, you will find the dataset is modified just like the picture given below.
Read More: How to Find and Replace Blank Cells in Excel
3. Apply Go to Special Method to Fill Cells with Default Value
In this portion, I will describe the last but not least method of this article. I will apply the Go to Special process to fill blank cells with default values in Excel. Let’s follow the method step by step.
Steps:
- Select the cells from C5 to C11 at first.
- Press the CTRL+G key to open the Go to dialog box.
- Then, select the Special.
- After that, Click on the Blank.
- Then, select OK.
- You will see the blank boxes are selected in the dataset.
- Moreover, write down “Not Appeared” in blank cells.
- As a result, you will find the output just like the picture given below.
Things to Remember
You should keep in mind that, you need to write the data manually in the blank boxes while using GO to Special method.
Download Practice Workbook
Please download the workbook and practice yourself.
Conclusion
In this article, I have tried to introduce the quickest methods to Fill Empty Cells with Default Values. I hope you have enjoyed the write-up and can increase your Excel skills. Thanks a lot for being with us. You can ask any queries in the comment section or share your opinion.
