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 |
Provide some Vlookup Examples?
What is SMTP (Simple Mail Transfer Protocol) ?
hi i want to retrieve the data from one spread sheet to another workbook in EXCEL VBA. for exmp:customer details first name last name location state country country code mobile customer details raj krishna hyderabad andhra india 91 0 service required refrigirator company color details cost warranty service required samsung silver double door fridge 45000 3yeras
What is difference between microsoft and windows?
which is the best ineptitude for MSBI in hyderabad?
Why is xaml important for the delivery of e-commerce solutions? : xaml
Can a microsoft office product key be used twice?
How do you run microsoft programs on a mac?
What is the purpose of OLE Automation?
How does xaml relate to business process modeling languages (ebxml business process, bpml)? : xaml
When do you use Microsoft Word, Microsoft zexcel and Microsoft PowerPoint?
What is Domain Name ?
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)