Today, I know that word and excel can be converted to each other and read the knowledge
Yan Jiadong 2020-11-27 20:28:13
We are in the workplace , I deal with all kinds of documents every day , Especially the format conversion .

Let's say you're going to Word And Excel transformation , A lot of little white can only copy and paste , Efficiency is very slow .

Let's teach you today , How to integrate Word And Excel The method of mutual conversion , Let's learn together .

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge

One 、Word turn Excel


When we need to Word Convert the table in to Excel in , If you copy and paste , The table will deform . We can press 【F12】, Select Save File , Change the save type to 【 A single web file 】.

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge


Then we build a new Excel workbook , After opening, the saved web page file will be , Drag the mouse into this workbook , such Word It was successfully converted into Excel 了 , Finally, check the gridlines in the view .

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge

Two 、Excel turn Word


In fact, will Excel convert to Word It's very simple , Just copy and paste , It's just that you need to choose . Let's open it first Excel form , Select all the table contents , Right-click to select 【 Copy 】.

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge


And then create a new one Word file , Do not paste directly after opening , Otherwise the form will be out of range , Press the shortcut key 【Ctrl+Alt+V】 Paste special , Click in the window 【Microsoft Excel Worksheet object 】.

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge


In this way, the table can be converted intact , Whether it's color or function properties , They're all coming together ; Drag the four corners to adjust the size proportionally , And double clicking on the table can also modify the data .

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge

3、 ... and 、 Batch conversion conversion


Word And Excel transformation , Use the above method , It's still possible to work with a single file . But there are a lot of documents at work , And that's where it comes in Fast PDF converter , It can be done in batches with one click .

①Word Batch transfer Excel

First open the tool , And then click 【PDF transformation 】-【PDF Convert other 】; choice 【 File transfer Excel】, Click on 【 Add files 】, You can batch add Word file , One click to Excel.

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge


②Excel Batch transfer Word

If necessary Excel The file to Word, Then choose 【 File transfer Word】 function , Also batch add Excel file , And then click 【 Start conversion 】, Wait more than ten seconds to complete the conversion .

 Only today did I know ,Word And Excel They can switch to each other , I'm finished reading the knowledge


Okay , That's all Word And Excel The method of mutual conversion , I hope I can help you . If there's something you don't understand , You can leave a message to discuss .
版权声明
本文为[Yan Jiadong]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/202011242225532462.html
相似文章

2021-08-09