How to Fill Empty Cells with a Default Value in Excel – 3 Methods

Posted on by Souptik Roy

Consider the following dataset.

To fill empty cells with default values:

Dataset of excel fill empty cells with default values

Method 1 – Fill Cells with a Default Value by Using a Simple Formula

Steps:

  • Select D5.
  • Enter the following formula in the formula bar.
=IF(C5="","Not Appeared",C5)

Simple formula excel fill empty cells with default values

  • Press Enter.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Simple formula excel fill empty cells with default values

Blank cells display “Not Appeared”.

Simple formula excel fill empty cells with default values

Method 2 – Use the Find and Replace Method to Fill Cells with a Default Value

Find and replace method excel fill empty cells with default values Steps:

  • Press CTRL+H to open the Find & Replace dialog box.

Find and replace method excel fill empty cells with default value

  • Keep “Find what” blank.
  • Enter “Not Appeared” in Replace with.
  • Click Replace.

Find and replace method excel fill empty cells with default value

This is the output.

Find and replace method excel fill empty cells with default value

Read More: How to Find and Replace Blank Cells in Excel

Method 3 – Applying the Go to Special feature to Fill Cells with a Default Value

Steps:

  • Select C5:C11.

  • Press CTRL+G to open the Go to dialog box.
  • Select Special.

  • Check Blanks.
  • Click OK.

Blank cells are selected.

  • Enter “Not Appeared” in the blank cells.

This is the output.

Download Practice Workbook

Download the workbook and practice.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!

Leave a Reply

Your email address will not be published. Required fields are marked *

Advanced Excel Exercises with Solutions PDF