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 to fill blank cells with N/A in Excel. Let’s follow the complete guide to learn all of this.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Easy Ways to Fill Blank Cells with N/A in Excel
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 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.
Read More: How to Fill Blank Cells in Excel with Go To Special (With 3 Examples)
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 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 (4 Methods)
Similar Readings
- How to Return Value if Cell is Blank (12 Ways)
- Find, Count and Apply Formula If a Cell is Not Blank (With Examples)
- How to Highlight Blank Cells in Excel (4 Fruitful Ways)
- Null vs Blank in Excel
- How to Remove Blank Lines in Excel (8 Easy Ways)
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.
Read More: How to Fill Blank Cells with Value Above in Excel VBA (3 Easy Methods)
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.
Read More: How to Fill Blank Cells with 0 in Excel (3 Methods)
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.
Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!
Related Articles
- Fill Blank Cells with Dash in Excel (3 Easy Ways)
- How to Fill Blank Cells with Color in Excel (5 Methods)
- How to Deal with Blank Cells That Are Not Really Blank in Excel (4 Ways)
- If a Cell Is Blank then Copy Another Cell in Excel (3 Methods)
- How to Skip Blank Rows Using Formula in Excel (8 Methods)
- VBA to Count Blank Cells in Range in Excel (3 Methods)
Hi
Thanks a lot it was really useful.