| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to prevent a formula from displaying ?
Want to prevent from displaying a formula without protecting the sheet.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to prevent a formula from displaying ?
You could turn off the formula bar, which would supress formula's from
displaying. TOOLS/OPTIONS, click the VIEW tab if necessary and turn off the checkbox "Formula Bar". However, they could still see the formula by pressing the F2 Edit key, or double clicking on the cell itself. -- Kevin Backmann "Hecwill" wrote: Want to prevent from displaying a formula without protecting the sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
| Displaying in a cell the formula from another cell | Excel Discussion (Misc queries) | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Linear Mode
