Excel and Word format tables convert to each other

Excel's powerful system Biaogong can make many office families forget its convenience and practicality. In some cases, however, we have to convert an Excel table to a Word document, such as a personal resume form that is typically a doc document. It is now common practice to use Excel to do the form first, and then stick the form in Wo resume template rd. But the formatting of the table after sticking to word has changed, and it has to be debugged again, time-consuming and laborious. In fact, the small series to remind you that the following methods can be easily converted.

First, use Excel to edit your personal resume, and then click "File" → "Save as Web page". A Web page is a Web page file, in the Save Options section, "Save the entire workbook teacher profile" To adjust the Excel inventory form template into "Select: Sheet", the default filename "page.htm" according to the actual situation you need to change the name, such as: "Worksheet. htm", and then click "Save ”。 Note that you must not remove the. htm from the back when you change your name, just "." The front part is OK.

Find the "worksheet. htm" That you just saved, and if you have installed an operating system that is Windows XP or Windows2000, you can click the right mouse button on the file, select the "Open program" option at the bottom of "open with", and find "Word" in the list, select and OK.

Use Word program to open the converted resume form template file, do not do any editing, directly click "File" → "Save As", the file name changed to "worksheet Word version", the Save type to "Word document", and then click "Save" can be.

Now open the "worksheet word" file you just saved to see if it's a perfect conversion.

Converting a table made in Word into an Excel table is a seemingly mundane job.

For example, a price list that has been edited in Word needs to be reported in an Excel form.

In general, simply select the Word table as a whole, copy it to the Clipboard, open an Excel workbook, select the A1 cell on a new worksheet, and then paste it. < graduate resume template >

However, if you have more than one paragraph of text in a cell in a Word table, it can be problematic to convert with the above method. ,< graduates personal resume fan >

When a Word table is pasted into Excel, a cell with more than one paragraph of text shows that there are multiple cells, only the cell border between them is "hidden" (gray on the view, not printed).

What's even more troublesome is that the other cells in the row of that cell are the merged cells. A row of the original Word table, in Excel, "occupies" more than one line. Not only ugly, but also bring a lot of inconvenience to editors.

The solution is:

The first step, in Word, is "edit" · Replace command to cancel the paragraph in the Personal resume template encyclopedia for all cells. That

On the Replace tab of the Find and Replace dialog box, enter a paragraph mark (special character) in the Find what box, and leave blank in the Replace with box, and then click Replace All.

Second, select the Word table as a whole, copy it to the Clipboard, open an Excel workbook, select the A1 cell on a new worksheet, and then paste.

In the third step, in the cell where the content needs to be segmented, use the shortcut key-"Alt+enter" section.

Tip: You can't use a merged cell method in Excel to solve the problem. Because, after a cell is merged, you can only keep the contents of the cell that is in the upper-left, and the contents of the other cells are deleted.

Note : Please pay attention to the Office software tutorial section, triple Computer office group: 189034526 welcome you to join