How to Replace Blank Cells with Zero in Google Sheets

To replace blank cells with zero in Google Sheets, follow these steps:

1. Open your Google Sheet where you have data with blank cells.
2. Click on the top-left cell of your data range and drag to select the entire range containing blank cells.
3. Press Ctrl + H or click on Edit in the menu bar, then select Find and replace.
4. In the Find field, leave it empty.
5. In the Replace with field, enter 0 (the number zero).
6. Make sure the Search option is set to Specific range and the range corresponds to the one you have selected.
7. Check the box labeled Also search within formulas.
8. Click on the Replace all button.

Google Sheets will now replace all blank cells within the selected range with zeros.

Example

Let's say you have the following data in your Google Sheet:

A      B      C
1 Fruit Quantity Price
2 Apple  5      10
3 Banana        15
4 Cherry 3

You want to replace the blank cells in the 'Quantity' column with zeros. Follow the steps mentioned above:

1. Select the range B2:B4.
2. Press Ctrl + H or click Edit > Find and replace.
3. Leave the Find field empty.
4. Enter 0 in the Replace with field.
5. Make sure the Search option is set to Specific range and the range is B2:B4.
6. Check the box labeled Also search within formulas.
7. Click on the Replace all button.

The blank cells in the 'Quantity' column will be replaced with zeros. Your updated Google Sheet will look like this:

A      B      C
1 Fruit Quantity Price
2 Apple  5      10
3 Banana 0      15
4 Cherry 3      0