problem is:
in sheet 1 showing :
columnA B C
CLASS 1604CLASS 2401CLASS 3303TOTAL1308
note: above figures is calcuate under formula..... That mean is formula cell.
if i want to copy and paste in a new sheet such as sheet 2 for value only.
how can i do it?
excel problem
2011-01-02 2:18 am
回答 (1)
2011-01-02 5:44 am
✔ 最佳答案
highlight the rangecopy the range
go to sheet 2
right click -> paste special
select "value"
收錄日期: 2021-04-13 17:44:22
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110101000051KK00962