| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to copy a column of values, NOT the formula
Highlight the range of cells in question; from menu click Edit Copy.
Place the cell pointer at the other location and from the menu click Edit Paste Special; select Values, and click OK. That answers your specific question (assuming you do not actually mean "absolute value", the math term, and instead mean "the calculated value"), but are you aware you can sort a range of calculated cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy Values Only, Not Formula? | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Match formula that pulls unique values from another column? | Excel Discussion (Misc queries) | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Threaded Mode
