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

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  






Categories