Show value of cell in formula bar instead of formula

G

Guest

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
 
G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Formula Bar - display of content 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Display cell value 5
Cell contents in formula bar 9
Excel Formula Bar Time Display Format 2
Displaying results in formula bar when cell is hidden 1
excel displays formula instead of value in one cell 3

Top