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

1 Answers  


What are FMSO Roles? List them...

4 Answers   DynPro,


What is Taskbar?

0 Answers   CMS,


What is Docking Station ?

0 Answers   Cummins,


what are the command utility 's using in fail over cluster?

2 Answers   HP,






What is URL Forwarding ?

0 Answers   Quexst,


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

1 Answers   eClerx,


What is the difference between Win2k Server and Win2k3?

6 Answers   eTrade, Wipro,


i face a big prob in ms outlook 2k3 when i send a mail to others person but when go to sent itms there not show cc & To format whats prob how to trouble it?Plz reply hurry

4 Answers  


What is Self-Installation Kit ?

0 Answers  


What is Unicode?

0 Answers   Maersk,


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

2 Answers  






Categories