Add Zeros to Blank Rows in Excel

You can easily add zeros to blank rows in Excel using the Go-To-Special Window by pressing F5. You can highlight all the blank rows. You can follow the instruction below to understand the steps to add Zeros into your data

How to Add Zeros to Blank Rows.

  1. Select the range of cells where you want to replace blank cells with zeros.
  2. Press “F5” to open the Go To dialog box, then click on “Special”.
  3. In the Go To Special dialog box, select “Blanks” and click “OK”.
  4. This will select all blank cells in the selected range.
  5. Press “CTRL+0” to format the selected cells as “General”
  6. Type “0” in one of the selected cell and press ctrl+enter
  7. The selected cells are now filled with “0”

You can how easily it is to fill in black rows with Go_To special window. Alternative you can use ca cnoditional formula with IF formula The formula would be similar to this. =IF(A1="",0,A1) . Then you would drag this along the rows which would replace the rows with zeros.

Gaelim Holland

Notify of

1 Comment
Newest Most Voted
Inline Feedbacks
View all comments
1 year ago

nice solution