How can I fix values in cells calculated by formula in Excel

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

Guest

I have been given a very large spreadsheet I want to manipulate but most of
the cells have values created by formulas and I'm having difficulty moving
and rearranging rows without losing data. It would be helpful if I could just
freeze the values in the cells and then move the data around. I can't find a
simple way of doing this - can anyone help please?
 
This might work for you:

1. Select all of your data
2. Edit --> Copy
3. Move to a new blank worksheet (or unused area of same worksheet)
4. Edit --> Paste Special
5. Select "Values"
6. OK

HTH,
Elkar
 

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

Scrabble Value calculation for Welsh words 0
Excel formula, sum the value cell and if empty cell left blank 0
formula finds values in apparently blank cells 1
Formulas displayed in cell rather than calculated values? 4
Formula in excel 3
Return of value when copying a formula 4
CountIf previous cell formula 0
Calculate row/column number in reference formula 2

Back
Top