View Single Post
  #3   Report Post  
Duke Carey
 
Posts: n/a
Default

Are they constants or formulas?

If constants, then yes. Are they contiguous cells, or are they scattered
about your sheet? If contiguous, select them all, type a zero, and press
Ctrl-Enter. If scattered about, then carefully select them all using
Ctrl-left click, then give them a rangename. Once they've been named, type
the name into the address box (immediately above the intersection of the grey
bands with the rows #s and column letters) and press Enter (which selects
them all), type a zero, and press Ctrl-Enter

"Jaclyn" wrote:

I would like to simultaneously reset the values of several cells to zero. Is
there a way to do this?