Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete cell values withour deleting cell formulae
I wish to use a previous years excel sheet but i need to blank out all
entered and caluclated values present. If i do a complete delete i will lose all the formulae that have vbeen inserted into certain formulae. How can i delete all values withour the formulae getting deleted |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete cell values withour deleting cell formulae
One option is Edit/ Goto/ Special/ Constants, then delete.
-- David Biddulph "perfection" wrote in message oups.com... I wish to use a previous years excel sheet but i need to blank out all entered and caluclated values present. If i do a complete delete i will lose all the formulae that have vbeen inserted into certain formulae. How can i delete all values withour the formulae getting deleted |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete cell values withour deleting cell formulae
Do you want to hide the calculated values? Suppose cell B1 is based on A1.
Delete the contents of A1, and change the formula in B1 from =<whatever to =IF(LEN(A1)=0,"",<whatever) You might consider some kind of unique formatting (e.g. light blue shading) in A1 and other user-input cells so the user knows where to enter inputs. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "perfection" wrote in message oups.com... I wish to use a previous years excel sheet but i need to blank out all entered and caluclated values present. If i do a complete delete i will lose all the formulae that have vbeen inserted into certain formulae. How can i delete all values withour the formulae getting deleted |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete cell values withour deleting cell formulae
On Jun 18, 10:56 am, perfection wrote:
I wish to use a previous years excel sheet but i need to blank out all entered and caluclated values present. If i do a complete delete i will lose all the formulae that have vbeen inserted into certain formulae. How can i delete all values withour the formulae getting deleted David You did understand what i need to do but this merely locates cells that have formulae and highlights them. how do delete en masse w/out distubing the formulae cells |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete cell values withour deleting cell formulae
You seem to have replied to your own message. If you intended to reply to
my message, I'll repeat the content he "One option is Edit/ Goto/ Special/ Constants, then delete." Did you try what I suggested? It doesn't highlight the cells that have *formulae*, it highlights the cells that have constant *values*, then if you hit delete it will delete those values, and leave the formulae in place, which is what you asked for. Perhaps you need to re-read the suggestion and try again? -- David Biddulph "perfection" wrote in message oups.com... David You did understand what i need to do but this merely locates cells that have formulae and highlights them. how do delete en masse w/out distubing the formulae cells On Jun 18, 10:56 am, perfection wrote: I wish to use a previous years excel sheet but i need to blank out all entered and caluclated values present. If i do a complete delete i will lose all the formulae that have vbeen inserted into certain formulae. How can i delete all values withour the formulae getting deleted |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete cell values withour deleting cell formulae
David wrote "One option is Edit/ Goto/ Special/ Constants, then delete."
Note the word "constants" not formulas. Gord Dibben MS Excel MVP On Mon, 18 Jun 2007 12:45:51 -0700, perfection wrote: On Jun 18, 10:56 am, perfection wrote: I wish to use a previous years excel sheet but i need to blank out all entered and caluclated values present. If i do a complete delete i will lose all the formulae that have vbeen inserted into certain formulae. How can i delete all values withour the formulae getting deleted David You did understand what i need to do but this merely locates cells that have formulae and highlights them. how do delete en masse w/out distubing the formulae cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete cell values without affecting cell formulae | Excel Discussion (Misc queries) | |||
Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
Delete values from cell automatically | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |