You may have a problem to copy the only value of the cell. You can copy the cell but when you paste in work sheet, simply you will get the result in error (#REF). The error comes because you are copying the inserted formula from the previous work sheet and when you pate in next work sheet the formula can’t find the based cells value.
To correct this error follow the method as below which will copy only the cell value not a formula.
1. Select the cell or range of cell which you want to copy.
2. Go to the Clipboard Group on the Home Tab > Click Copy (or press CTRL+C)
3. Go to the new work sheet
4. Select upper left cell of the paste area.
5. Go to the Clipboard Group on the Home Tab > Click Paste (you will get drop down list).
6. Click Paste Value.
To correct this error follow the method as below which will copy only the cell value not a formula.
1. Select the cell or range of cell which you want to copy.
2. Go to the Clipboard Group on the Home Tab > Click Copy (or press CTRL+C)
3. Go to the new work sheet
4. Select upper left cell of the paste area.
5. Go to the Clipboard Group on the Home Tab > Click Paste (you will get drop down list).
6. Click Paste Value.
Finally it is done. Now you can see the correct result. Cheers!!!!!!!!!!
No comments:
Post a Comment
Comment form Message