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

Uncheck what you want to keep, like "text" for titles and

Edit>Clear>Contents or just hit the delete key.

Krishna Sharma

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Microsoft Related AllOther Interview Questions

What is WAN (Wide Area Network) ?

0 Answers  

What is Computer Memory?

0 Answers   CMS,

What is UNIX?

0 Answers   Reliance,

what is the microsoft accepta?

1 Answers  

What is Unicode?

0 Answers   Maersk,

how to auto generate the text box using infopath?

0 Answers   Microsoft,

What is XT (eXtended Technology)

0 Answers   CMS, Baidu,

What is the maximum number of fields of data form, can be displayed in a worksheet of MS Excel Program? (a)16; (b)24; (c)32; (d)48.

1 Answers   Idbi Bank, Baidu,

What is Upload

0 Answers   Quexst,

Assuming that locks are the only reason due to which deadlocks can occur in a system. What would be a foolproof method of avoiding deadlocks in the system.

0 Answers   Microsoft,

What is Segment ?

0 Answers   CMS,

What is Self-Installation Kit ?

0 Answers