I have a huge project that involves excel, and I have the following problem: I want to copy certain lines (containing data that was calculated through a formula from given data) and paste them in a separate worksheet, but for whatever reason, instead of those values it gives me gibberish (#ref.) How do I fix this?
2006-12-07 21:02:04 · 6 answers · asked by D 2 in Computers & Internet ➔ Software
This is because cells that are referenced in the formula are not being copied to the new worksheet. If all you care about are the numbers, then this is an easy fix. When you paste, go to Edit--> Paste Special, and then select the "Numbers Only" or simlar option. It will paste all the numerical values from the cells instead of copying the formulas you entered.
2006-12-07 21:12:22 · answer #1 · answered by shortstuf_2 3 · 0⤊ 0⤋
You could use Paste Special as others have said, but if the calculations change in the original sheet, you'll need to Paste Special the new values.
A better alternative might be to link the cells. Open both spreadsheets, and select a cell in the new sheet and type '=', then select the cell from the original sheet that you want there and hit the enter key. Now the new sheet will contain that value and update it if there is a change in the original.
Be sure to save your work!
2006-12-08 12:02:09 · answer #2 · answered by nospamcwt 5 · 0⤊ 0⤋
Use paste special for that.
Copy the data go to Edit menu -> Paste Special -> choose Value -> ok
2006-12-08 05:46:09 · answer #3 · answered by Suru 1 · 0⤊ 0⤋
simple , just check your formula, whether you have given a absolute reference or an cell reference, because as you have mentioned that it has a formula, the reference is very important
to over come this what you could simply do is
if you need only the values = copy the cells, and when you are going to paste it -----> click on a Cell and activate it-----------> then click on the Edit Button in your menu bar --------> select pace special ------------> and then choose the option values only----> and then paste it...
your problem will be solved
2006-12-08 05:11:50 · answer #4 · answered by rick4u 1 · 0⤊ 0⤋
As far as I'm aware you have to copy and paste from one document to the other BUT you can only do it one box at a time and not a lot of lines together.
2006-12-08 05:11:07 · answer #5 · answered by marykin 4 · 0⤊ 0⤋
instead of just pasting, right click and select paste values.
2006-12-08 05:10:52 · answer #6 · answered by marklin1972 2 · 1⤊ 0⤋