how to delete datas without deleting formulas
You sure?
I would think that there would be headings/instructions--cells with values that
you don't want to touch.
But if you select your range to clear (all cells if you really want)
edit|goto|special
Select constants
and click ok
then hit the delete key on the keyboard.
Excel Dubai wrote:
Dear Excel Experts,
I would like to select a full sheet and only delete datas from it without
touching the formulas.
Please help.
Regards,
Exel Dubai
--
Dave Peterson
|