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

Get FREE Advanced Excel Exercises with Solutions!

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.

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 the 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”

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.

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


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


<< Go Back to Fill Blank Cells | Blank Cells in Excel | Excel Cells | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

1 Comment
  1. Hi
    Thanks a lot it was really useful.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo