1. Usually, after obtaining data sources from other tables, the usual practice is to copy and paste them directly into a blank table. It would be too bad if there were only numbers in the content. In fact, the format of the table is also copied at the same time, and most of these formats are useless to use. When the format is optional, the standard practice is as follows:

Right-click in the target table and select Paste Special to open the following dialog box:

2. The default value of "Paste" section is "All", which will cause all formats to be copied in. Here, you should select "Value" and click "OK", and that's all. At this time, compare it with the previous document, and the file size will be judged.

If the desk is ready, the office software will get stuck or won't open because it is too big. At this time, find some cells in the document that don't need format, select them all, and click Start-Clear (drop-down option)-Format.

Now, the file is smaller.