Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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 07:06 PM
Multiple X-Axis Values Rob Herrmann Charts and Charting in Excel 2 January 23rd 05 10:57 PM


All times are GMT +1. The time now is 06:40 PM.

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

About Us

"It's about Microsoft Excel"