自由報料

跳至

首頁
1

尾頁
   0
該用戶已被刪除

發表於 06-2-13 13:34 |顯示全部帖子

a question of Excel. thanks.

提示: 作者被禁止或刪除 內容自動屏蔽


男爵府

積分: 6551


發表於 06-2-13 13:54 |顯示全部帖子

Re: a question of Excel. thanks.

if the formula with "link up 連結" with other worksheet.
it should not be work


子爵府

積分: 13926


發表於 06-2-13 14:59 |顯示全部帖子

Re: a question of Excel. thanks.

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.
How about save as a new file?


子爵府

積分: 11750

好媽媽勳章


發表於 06-2-13 15:56 |顯示全部帖子

Re: a question of Excel. thanks.

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

該用戶已被刪除

發表於 06-2-14 13:58 |顯示全部帖子

Re: a question of Excel. thanks.

提示: 作者被禁止或刪除 內容自動屏蔽


男爵府

積分: 6551


發表於 06-2-14 14:52 |顯示全部帖子

Re: a question of Excel. thanks.

may i know if the old link up file is in your hard disk or not.

If the link up file is someone forward to you but you don't have it. Of course, your copy will be failed.


大宅

積分: 1182


發表於 06-2-14 15:01 |顯示全部帖子

Re: a question of Excel. thanks.

Not sure if this will help, but you can try:

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

該用戶已被刪除

發表於 06-2-15 13:39 |顯示全部帖子

Re: a question of Excel. thanks.

提示: 作者被禁止或刪除 內容自動屏蔽

首頁
1

尾頁

跳至