in xl..how to delete data and leave formulas

G

Graywolf

have multiple sheet workbook with formulas that refer to previous work sheet.
Need to delete data with out erasing formuas ???
 
F

FSt1

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
 
Top