Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting cell data without deleting formula
In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j It seems that "contents" include data and formula, but I can't seem to find a way of separating one from the other. Tom -- remove .spoo to reply by email |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting cell data without deleting formula
A cell cannot contain data and a formula.
The formula is the actual cell contents, and what the formula is constructed to return is what the cell displays. If the formula depends on the contents of other cells (=A1+B1), you could remove the data in those cells, unless ... of course ... if they *also* contain other formulas. If the formula is self-contained (=100+25), then there is no way to remove the data without removing the formula. SO ... exactly what are you looking to accomplish? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Tom Hall" wrote in message ... In Excel 2003, is it possible to delete the contents of a cell without also deleting the formula?j It seems that "contents" include data and formula, but I can't seem to find a way of separating one from the other. Tom -- remove .spoo to reply by email |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting cell data without deleting formula
Can you clarify how you differentiate cell formulas from cell data when
referring to cell contents? An example would probably help. *********** Regards, Ron XL2002, WinXP "Tom Hall" wrote: In Excel 2003, is it possible to delete the contents of a cell without also deleting the formula?j It seems that "contents" include data and formula, but I can't seem to find a way of separating one from the other. Tom -- remove .spoo to reply by email |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting cell data without deleting formula
If you have a worksheet with a mixture of data and formulae and want to clear
out the data, but leave the formulae alone then: Edit Go To Special... and click Constants and then OK this selects the data, but not the formulae Edit Clear All clears out the data -- Gary's Student "Tom Hall" wrote: In Excel 2003, is it possible to delete the contents of a cell without also deleting the formula?j It seems that "contents" include data and formula, but I can't seem to find a way of separating one from the other. Tom -- remove .spoo to reply by email |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting cell data without deleting formula
On Sat, 28 Oct 2006 11:30:01 -0700, Gary''s Student
wrote: If you have a worksheet with a mixture of data and formulae and want to clear out the data, but leave the formulae alone then: Edit Go To Special... and click Constants and then OK this selects the data, but not the formulae Edit Clear All clears out the data Thanks! The others who replied pointed out a flaw in my thinking, but you've actually given me what I was looking for. Thanks again! Tom -- remove .spoo to reply by email |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |