If you are looking for some special tricks to fill blank cells with N/A in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to fill blank cells with N/A in Excel. In this article, we’ll discuss three methods of how to fill blank cells with N/A in Excel. Let’s follow the complete guide to learn all of this.
How to Fill Blank Cells with N/A in Excel: 3 Easy Ways
We will use three effective and tricky methods to fill blank cells with N/A in Excel in the following section. This section provides extensive details on three methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.
1. Using Go To Special Command to Fill Blank Cells with N/A
Here, we will demonstrate how to fill blank cells with N/A in Excel. Let us first introduce you to our Excel dataset so that you are able to understand what we are trying to accomplish with this article. The following picture shows that there are a few blank cells in the Sales column in this dataset. We will now fill the blank cells with N/A which stands for “Not Available”. Let’s walk through the steps of using the Go To Special command to fill blank cells with N/A in Excel.
📌 Steps:
- Firstly, select the range of the cells C5:C14. Then go to the Home tab, and select Find & Select option under the Editing group. Click on Go To Special option.
- When the Go To Special dialog box appears, click on Blanks. Next, click on OK.
- As a consequence, we can select all the blank cells like the following.
- Now, type N/A in a blank cell. Then, you must press ‘Ctrl+Enter’ to apply the changes to all the cells.
- Finally, you will be able to fill blank cells in Excel with N/A like the following.
2. Fill Blank Cells with N/A Applying Replace Command
Here, we are going to use another method to fill blank cells with N/A by using the Replace command. Let’s walk through the steps to fill blank cells with N/A in Excel.
📌 Steps:
- Firstly, select the range of the cells C5:C14. Then go to the Home tab, and select the Find & Select option under the Editing group. Click on Replace.
- When the Find and Replace dialog box appears, keep the Find what box empty and click on Replace. Next, type N/A in the Replace with box. Click on Replace All.
- Next, click on OK.
- Finally, you will be able to fill blank cells in Excel with N/A like the following.
Read More: How to Find and Replace Blank Cells in Excel
3. Embedding VBA Code to Fill Blank Cells
By using a simple code, you will be able to fill blank cells with N/A in Excel. You have to follow the following steps.
📌 Steps:
- Firstly, press Alt+F11 to open the VBA editor. Select Insert > Module.
- Next, you have to type the following code
Sub FillBlank_Cells_with__NA_in_Excel()
Dim Selected_area1 As Range
Dim Enter_NA As String
On Error Resume Next
Enter_NA = InputBox("Type a value that will fill blank cells", _
"Fill Blank Cells")
For Each Selected_area1 In Selection
If IsEmpty(Selected_area1) Then
Selected_area1.Value = Enter_NA
End If
Next
End Sub
- Afterward, close the Visual Basic window, and select the range of the cells C5:C14.
- After that press ALT+F8.
- When the Macro dialogue box opens, select FillBlank_Cells_with_NA_in_Excel in the Macro name. Click on Run.
- When the Fill Blank Cells dialog box appears, type N/A in the box.
- Finally, you will be able to fill blank cells in Excel with N/A like the following.
How to Quickly Fill Blank Cells with Zero or Other Specific Values
This section demonstrates how to fill blank cells with zero or other values. Let’s walk through the steps to fill blank cells in Excel with zero.
📌 Steps:
- Firstly, select the range of the cells C5:C14. Then press ‘Ctrl+F’.
- When the Find and Replace dialog box appears, keep the Find what box empty and click on Replace. Next, type 0 (zero) in the Replace with box. Click on Replace All.
- Next, click on OK.
- Finally, you will be able to fill blank cells in Excel with zero like the following.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
That’s the end of today’s session. I strongly believe that from now you may fill blank cells with N/A in Excel. If you have any queries or recommendations, please share them in the comments section below. Keep learning new methods and keep growing!
Related Articles
- How to Fill Blank Cells with Formula in Excel
- How to Fill Empty Cells with Default Value in Excel
- How to Fill Empty Cells with Last Value in Excel
- Fill Blank Cells with Text in Excel
<< Go Back to Fill Blank Cells | Blank Cells in Excel | Excel Cells | Learn Excel
Hi
Thanks a lot it was really useful.