In this article:

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

January 13, 2025

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: 

find and replace blank cells in google sheets

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.

how to find and replace blank cells in google sheets

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.

how to fill blank cells with value above in google sheets

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

how to find blank cells in google sheets

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

replace blank cells with 0 in google sheets

We hope that this article has helped you and given you a better understanding of how to find and replace blank cells in Google Sheets. If you enjoyed this article, you might also like our articles on how to use the NORMDIST function in Google Sheets and how to get a random number from a list with no repeats in Google Sheets.

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages