View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Delete contents deletes all data and formulas

Hi,

You could try this

tap F5 - Special - Constants - OK

and if that selects the data you want to delete then tap the delete key
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"tdhcrr" wrote:

When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?