In excel,how to clear the values of the cell without
removing the formula?




Answers were Sorted based on User's Feedback



In excel,how to clear the values of the cell without removing the formula?..

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

In excel,how to clear the values of the cell without removing the formula?..

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 Defragment?

0 Answers   CMS, Baidu,


What is Video Conferencing ?

0 Answers  


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,


In which scenario i can use stub zone and why if i have all information in my primary dns server?

0 Answers   HP,


In MS Excel,What is Pivot Table,vLookup, Hlookup ? Reply if Know.

1 Answers   eClerx,






What is Twisted Pair ?

0 Answers  


How to restore deleted OU in DC ?

0 Answers   IBM,


what is DHCP relay agent?

2 Answers   Wipro,


What is Hardware Drivers?

0 Answers   HCL,


What is Taskbar?

0 Answers   CMS,


What is SCSI (Small Computer System Interface)?

0 Answers   Zenith,


which is the best ineptitude for sqlserver dba in hyderabad?

0 Answers   Baidu,






Categories