Word and Excel row transition implementation method

xiaoxiao2021-04-06  273

[IT168 Practical Skills] In Word operation, we sometimes need to exchange the row of the Word table (also known as table conversion), but Word itself does not provide ready-made features, traditional methods are manual conversion. However, in this way, the operation is low, and it is easy to make mistakes. The most fundamental reason is that it does not meet the relaxed and convenient concept of our modern office. (Related Articles: Repair Word documentation becomes garbled)

Today, in order to introduce two methods, it can easily implement Word Layer Transformation. The following two tables are the tables before the ranks and the conversion table two. The table can be converted to the form of Table 2 by way of the following methods.

Table I

Table II

First, with the help of Excel

1. First, right click on the top 10 hopes in the top left corner of the table, then perform the "copy" command in the right-click menu. (As shown in Figure 1)

figure 1

2. Next to open Excel, click the right mouse button at any unit, select the Selective Paste → Text command to paste the Word table into Excel. (as shown in picture 2)

figure 2

3. Check and right click to copy the cells with data in Figure 2.

4. Then switch to another blank worksheet, right click and execute the Selective Paste command. Finally, in the pop-up dialog box, check the "transpose" check box, click OK. (As shown in Figure 3)

Figure 3 5 At this point, we will find that the ranks in the Excel form have been interchanged in accordance with our requirements, and the data of each cell is not bad. At this time, then copy the Table table to Word. . For the form of successful, we have to reset the border of the new table, because the table after the successful conversion is no border.

Method II, replacement method

1. First select a column of data and copy it, use the "Selective Paste" command under the "Edit" menu in an open blank Word document, select "Unformatted Text" to selectively paste, then open "Find and Replace dialog.

2. Enter "^ p" (Enter) in the "Find Content" box, enter "^ t" (tab) in the "Alternate" box, click "All Replace", now you will find a column of data The data is changed, and all the data selective paste back to the desired form. (As shown in Figure 4)

Figure 4

3. Use the same method to convert the data in other columns to the corresponding position of the table.

Note: If you want to enter the change to the column, enter "^ T" in the Find Content box, enter "^ P" in the "Alternate" box.

转载请注明原文地址:https://www.9cbs.com/read-132324.html

New Post(0)