Inserting defined values/change and update

Closed
Pico - Dec 2, 2009 at 10:12 AM
 Pico - Dec 6, 2009 at 04:15 AM
Hello,

I was wondering if Excel has an tool that will allow you to insert an specific number that you defined earlier. You insert that number eg. 8 time in your woorksheet. Then your boss says that you have to change that value. Then, insted of searching each value and manualy re-entering new value, you just redefine your custom number and update. Its something like inserting filed in MS Word.
Can this be done in Excel?
Thanx!
Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 2, 2009 at 08:31 PM
are you thinking of validation. This is under data menu. see help on this .
0
Seems interesting!
Will check it out :-)
Thanx!
You use this feature oft?
0