Below, we outline the steps on how to find and replace blank cells in Google Sheets easily:
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.
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.
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.
Click "Replace all" to substitute all blank cells with your specified value, then click "Done".
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.
