Replacing blank cells with zero in Excel 2007

You can quickly replace all blank cells by performing the following steps:
1. Select the range of cells.
2. On the Home tab, in the Editing group, click Find & Select and then click Go To Special...
3. In the Go To Special dialog box, click Blanks.
4. Click OK.
5. Excel highlights all the blank cells. Do not click any cell. Type 0 and press CTRL + ENTER.

Additional Reading:

• When Excel highlights all blank cells, an active cell is present. It is highlighted in white with thin border within the cell. When you type 0, it is entered in this cell.
• Click CTRL + END key to know the last cell that has the data in the worksheet. Excel will select all the blank cells till this region only.
• Excel will not select blank cells in an empty worksheet.

Replacing the contents of a cell in Excel 2007

To replace the contents of a cell, click the cell and start typing the data.

Things to know:

• If formatting was already applied to the cell then the newly entered data will have the same formatting. To clear the formats, on the Home tab, in the Editing group, click Clear and finally click Clear Formats
• Once you finish entering the data, press ENTER or TAB or any arrow (UP, DOWN, LEFT, RIGHT) key to accept the new data. Pressing the Esc key will keep the old data.
• You can also copy and paste or drag data from other cell to replace the content.
• If text is entered then it will be left- aligned by default provided that no formatting was applied to the old content.
• If number, date, or time is entered then it will be right-aligned by default provided that no formatting was applied to the old content.