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

Because of virus in windows 7 my general folders are system hidden now. i've remove the virus but folders are still hidden. can i make that system hidden folder as nornal any how?

0 Answers  


What is Root ?

2 Answers   CMS,


What is Xeon Processor Technology?

0 Answers   Intel,


What is Taskbar?

0 Answers   CMS,


What’s the difference between forward lookup and reverse lookup in DNS?

15 Answers   DynPro,






What is Dule Core?

1 Answers   HCL,


What is different between VMware and HyperV?

1 Answers  


What is Attached property?

1 Answers  


What is Tunnel or Tunneling?

0 Answers  


What is the definition of Web Server ?

0 Answers  


What is the contract attribute of the <endpoint> element?

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,






Categories