In excel,how to clear the values of the cell without
removing the formula?
Answers were Sorted based on User's Feedback
Answer / ashok sharma
urKrishna Sharma, u are wrong read the question carefully
hint: use "what if analysis" tools in excel
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / krishna sharma
First, copy the worksheet then on copied sheet hit
F5>Special>Constants
Uncheck what you want to keep, like "text" for titles and
OK
Edit>Clear>Contents or just hit the delete key.
Krishna Sharma
P.M.
Is This Answer Correct ? | 0 Yes | 2 No |
In excel,how to clear the values of the cell without removing the formula?
How do I stop microsoft teams from running at startup?
How do I stop microsoft compatibility telemetry?
Where can I find my microsoft product key?
Shortcut keys for debugging in visual studio?
What is Kerberos? Which version is currently used by Windows? How does Kerberos work?
What are the four microsoft programs?
What is the cycle of Installing patches.....
How to detect clone code in visual studio?
What are the different refactoring options in visual studio?
What the difference between the service messages and transport messages?
What is the contract attribute of the <endpoint> element?