| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you copy a cell without the formula?
I want to copy cells without thier formulas.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you copy a cell without the formula?
Copy-Paste special? Just paste what yiou want.
"Annieexcel" wrote in message ... I want to copy cells without thier formulas. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you copy a cell without the formula?
- copy the desired range of cells.
- select the cell you want your copied cells to be placed. - EditPaste Special, Values, OK -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "Annieexcel" wrote: I want to copy cells without thier formulas. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you copy a cell without the formula?
Copy then EditPaste SpecialValuesOKEsc
Gord Dibben MS Excel MVP On Sun, 18 Mar 2007 15:35:28 -0700, Annieexcel wrote: I want to copy cells without thier formulas. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Formula From Another Cell | Excel Discussion (Misc queries) | |||
| VBA to Copy Cell Value Without Formula | Excel Discussion (Misc queries) | |||
| Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
| Copy cell formula help | Excel Discussion (Misc queries) | |||
| When I copy a formula to another cell, I get the value of the ori. | Excel Worksheet Functions | |||
Linear Mode
