software

I have a column of derived data. I want to copy the absolute value of the
cells, not the formulas, to another place on the spreadsheet so I can sort
them from greatest to least.

Select the Values from cells, click Copy. Move to another location,
right-click choose Paste Special - Values (can also use Edit - Paste Special).

Let us know if the information is helpful.

quot;Joe Gquot; wrote:

gt; I have a column of derived data. I want to copy the absolute value of the
gt; cells, not the formulas, to another place on the spreadsheet so I can sort
gt; them from greatest to least.

Highlight the range of cells in question; from menu click gt;Edit gt;Copy.
Place the cell pointer at the other location and from the menu click
gt;Edit gt;Paste Special; select Values, and click OK.

That answers your specific question (assuming you do not actually mean
quot;absolute valuequot;, the math term, and instead mean quot;the calculated
valuequot;), but are you aware you can sort a range of calculated cells?