| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Values Permanent
I have columns that have many columns with values that are calculated. I
would like to make these calculated values permanent. i.e. Column AA is a calculated from 3 other columns. I want Column AA just to be calculated value and not the formula anymore. When I try to just copy and paste, it copies the formula, which I do not want. Thanks! Efrain |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making Values Permanent
Use copy - paste special - paste value
Mike "Efrain" wrote: I have columns that have many columns with values that are calculated. I would like to make these calculated values permanent. i.e. Column AA is a calculated from 3 other columns. I want Column AA just to be calculated value and not the formula anymore. When I try to just copy and paste, it copies the formula, which I do not want. Thanks! Efrain |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making Values Permanent
copy
paste VALUES -- Don Guillett SalesAid Software "Efrain" wrote in message ... I have columns that have many columns with values that are calculated. I would like to make these calculated values permanent. i.e. Column AA is a calculated from 3 other columns. I want Column AA just to be calculated value and not the formula anymore. When I try to just copy and paste, it copies the formula, which I do not want. Thanks! Efrain |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making Values Permanent
Efrain, copy, paste special, values
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Efrain" wrote in message ... I have columns that have many columns with values that are calculated. I would like to make these calculated values permanent. i.e. Column AA is a calculated from 3 other columns. I want Column AA just to be calculated value and not the formula anymore. When I try to just copy and paste, it copies the formula, which I do not want. Thanks! Efrain |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a column of numbers created from a formula permanent. | Excel Worksheet Functions | |||
| assign permanent colors to bars/values in a pivot chart | Charts and Charting in Excel | |||
| Copying cell values once and then making them static | Excel Worksheet Functions | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| making used values fall from a list | Excel Discussion (Misc queries) | |||
Linear Mode
