How to merge merge tables

Method to merge tables: First open one of the tables; then click "Data" and select "Import from XML data"; then find the second table to open, and click the first table "Sheet1"; finally Import the data worksheet location and click "Blank Cell".

The operating environment of this article: Windows 8 system, Microsoft Office Excel 2007 version, Lenovo tablet Miix2 computer.

When you need to merge the data from two tables together. If there are many, it will be very time-consuming to copy them one by one. Open one of the tables first

Then click "Data" and select "From other sources, click to select "Import from XML data"

The option appears, click "All Files", find the second table to open .

After entering, click the first form "Sheet1", and click "OK".

After importing Select the data table, import the data worksheet location, click "Blank Cell."

This has been merged together, but if you find that you can use Apply Table Format, you can click "Design" , after selecting Apply Format, right-click and click "Apply and Clear Format"

[Recommendation: Excel Tutorial]

Continue Click "Convert to area", click "Yes" to convert to normal area.

Select the colored cells, then click "Fill" in the menu bar, click " "No fill color."

##

The above is the detailed content of How to merge merge tables. For more information, please follow other related articles on the PHP Chinese website!