setting default values within a specified range

J

judoist

Does anyone know how to set a default value within a specified range?
I have a database with columns of single figures and blank spaces her
and there. Is it possible to instruct Excel to enter a value of -1 fo
every blank space it meets within the range A1:G250
 
F

Frank Kabel

Hi
only possible with VBA (using an event procedure). Would this be a
feasible way for you?
 
D

Dave Peterson

If this is a one time thing, you could:
select A1:G250
edit|goto|special
blanks
type -1
hit ctrl-enter

And the empty cells in that selection will be filled with -1.
 
Top