Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the command to replace a cell's formula with it's value?
What is the command to strip a cell of it's formula, leaving the formula's
value? I believe it is F2 something... |
#2
|
|||
|
|||
On Sun, 17 Jul 2005 21:37:02 -0700, "Cindy"
wrote: 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- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#3
|
|||
|
|||
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" wrote: On Sun, 17 Jul 2005 21:37:02 -0700, "Cindy" wrote: 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- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#4
|
|||
|
|||
On Sun, 17 Jul 2005 21:50:03 -0700, "Cindy"
wrote: 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- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#5
|
|||
|
|||
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 "Mangus Pyke" wrote in message ... On Sun, 17 Jul 2005 21:50:03 -0700, "Cindy" wrote: 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- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#6
|
|||
|
|||
"Cindy" skrev i en meddelelse
... 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. -- Best Regards Leo Heuser Followup to newsgroup only please |
#7
|
|||
|
|||
Hit F2, then F9, then enter.
F2 to edit, F9 to calculate. Cindy wrote: What is the command to strip a cell of it's formula, leaving the formula's value? I believe it is F2 something... -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the command to replace a cell's formula with it's value?
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? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the command to replace a cell's formula with it's value?
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 V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "sgeer" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
How do i get a formula for word recognition in cells | Excel Discussion (Misc queries) | |||
Cells displays formula, not results | Excel Worksheet Functions | |||
How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |