Topics

Apr 10, 2011

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.

0 comments:

Post a Comment