delete data, keep formulas

E

elviejo41

I want to develop a worksheet that has my formulas only, so that I can
copy the formulas to another new sheet. How can I delete the data
without deleting the formulas?
 
R

Ron de Bruin

You can delete constants like this

Ctrl A (twice in Excel 2003)
F5 Special
Constants
OK
Press Delete
 

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

Deleting blank rows with formulas in them 7
Delete contents deletes all data and formulas 2
Paste contents, but keep formula of destination 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Special Pasting a work book with many sheets and formulas 2
Excel Moving data to sheet2 from sheet1 0
COPY WORKBOOK KEEPING FORMULAS AND TEMPLATES, BUT LOSING THE DATA 5
how can I Delete data in a spread sheet and keep formulas 1

Top