setting default values within a specified range

  • Thread starter Thread starter judoist
  • Start date Start date
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
 
Hi
only possible with VBA (using an event procedure). Would this be a
feasible way for you?
 
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.
 
Back
Top