in xl..how to delete data and leave formulas

  • Thread starter Thread starter Graywolf
  • Start date Start date
G

Graywolf

have multiple sheet workbook with formulas that refer to previous work sheet.
Need to delete data with out erasing formuas ???
 
hi
select the sheet you want to delete data. press the F5 key to bring up the
goto dialog. click the special button. form the list select constrants. ok
all data that is not a formula should be high lighted. press the delete key.
data gone, formulas still there.

Regards
FSt1
 
Back
Top