I want to delete the "values' in cell , but not want to delete the formula behind that cell , how can i delete the value ?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
.In excel > >> Delete command
Posted by:
FITAH MOHAMED
18-May-2015

Microsoft Excel

Question added by Usman Iqbal , Audit senior , Hyder bhimji , business center faisalabad
Date Posted: 2013/10/07

Upvote (0) Views (10) Followers (0) Answers (4) Report Question

Write an Answer
Register now or log in to answer.

4 Answers

by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

delete the source cells from where the formula is taking values.

Downvote Reply () Report

by Usman Iqbal , Audit senior , Hyder bhimji , business center faisalabad

Source cell has the value and Formula?

Downvote Reply () Report

by Ahmad Yar , Partner , Jsir Khaybar Typing

you should delete the source cells from which the formula has taken values.

Downvote Reply () Report

Mohammed Haseeb Musba

by Mohammed Haseeb Musba , Management Accountant / Senior Financial Analyst , International Food Services

Do not delete the value of the cell. But Multiply the same by zero

Downvote Reply () Report

Popular Searches

Sales Executive Jobs Engineers Jobs Engineering Technicians Jobs Accountant Jobs Driver Jobs

Write Your Answer

More Questions Like This

In Excel how to count NON-BLANK cells having ONLY Non-numeric values in a range?
Top Answer: <h3>many ways </h3> <h3>for example</h3> <h3>say : values are existed in co ... See More

Answers (9)
Tricky question in Excel If you have a date cell, and want to make other cell contains a fixed day & month, but changeable year matches the 1st cell?
Top Answer: <p>Try this formula: ="6/4/"&YEAR(A1) </p> <p>Note: A1 should be t ... See More

Answers (14)
How can I get the value for aggregate query in Yii if the aggregate value not an attribute on the activerecord class?
Top Answer: <p>You cant access the value unless its an attribute on the model (or) and attribute on the table,& ... See More

Answers (1)
"If you can't convince them, confuse them"- do marketing and sales departments follow this quote these days?
Top Answer: <p>Not my sales & marketing management. RESPECT { Customer Service and Customer Care} is a ... See More

Answers (14)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.