How to copy non-consecutive rows and columns in excel?

How to copy multiple discontinuous rows and columns in excel?

Method:

1. First, open the excel table from which the required content needs to be extracted. The sample data is as shown below:

2. Then hold down the Ctrl key, select the unwanted data in columns B and D, then right-click and select "Hide", as shown below :

3. After pressing Hide, the unwanted data in columns B and D will be hidden, and only columns A, C and E will be visible, as follows Picture:

4. Then select all the data you want in column A, column C and column E, press the Alt key and ; key at the same time, then right-click and select "Copy". At this time, the content of the copied discontinuous columns A, C and E will appear as dotted lines, as shown below:

5. Then prepare to paste , right-click and select "Paste Special", in the dialog box that opens, select "Value", and finally click OK, as shown below:

6. Click OK Afterwards, the contents of the desired discontinuous columns A, C and E are extracted, and the hidden parts are not copied and pasted, as shown below:

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to copy non-consecutive rows and columns in excel?. For more information, please follow other related articles on the PHP Chinese website!