How to Replace Blank Cells with Zero in Google Sheets


The easiest way to replace blank cells with zeros in Google Sheets is to use the Find and replace function within the Edit tab.

The following example shows how to use this function in practice.

Example: Replace Blank Cells with Zero in Google Sheets

Suppose we have the following data that shows the points scored by various basketball teams:

Suppose we would like to replace the blank cells in the Points column with zeros.

To do so, click the Edit tab and then click Find and replace.

In the new window that appears, type ^\s*$ to find blank cells and use 0 as the replacement.

Type in the cell range you’d like to use this formula on, then check the boxes next to Match case and Search using regulars expressions.

Google Sheets replace blank cells with zeros

Then click Replace all and then click Done.

Each of the blank cells in the Points column will automatically be replaced with zeros:

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Count Number of Occurrences in Google Sheets
How to Check if Value is in Range in Google Sheets
How to Count Unique Values in Google Sheets

Leave a Reply

Your email address will not be published.