How to put two tables into one excel

Method: First open the first table and select the specified column; then right-click the mouse and select "Insert"; then use "ctrl c" to copy the specified cells of the second table and select the first table cells in; finally, right-click the mouse, click "Paste Special", and check "Skip Empty Cells".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

First of all, let’s take the table in the picture as an example. Hold down the ctrl key and click on the columns containing the purchase price in February and the purchase price in March.

Then we right-click the mouse and select Insert.

Then we select the selling prices from January to March in the second table and use "ctrl c" to copy.

Select the cell in the first table, right-click, and click Paste Special.

Then we check Skip empty cells and we’re done.

Related learning recommendations: excel tutorial

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