I want to copy a column of values, NOT the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Excel - Want to sort by formula value without losing formula 4
Converting a formula to data 3
Paste Special Values 2
How to make a column of formulas all ROUND 1
Copying Formulas 2
Excel - formula last data cell 2
Excel formula to copy/paste formula needed please. 4

Back
Top