View Single Post
  #3   Report Post  
William
 
Posts: n/a
Default

Hi

1. Select one cell on the relevant worksheet.
2. Press F5 and select "Special"
3. Select "Constants" from the dialog box.
4. Select "OK"
5. Hit the "Delete" button on your keyboard.

--

-----
XL2003
Regards

William



"
. com wrote in message
...
When I choose the option to clear, my formulas are deleted too. Is there
a
way to delete values only?