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

Provide some Vlookup Examples?

895


Types of DNS Servers?

1703


Do I need microsoft visual c++ 2005 redistributable?

553


What is Tunnel or Tunneling?

1370


What is the purpose of a microsoft account?

521






What is SCSI (Small Computer System Interface)?

1514


which is the best ineptitude for MSBI in hyderabad?

2469


Is microsoft autoupdate a virus?

533


Who is supporting xaml? : xaml

609


How to restore deleted OU in DC ?

1407


How is xaml used? : xaml

578


How do I get my microsoft store back?

506


What is a solution explorer in visual studio?

579


difference between windows 98, windows 2000 and windows XP

2508


How are dependent the app.config and the machine.config files?

1713