What is the command to replace a cell's formula with it's value?

[Guest]

What is the command to strip a cell of it's formula, leaving the formula's
value? I believe it is F2 something...

 

[Mangus Pyke]

What is the command to strip a cell of it's formula, leaving the formula's
value? I believe it is F2 something...

I always copy it, then go to Edit --> Paste Special and select Values

MP-

 

[Guest]

Thank you! (Is there also an F2 command? It's been literally years since
I've used Excel and just getting back into it.)

Cindy

 

[Mangus Pyke]

Thank you! (Is there also an F2 command? It's been literally years since
I've used Excel and just getting back into it.)

If there is, I have not stumbled across it.

I usually Ctrl-C the cell or range, and then press Alt, E, S, V..

Habit makes it fast enough that I haven't looked for a shortcut for
this particular task.

Wouldn't mind knowing it if there is one-

MP-

 

[Biff]

Function key F2 starts Edit Mode. It's the same as double clicking in a
cell.

I use copy/paste special/values so often I put the paste values button on my
toolbar.

Biff

 

[Leo Heuser]

Thank you! (Is there also an F2 command? It's been literally years since
I've used Excel and just getting back into it.)

Cindy

Cindy

Another option:

Select the cell (range) and *right* drag it (cursor is four arrows) one cell
away holding the mouse button and then back to the original cell (range).
Release the right mouse button and choose "Copy only value to here"
(or similar). Tested in Excel 2003.

 

[Dave Peterson]

Hit F2, then F9, then enter.

F2 to edit, F9 to calculate.

 

[sgeer]

Without regard to paste special and the F2/F9 approach, why would there not
be a function that returns the value of a cell for use in other formulas?

The only solution appears to be a script.

For example if you want to check for a value in a formula, or if you want to
cross multiple work sheets with a list controled index, or if you want to use
conditional statements based on the value derived by formula?

 

[sgeer]

Without regard to paste special and the F2/F9 approach, why would there not
be a function that returns the value of a cell for use in other formulas?

The only solution appears to be a script.

For example if you want to check for a value in a formula, or if you want to
cross multiple work sheets with a list controled index, or if you want to use
conditional statements based on the value derived by formula?

 

[Bernard Liengme]

Not sure I follow.
Let A1 = 2 and B1 =3
So C1 with formula =A1+B1 will return 5
I can test the value in C1: in D1 enter =IF(C1=5,"it is five", "it is not
five")
But you could mean something else.
Care to expand your question with an example?
best wishes

 

[Bernard Liengme]

Not sure I follow.
Let A1 = 2 and B1 =3
So C1 with formula =A1+B1 will return 5
I can test the value in C1: in D1 enter =IF(C1=5,"it is five", "it is not
five")
But you could mean something else.
Care to expand your question with an example?
best wishes