如果不能，肯定有解决措施啊，比如复制一份，刷完再删掉。

1.        Select the table that has the format and formulas you want to copy from
2.        Click Ctrl+C
3.        Open, then select the table you want copy the format  and formula to
4.        Right click, then click Paste Special
5.        Select formula, then click OK
6.        Repeat 3 and 4
7.        Select  format, then click OK

1.        Select the table that has the format and formulas you want to copy from
2.        Click Ctrl+C
3.        Open, then select the table you want copy the format  and formula to
4.        Right click, then click Paste Special
5.        Select formula, then click OK
6.        Repeat 3 and 4
7.        Select  format, then click OK

又学到一个重要的日常操作，感谢！[victory][victory]

谢谢yongyitian的帮助，thank you