Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show value of cell in formula bar instead of formula
Is it possible to display the value of a cell in the "formula Bar" rather
than its formula without password protecting the worksheet? for eg: A 1 20 2 30 3 50 =SUM(A1:A2) Shown in formula bar Would like to see 50 Shown in formula bar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show value of cell in formula bar instead of formula
Perhaps just consider killing the formulas / freeze the values via copy
paste special as values, then it'll show only the values in the formula bar. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "shapiro" wrote: Is it possible to display the value of a cell in the "formula Bar" rather than its formula without password protecting the worksheet? for eg: A 1 20 2 30 3 50 =SUM(A1:A2) Shown in formula bar Would like to see 50 Shown in formula bar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show value of cell in formula bar instead of formula
You can view the value in the formula bar. But the cell will loose the Object
Linking and Embedding (OLE) and Dynamic Data Exchange DDE funtionality. The values will just display as an independent cell value. Any change change in the source document will not reflect any changed value. If this is what you require then you can copy and paste special and then click Values. The formula bar will display only display the value. Important: You will have to create the function(s) for each cell values again. Challa Prabhu "shapiro" wrote: Is it possible to display the value of a cell in the "formula Bar" rather than its formula without password protecting the worksheet? for eg: A 1 20 2 30 3 50 =SUM(A1:A2) Shown in formula bar Would like to see 50 Shown in formula bar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to show a formula in a different cell | Excel Worksheet Functions | |||
need sum to show instead of formula in cell | Excel Discussion (Misc queries) | |||
How to show the formula of another cell | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |