ExcelBanter - Getting Values in Formula Bar

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Getting Values in Formula Bar (https://www.excelbanter.com/excel-discussion-misc-queries/191504-getting-values-formula-bar.html)

Ravi

Getting Values in Formula Bar

How to get the values in formula bar without affecting to the formula

Harald Staff[_2_]

Getting Values in Formula Bar

Impossible, sorry. Formula bar shows formula.
If I understand the question that is...

Best wishes Harald

"Ravi" wrote in message
...
How to get the values in formula bar without affecting to the formula

Gord Dibben

Getting Values in Formula Bar

Formula bar displays what is in the cell.

If a formula, it will show.

Gord Dibben MS Excel MVP

On Tue, 17 Jun 2008 05:50:01 -0700, Ravi wrote:

How to get the values in formula bar without affecting to the formula

jaf

Getting Values in Formula Bar

Hi Ravi,
Highlight part of the formula with the mouse or cursor keys and press F9 to
see the value.
If you hit the enter key the portion highlighted will be replaced by the
value.
To prevent this, hit the escape key to reset the formula.

John

"Ravi" wrote in message
...
How to get the values in formula bar without affecting to the formula

All times are GMT +1. The time now is 09:37 AM.