Find and Replace Blank Cells in Google Sheets (2025 Update)

How to Find and Replace Blank Cells in Google Sheets

Below, we outline the steps on how to find and replace blank cells in Google Sheets easily:

Step 1: Access the Find and Replace Settings

Below is a sample data set: 

Go to the "Edit" menu at the top of the screen and choose "Find and replace" from the dropdown. Alternatively, you can press Ctrl + H (Windows) or Cmd + H (Mac) to open the dialog box directly.

Step 2: Configure Your Search

In the "Find" field, enter the regular expression ^\s*$ to search for blank cells. This expression matches cells that are empty or contain only whitespace.

Note: This will only work if the cell format is set to plain text. 

Step 3: Enter the Value You Want to Replace the Blank Cells With

In the "Replace with" field, type the value you wish to use as a replacement for the blank cells, for example, "0". 

Ensure to check the "Match case" and "Search using regular expressions" options for the search to work correctly.

Step 4: Execute the Replacement

Click "Replace all" to substitute all blank cells with your specified value, then click "Done".

Related Articles

How to Make a Grade Calculator in Google Sheets (2025 Guide)
Count Cells with Specific Text in Google Sheets (The Easy Way!)