Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to copy a group of cell results with out pulling the formulas over to a new worksheet ?

what happens now is it copies the formulas with the =Sum(workbook!Formula) to new workbook, I would like only the result [443] not the formula pointing to another workbook - is this possible?

share|improve this question
up vote 1 down vote accepted

Select and copy what you want. Choose where you want to paste it. RIGHT click, then choose Values from the paste options.

enter image description here

share|improve this answer

Mark the cells, copy them, go to the place where you want to paste them, right-click, choose Paste-Special => select 'values' and submit.

share|improve this answer

Another way of doing the same as above:

ALT, E, S, V , in sequence (not simultaneous).

share|improve this answer
Thanks - I didn't know that! – Andrew Sep 6 '12 at 21:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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