J
Jaclyn
I would like to simultaneously reset the values of several cells to zero. Is
there a way to do this?
there a way to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jon C
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
then press CTRL Enter, all of the selected cells will be set to zero.
Jon C
D
Duke Carey
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
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
J
Jaclyn
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.
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.
R
Ron Coderre
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?
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?