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
Do a Find & Replace, finding the null string and replacing with 0, checking "entire cell contents."
2021-12-10.jpg
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
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