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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain session variables?

578


Is microsoft shutting down?

527


What is microsoft c register server?

534


What is USB (Universal Serial Bus) ?

1365


Shortcut keys for debugging in visual studio?

595






Where is microsoft recycle bin located?

617


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

1703


What is DDR (Double Data Rate)

1550


What is Shareware ?

1485


Is apple the same as microsoft?

559


What is microsoft register server?

552


How do I stop microsoft compatibility telemetry?

551


What are the new features in visual studio 2017?

604


What the difference between the SoapUi utility and the VS2008 test functionality used for the Web-service testing?

2806


What is Docking Station ?

1426