Paste Value Formula

T

Tim

In a spreadsheet I am trying to return values for F9 formulas but keep the
Excel formulas that are in the same range? THx.
 
D

Dave Peterson

I'm not sure I understand.

You can have the value in the cell or the formula in the cell (which evaluates
to a value).

What do you want to do?
 
J

JoeU2004

Tim said:
In a spreadsheet I am trying to return values for F9 formulas but keep the
Excel formulas that are in the same range? THx.
Click to expand...

If you are saying that you are using F9 for looking at the values of parts
of a formula in the Formula Bar, and you want to retain the formula when you
are done, the key thing is to press Esc, not Enter, when you are done
looking at the values.
 
Top