Thread: keep formula delete contents
View Single Post
  #4  
Old May 4th, 2010, 04:46 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
  
Posts: 20,252
Default keep formula delete contents
F5SpecialConstantsOK

EditDelete

Uncheck "Text" if you want to keep data like titles.


Gord Dibben MS Excel MVP

On Mon, 3 May 2010 16:19:01 -0700, carspjcars
wrote:

I'm trying to set up a template in Excel. I wish to keep the formula but
delete contents, so i can us the same sheet again.