1. Categories >> Software >> Microsoft Related >> Microsoft Related AllOther
  2. Suggest New Category

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

Question Posted / mohanraj

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

How do I stop microsoft compatibility telemetry?

0 Answers  

What is the difference between Win2k Server and Win2k3?

6 Answers   eTrade, Wipro,

What is USB (Universal Serial Bus) ?

0 Answers  

How do I get the microsoft edge icon on my desktop?

0 Answers  

Shortcut keys for debugging in visual studio?

0 Answers  




What is Upload

0 Answers   Quexst,

How does xaml relate to service description languages (wsdl, xmi)? : xaml

0 Answers  

Where was microsoft founded?

0 Answers  

What is UDP (User Datagram Protocol)?

0 Answers  

Can you explain about browser link?

0 Answers  

What is XT (eXtended Technology)

0 Answers   Baidu, CMS,

Can I disable microsoft onedrive?

0 Answers  

For more Microsoft Related AllOther Interview Questions Click Here
Categories