Simultaneously change values in multiple cells?

[Guest]

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

 

[Guest]

If you select each cell that needs to be reset, enter zero in the last one,
then press CTRL Enter, all of the selected cells will be set to zero.

Jon C

 

[Guest]

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

 

[Guest]

Is there a way to automatically pick certain cells? I am creating this for
the use of others in my office, and I need them to be able to "reset" the
worksheet without having to search out the cells that need to be zeroed.

 

[Guest]

An Excel Scenario might be what you're looking for:

1)Set each of the cells that must be reset to zero.
2)Tools>Scenarios>Add...
Name the scenario (ResetCells, or whatever works for you)
Select the cells to be reset.
When done...save the scenario

Then...whenever you need the cells reset:
Tools>Scenarios>
Pick the scenario and click [Show]

Does that help?