ChunChun&mommy 寫道:
How to move a table with formular to a new worksheet? I have used copy and paste function but the formualr is changed automatically.
what is the "formular"? is it only a calculation?
what do you mean "new worksheet"? in the same file but other sheet or copy in a new excel file?
you question is not clear, so, it's difficult to help you
copy the cell, and go to the new worksheet, right click the cell you wanna paste and a menu will pop up, under "paste" function, there is a "paste special" function, click it, and another menu will pop up, you can choose what kind of paste you want, if you want to paste "formula", you can click forumula, if you want to paste "value" only, then choose "value", many many choices. Hope this helps
發表於 
返回列表
