I need to delete the values in some cells,
 

but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help

I need to delete the values in some cells,
 

Skip wrote:
but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help

Maybe this is what you want. Select the entire range of cells.

Edit / Go To / Special... / Constants / OK / Delete

If not, provide more details.

I need to delete the values in some cells,
 

On Nov 4, 9:16*am, Glenn wrote:
Skip wrote:
but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help

Maybe this is what you want. *Select the entire range of cells.

Edit / Go To / Special... / Constants / OK /Delete

If not, provide more details.

Glenn< I tried your idea, no luck.
I got a no cell selected box.
Skip

I need to delete the values in some cells,
 

Skip wrote:
On Nov 4, 9:16 am, Glenn wrote:
Skip wrote:
but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help
Maybe this is what you want. Select the entire range of cells.

Edit / Go To / Special... / Constants / OK /Delete

If not, provide more details.

Glenn< I tried your idea, no luck.
I got a no cell selected box.
Skip



Then try my other suggestion.

I need to delete the values in some cells,
 

Maybe this is what you want. *Select the entire range of cells.

Edit / Go To / Special... / Constants / OK /Delete

Glenn< I tried your idea, no luck.
I got a no cell selected box.
Skip

Then try my other suggestion.-

I am sorry, what is your other idea?

I need to delete the values in some cells,
 

Skip wrote:
Maybe this is what you want. Select the entire range of cells.
Edit / Go To / Special... / Constants / OK /Delete
Glenn< I tried your idea, no luck.
I got a no cell selected box.
Skip
Then try my other suggestion.-

I am sorry, what is your other idea?


"provide more details"