Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 20th 05, 04:48 PM
Jaclyn
 
Posts: n/a
Default Simultaneously change values in multiple cells?

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

  #2   Report Post  
Old July 20th 05, 04:56 PM
Jon C
 
Posts: n/a
Default

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

"Jaclyn" wrote:

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

  #3   Report Post  
Old July 20th 05, 04:59 PM
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?

  #4   Report Post  
Old July 20th 05, 05:01 PM
Jaclyn
 
Posts: n/a
Default

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.

"Jon C" wrote:

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

"Jaclyn" wrote:

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

  #5   Report Post  
Old July 20th 05, 05:24 PM
Ron Coderre
 
Posts: n/a
Default

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

1)Set each of the cells that must be reset to zero.
2)ToolsScenariosAdd...
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:
ToolsScenarios
Pick the scenario and click [Show]

Does that help?

--
Regards,
Ron


"Jaclyn" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a link to values to multiple cells. Cesar_us Excel Worksheet Functions 1 June 22nd 05 09:37 PM
paste special | values should work with merged cells PastingSpecial Excel Discussion (Misc queries) 1 June 20th 05 06:51 PM
How can I have excel search and add multiple cells to find a targe Blakepro Excel Discussion (Misc queries) 1 April 1st 05 02:37 AM
Custom Function not being auto calculated when cells change..help? Alex Wolff Excel Worksheet Functions 4 March 22nd 05 08:06 PM
Multiple X-Axis Values Rob Herrmann Charts and Charting in Excel 2 January 23rd 05 11:57 PM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017