Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting formulas
How do I clear a column of data only without erasing the formulas?
Similarly, I have several sections of subtotals, where the data being subtotaled is formula driven. Can I protect the subtotal formulas so that I can paste special values only without pasting over the subtotals? |
#2
|
|||
|
|||
Ellen
I'm not sure what you're asking. A formula or a subtotal gives a result based on the contents of one or more cells elsewhere. To clear the column, you need to delete the data in the other cells. Am I missing something ? Regards Trevor "EllenSwarts" wrote in message ... How do I clear a column of data only without erasing the formulas? Similarly, I have several sections of subtotals, where the data being subtotaled is formula driven. Can I protect the subtotal formulas so that I can paste special values only without pasting over the subtotals? |
#3
|
|||
|
|||
You must clear the cells from where the formulas are obtaining their basic
values to perform their calculations on. Click on each formula, then do Tools Auditing Trace Precedents, will show you where those cells are for each formula. You could then collect them all into a non-contiguious Range, and erase them all at once, with F5 choose the rangename right-click on one of the cells clear contents. hth Vaya con Dios, Chuck, CABGx3 "EllenSwarts" wrote in message ... How do I clear a column of data only without erasing the formulas? Similarly, I have several sections of subtotals, where the data being subtotaled is formula driven. Can I protect the subtotal formulas so that I can paste special values only without pasting over the subtotals? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |