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

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

May 07, 2022 am 10:28 AM
word excel

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!

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

#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.

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

#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.

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

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].

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

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

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

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!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to filter more than 3 keywords at the same time in excel How to filter more than 3 keywords at the same time in excel Mar 21, 2024 pm 03:16 PM

How to filter more than 3 keywords at the same time in excel

What should I do if the frame line disappears when printing in Excel? What should I do if the frame line disappears when printing in Excel? Mar 21, 2024 am 09:50 AM

What should I do if the frame line disappears when printing in Excel?

How to change excel table compatibility mode to normal mode How to change excel table compatibility mode to normal mode Mar 20, 2024 pm 08:01 PM

How to change excel table compatibility mode to normal mode

How to add handwritten signature to word document How to add handwritten signature to word document Mar 20, 2024 pm 08:56 PM

How to add handwritten signature to word document

How to set superscript in excel How to set superscript in excel Mar 20, 2024 pm 04:30 PM

How to set superscript in excel

How to use the iif function in excel How to use the iif function in excel Mar 20, 2024 pm 06:10 PM

How to use the iif function in excel

Where to set excel reading mode Where to set excel reading mode Mar 21, 2024 am 08:40 AM

Where to set excel reading mode

How to read excel data in html How to read excel data in html Mar 27, 2024 pm 05:11 PM

How to read excel data in html

See all articles