Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.