I have a sheet that includes data pulled together from other sheets using VLOOKUP and other formulas. I want to copy columns directly into another sheet for someone else to use and manipulate, but I can't copy the sheet as the formulas no longer work and all boxes are filled with #NA.

Is it possible to somehow turn the data shown (but where a formula lies underneath) into actual data (so that the cell contains only the number shown, not a formula)?

  • 1
    Can you not use copy-and-paste-values?
    – ale
    Commented Aug 22, 2017 at 15:43

1 Answer 1


Yes. Either Copy (Ctrl+C) and then, having selected your destination, Edit > Paste special > Paste values only, or when pasting Ctrl+Shift+V.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.