Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing cell that has a formula in it, but displaying content and
how do you Edit a cell that has a formula in it, by displaying content and
not the formula it has in it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing cell that has a formula in it, but displaying content and
If you want to replace a formula by its result, Copy, then Edit/ Past
Special/ Values. -- David Biddulph "thechad987" wrote in message ... how do you Edit a cell that has a formula in it, by displaying content and not the formula it has in it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing cell that has a formula in it, but displaying content and
Reading between the lines in your post, what exactly is it that you want/need
to edit, based on the value that is currently returned by the formula? It may be possible to enhance the existing formula to return the exact value that you're after, hence avoiding your need to edit? -- Max Singapore --- "thechad987" wrote: how do you Edit a cell that has a formula in it, by displaying content and not the formula it has in it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying content of a cell somewhere on the chart | Charts and Charting in Excel | |||
TextBox control stops displaying linked cell content | Excel Discussion (Misc queries) | |||
How to show cell content in the toolbar for editing? | Excel Worksheet Functions | |||
editing a cell that has a formula in it | Excel Discussion (Misc queries) | |||
displaying borders when editing the formulas | Setting up and Configuration of Excel |