How to Fill Blank Cells with N/A in Excel (3 Easy Methods)

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.

Using Go To Special Command to Fill Blank Cells with “N/A”

📌 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.

Using Go To Special Command to Fill Blank Cells with “N/A”

  • 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.

Using Go To Special Command to Fill Blank Cells with “N/A”

  • Finally, you will be able to fill blank cells in Excel with N/A like the following.

Using Go To Special Command to Fill Blank Cells with “N/A”


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.

Applying Replace Command to Fill Blank Cells with “N/A”

  • 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.

Applying Replace Command to Fill Blank Cells with “N/A”

  • Finally, you will be able to fill blank cells in Excel with N/A like the following.

Applying Replace Command to Fill Blank Cells with “N/A”


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.

Embedding VBA Code to Fill Blank Cells

  • 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.

Embedding VBA Code to Fill Blank Cells


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.

How to Quickly Fill Blank Cells with Zero or Other Specific Values

📌 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.

How to Quickly Fill Blank Cells with Zero or Other Specific Values

  • Finally, you will be able to fill blank cells in Excel with zero like the following.

How to Quickly Fill Blank Cells with Zero or Other Specific Values


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!

Saquib
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo