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

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

Question Posted / mohanraj

2 Answers
5779 Views
I also Faced
E-Mail Answers

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

Explain session variables?

0 Answers

What is URL Forwarding ?

0 Answers Quexst,

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

0 Answers

Is there any other options to create a site definition for MOSS other than using onet.xml.

0 Answers Zensar,

What is microsoft wer?

0 Answers

What is Computer Memory?

0 Answers CMS,

What is SDRAM (Synchronous Dynamic Random Access Memory) ?

1 Answers Wipro,

How Many Instances Of A Role Should Be Deployed To Satisfy Azure Sla (service Level Agreement) ? And What's The Benefit Of Azure Sla?

0 Answers Microsoft,

What are microsoft tools?

0 Answers

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

1 Answers HP,

which is the best ineptitude for sqlserver dba in hyderabad?

0 Answers Baidu,

How do I stop microsoft teams from opening on startup?

0 Answers

For more Microsoft Related AllOther Interview Questions Click Here