Fill empty cells in a range with 0

[captbluefin]

Is there an easy way to fill empty cells in a range with 0, other than cycling through the range one cell at a time.

Thanks.

[Kaper]

Select all the range
Press Ctrl+G (Go to)
In the dialog window use button Special and select option Empty cells, then press OK
in formula bar write 0 and commit with Ctrl+Enter (not just Enter)

[6StringJazzer]

Do a Find & Replace, finding the null string and replacing with 0, checking "entire cell contents."

2021-12-10.jpg

[6StringJazzer]

select option Empty cells

I do not have this option

2021-12-10 (1).jpg

If I select "Blanks" it will not select all the blanks in the range, only up until the first non-blank cell.

[Pete_UK]

If you pre-select the whole column, then you can use Blanks (after Current Region).

Hope this helps.

Pete

[Kaper]

Indeed in English version the empty cells are called "Blanks"
In my national version they are called "Puste" which would best translate to "Empty"
According to https://translate.google.com/?sl=pl&...e&op=translate blank is the second option, hollow (not too good for cells anyway) third, and vacant (much better) fourth