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.
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.
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)
Best Regards,
Kaper
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.
If you pre-select the whole column, then you can use Blanks (after Current Region).
Hope this helps.
Pete
Do a Find & Replace, finding the null string and replacing with 0, checking "entire cell contents."
2021-12-10.jpg
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks