View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Clearing Contents

Hi Amanda

Press F5 from worksheet. From Goto window select Constants. Select the
option you needed. Hit OK to select all cells. Press delete key,.

If this post helps click Yes
---------------
Jacob Skaria


"AMANDA" wrote:

How can I highlight and clear contents but not formulas