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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
Linking to Access data without destroying formulas 16
Excel question ? 5
how to clear data 3
copied formulas refer to destination sheet not source sheet 2
Excel shortcut options 0
Count the columns from one sheet and paste it in another sheet 0
Excel Sorting Breaks Formulas 1

Top