| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - how do I delete data but not formulae?
I've got quite a complicated workbook, and have entered test data to check
it. I now want to delete the test data, but not the various formulae. I think I read somewhere in a magazine that this was possible, but can't now find how. Any thoughts gratefully received. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - how do I delete data but not formulae?
Edit Goto Special and check Constants
Edit Clear Contents -- Gary''s Student - gsnu200739 "AlanStPaul" wrote: I've got quite a complicated workbook, and have entered test data to check it. I now want to delete the test data, but not the various formulae. I think I read somewhere in a magazine that this was possible, but can't now find how. Any thoughts gratefully received. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - how do I delete data but not formulae?
Great. Just the job. Thanks.
"Gary''s Student" wrote: Edit Goto Special and check Constants Edit Clear Contents -- Gary''s Student - gsnu200739 "AlanStPaul" wrote: I've got quite a complicated workbook, and have entered test data to check it. I now want to delete the test data, but not the various formulae. I think I read somewhere in a magazine that this was possible, but can't now find how. Any thoughts gratefully received. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - how do I delete data but not formulae?
You are quite welcome!
Have a pleasant day! -- Gary''s Student - gsnu200739 "AlanStPaul" wrote: Great. Just the job. Thanks. "Gary''s Student" wrote: Edit Goto Special and check Constants Edit Clear Contents -- Gary''s Student - gsnu200739 "AlanStPaul" wrote: I've got quite a complicated workbook, and have entered test data to check it. I now want to delete the test data, but not the various formulae. I think I read somewhere in a magazine that this was possible, but can't now find how. Any thoughts gratefully received. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete cell values withour deleting cell formulae | Excel Discussion (Misc queries) | |||
| How to delete cell values without affecting cell formulae | Excel Discussion (Misc queries) | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| Is it possible to make excel NOT process non-numeric cell data in formulae | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Hybrid Mode
