| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
delete data, keep formulas
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? -- elviejo41 ------------------------------------------------------------------------ elviejo41's Profile: http://www.excelforum.com/member.php...o&userid=23566 View this thread: http://www.excelforum.com/showthread...hreadid=393878 |
|
#2
|
|||
|
|||
|
You can delete constants like this
Ctrl A (twice in Excel 2003) F5 Special Constants OK Press Delete -- Regards Ron de Bruin http://www.rondebruin.nl "elviejo41" wrote in message ... 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? -- elviejo41 ------------------------------------------------------------------------ elviejo41's Profile: http://www.excelforum.com/member.php...o&userid=23566 View this thread: http://www.excelforum.com/showthread...hreadid=393878 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete data in worksheet, but not the associated formula | Excel Worksheet Functions | |||
| Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Formulas in source data | Charts and Charting in Excel | |||
Linear Mode
