Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

Microsoft Excel
user-image
Question added by Usman Iqbal , Audit senior , Hyder bhimji , business center faisalabad
Date Posted: 2013/10/07
Upvote (0) Views (9) Followers (0) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

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

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

Source cell has the value and Formula?

Ahmad Yar
by Ahmad Yar , Partner , Jsir Khaybar Typing

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

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

Write Your Answer
More Questions Like This