Traditional Culture Encyclopedia - Photography major - When inserting an EXCEL table into a WORD table, is it seriously deformed?
When inserting an EXCEL table into a WORD table, is it seriously deformed?
Hello! You can use these two methods, I hope they can help you!
Method 1: Open EXCEL, position the cursor on the cell, click the Insert button on the menu bar - Object - in New, select the object type as Microsoft Word document.
Method 2: Select the entire Word table, copy it to the clipboard, open an Excel workbook, select unit A1 on a new worksheet, and then paste it.
For example, a price list that has been edited in Word needs to be reported in the form of an Excel table. However, if there are multiple paragraphs of text in the cells of the Word table, problems will arise when using the above method to convert. That is, after the Word table is pasted into Excel, cells with multiple paragraphs of text will appear to be composed of multiple cells. Only the cell borders between them are "hidden" (displayed gray in the view and not printed). ).
What’s even more troublesome is that the other cells in the row where that cell is located are all merged cells. It turns out that one row of the Word table "occupies" multiple rows in Excel. Not only is it ugly, but it also brings a lot of inconvenience to editors.
The solution is:
The first step is to use the "Edit"·"Replace" command in Word to cancel the segments in all cells. That is,
On the Replace tab of the Find and Replace dialog box, enter a paragraph mark (special character) in the Find what box, leave the Replace with box blank, and then Click Replace All.
In the second step, select the entire Word table, copy it to the clipboard, open an Excel workbook, select cell A1 on a new worksheet, and then paste.
The third step is to use the shortcut key - "Alt+Enter" in the cell whose content needs to be segmented.
Tip: You cannot solve the problem by merging cells in Excel. Because after the cells are merged, only the content in the cell originally located at the upper left can be retained, and the content in other cells will be deleted.
- Previous article:Do UFOs exist
- Next article:Youth fighting, the road of five girls' growth.
- Related articles
- Ferrante photographer video
- I would like to ask which scenic spots in Xinyu, Jiangxi Province must be visited.
- Aesthetic and Creative Chinese Core Literacy 2021-11-07
- Introduction to Changxing Plum Blossom Festival
- What are the most common mistakes in decoration?
- Is the cell phone flash important? How much influence does it have on taking pictures with mobile phones?
- Global model outdoor photography network
- What is gastric cancer?
- Time-lapse photography scenery Li
- What is the makeup artist's salary?