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 |
How do I locate my microsoft office product key?
What is Subnetwork?
What is the use of the code definition window in visual studio?
What is Domain ?
Can I delete old microsoft visual c++ files?
In what order do we have to catch the exceptions: TimoutException, FaultException,
Why user and kernel mode are good designed operating system?
What is Topology?
How to use script on Domain ?
Where will i get Microsoft Office 2010 with License Key free download ?
Enumerate the high level elements of the <system.serviceModel> section
What is Standby ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)