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
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.
if Paint Application shows error masg what we do?
Can I delete microsoft onedrive?
Why my microsoft store is not opening?
What are the different activities we can do with visual studio?
What languages can you code in visual studio?
What are microsoft tools?
What are the different refactoring options in visual studio?
What microsoft means?
What is SCSI (Small Computer System Interface)?
Explain why do we use option explicit?
Explain the difference between web service and web application?
How does xaml relate to other web service standards? : xaml
What is VGA (Video Graphics Array)?
How do I get the microsoft edge icon on my desktop?