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

Cell data entering slow! 0
Data consolidation 0
Embed the same Excel multiple times 0
Copying Portions of Data 0
Need Help with a VBA subroutine 0
Linking to Access data without destroying formulas 16
How To Rapidly Copy Formulas? 0
How to sync OL365 contacts and calendar to iPhone without iTunes? 1

Top