Shulou(Shulou.com)11/24 Report--

How to align the information of Party An and Party B in the contract?

In fact, the quickest solution is to divide the columns.

You may know what the column is. For example, editors often use this typesetting method when they look at the periodicals and magazines such as Reader's Digest, bosom friend, and Story Society, which have grown up.

Column layout, not only can quickly read line after line of words without turning the neck, but also make the content more compact, typesetting more space-saving (no paper).

But did you know that there is a column function in Word and PPT?

Even if you did, would you use it to align text with the same structure side by side?

The editor has a stock fan who asked a question in the WeChat group:

I want to print an Excel table, full of stock symbol information, only two columns, but more than 100 rows. If you print directly, there will be a large piece of paper free on each page, which is a waste of paper.

Is there any way to print these forms onto a piece of paper?

I know that the Excel function formula is almost omnipotent, with which the data can be rearranged according to the width of the paper. No matter according to conditioned reflex, muscle memory, or international practice, I should let him search in Baidu, he will be able to find a lot of tutorials.

However, he did not. If he could not understand the formula, he came and asked me what to do!

In fact, there is a way, no function formula at all, just copy and paste, set up to achieve a similar effect. Yes, it is in Word to borrow the way-column.

You may know the function of columns in Word.

So, when you encounter the problem of this "Excel" table, will you think of using Word columns to solve it? Or will you continue to bang on the function formula in Excel?

Although Excel is almost omnipotent, it is amazingly efficient.

However, in many cases, Word may be more useful.

02 want to make a list of national provinces (autonomous regions) in Excel, but only find a version of the text, what should I do?

In fact, it is not difficult to convert to a list in Excel, as long as it is sorted by comma, it will be divided into a row of data filled in a cell by each province (autonomous region). Then copy, paste selectively, transpose, and you can get a list of provincial data.

But if you put it in Word, it will be easier.

What? To be arranged in five rows?

It seems that it can only be put into Excel, to borrow the power of the formula.

However, many people don't know that Word has another trick: text to table, which can be converted by delimiter and specified number of rows and rows.

The work of Word word processing is so good that it is ignored by many people. If you can flexibly master Word search and replacement, text typesetting skills, and even help you learn less Excel formula.

However, many people have to use Excel to make tables with large chunks of text.

In this way, if the rows of the table are high, the screen will jump around frequently when browsing the table. Moreover, when printing, obviously the preview is normal, but after it can be printed on the paper, the last two or three lines of words are often "eaten".

On one occasion, another classmate came to ask why. I couldn't help it and asked:

"I'm curious, why do you have to use Excel to make this form? "

"required by the leader"

I,.

03 A girl who was doing an audit asked me if she wanted to print a batch of confirmation letters and could not understand the intimate tutorials of her predecessors.

But. I don't understand the letter of inquiry either.

So Baidu silently looked like this:

It turns out that letters with different contents should be printed according to the information of each enterprise in the Excel table.

The girl's predecessor left her instructions. Although the steps are clear and four steps are done, the content is like a book of heaven:

The "easy-to-use plug-in" is also used to batch generate and rename worksheets to achieve batch printing. I look so confused.

Wait, wait,

Using Word's merge Mail, you only need a blank Word file as a template to retrieve all the data from Excel's data warehouse and automatically generate a document.

Then you can print in batches without using a function formula, and you can easily handle 1000 documents!

The use of brute force everywhere will only get harder and harder.

Familiar with the advantages and disadvantages of tools, know how to skillfully use the characteristics of different tools, in order to cope with a variety of complex situations!

This article comes from the official account of Wechat: Akiba PPT (ID:PPT100), author: King Editor: puffer Fish Gege

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.