Populate blank cell with "0"

  • Thread starter Thread starter Drew K.
  • Start date Start date
D

Drew K.

Greetings,

Is there a simple way to replace blank cells within a
spreadsheet with a value? I attempted a CTRL+H but cannot
figure out the proper value for "Find what:".

Thanks in advance,
Drew
 
Select the entire area, do Edit / Go To / Special / Blank cells - Then type 0 and hit CTRL+ENTER.
 
Back
Top