Word and Excel linkage: tables can be printed in columns using Word!

In the previous article "Practical Word Tips Sharing: Let’s talk about the "line number" function you have never used", we learned about the "line number" function in Word that you must have never used . Today we will continue to share practical Word skills and see how to use Word to print Excel tables in columns. Come and save it for use!

#When it comes to Word columns, most people think that it is limited to document layout applications. Actually it’s not, it also has the following wonderful uses!

For example: Some Excel tables have many rows and few columns. When there are many rows, they may be dozens of pages long, but there are only 2 or 3 columns. So, in this case, if we print it out directly, the effect will be as follows.

#The right side of all pages is blank, which wastes paper and is not conducive to viewing data. At this time, there is a simple method, which is to use Word to print in columns, so that the data can be seen at a glance and paper can be saved.

Specific operation method:

(1) In Excel, Ctrl A selects all table contents, copy and paste them into Word.

(2) Select the entire table, click the [Layout]-[Column] button, and select the "Two Columns" option to get the effect of two columns and fill the right page.

However, you will find that the top (beginning part) of the table after the columns is not capped, which is not very beautiful. what to do? We can solve this problem by adding a header row at the top of the table.

(3) Select the title row of the table and click [Table Tools] - [Layout] - [Duplicate Title Row].

(4) At this time, print again, the effect is as shown in the figure.

Recommended tutorial: "Word Tutorial"

The above is the detailed content of Word and Excel linkage: tables can be printed in columns using Word!. For more information, please follow other related articles on the PHP Chinese website!