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

DOTNET -> WPF what is Freezable?

1 Answers  


What is the name attribute of the <service> element?

0 Answers  


What authentication options do Windows 2000 Servers have for remote clients?

1 Answers   HP,


What is Shared Hosting ?

0 Answers  


What is Ethernet Address ?

0 Answers   HCL,






What is Serial Poart ?

0 Answers   HCL,


What the difference between the request-response pattern and the duplex pattern?

1 Answers  


What is the cycle of Installing patches.....

0 Answers   HP,


What is the definition of Web Server ?

0 Answers  


What is IP Address?

3 Answers  


In what order do we have to catch the exceptions: TimoutException, FaultException,

0 Answers  


What is Splitter?

0 Answers   Prime Focus,






Categories