how to auto fill zero in a area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this small and quick question but I don't know how to do it without
knowing anything about Excel Functions. Any help would be really appreciated!
:D
In an area, say from column A to Z, Row 2 to 20, some of the cells have a
number in it, but some of the cells are left blank, is there any way to just
highlight this whole area, and use least steps to fill in all blank cells
with number "0"?
Thank you all in advance! : D
 
Select A2 to Z20.
Hit <F5>
Click "Special"
Click "Blanks"
Then <OK>

Key in 0,
Then <Ctrl> <Enter>

And you should have what you're looking for!
 
thanks a lot man!

:D :D :D


Ragdyer said:
Select A2 to Z20.
Hit <F5>
Click "Special"
Click "Blanks"
Then <OK>

Key in 0,
Then <Ctrl> <Enter>

And you should have what you're looking for!
Click to expand...
 
Back
Top