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
Where will i get Microsoft Office 2010 with License Key free download ?
How do I know if microsoft edge is installed?
How do you run microsoft programs on a mac?
Axapta interview in wipro: join types? delete actions? posting for sales order what class used? write method? insert ,update methods? diff between inner join and exist join? diff between doupdate and update method? ,, ,, validate write and validate field method?
Can I delete old microsoft visual c++ files?
Shortcut keys for debugging in visual studio?
What is Security Certificate ?
Can I set folder qouta on server 2003 SP1 enterprise edition setup as file server? Can I use FSRM on this or do I really need to update my server to 2003 R2? Thanks.
Explain the file needed to boot win-xp?
Are the addresses, the bindings, the contracts unique between services?
Is microsoft visio viewer free?
How does xaml relate to other web service standards? : xaml
What is CPU (Central Processing Unit)
How do I stop microsoft compatibility telemetry?
What is the difference between microsoft edge and internet explorer?