0

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?

Improve this question

3 Answers 3

Reset to default
1

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

Improve this answer
1

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

Improve this answer
1

Another way of doing the same as above:

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

Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .