How to select two non-adjacent columns in excel at the same time

How to select two non-adjacent columns in excel at the same time: 1. Select one column first; then hold down the Ctrl key and click the other column you want to select. 2. First select a column; then press the shortcut key "shift F8". "Add to Selection" will appear on the status bar. Select another column that is not adjacent.

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

excel selects two non-adjacent columns at the same time

Method 1:

Select one column first and hold down the Ctrl key , just click the column you want to select (click on the table header A, B, etc.), as shown in the figure:

Method 2:

Open the Excel table, first select a column, as shown in the figure:

Press the shortcut key shift F8, "Add to Selection" appears in the status bar, select Non-adjacent columns are sufficient. As shown in the picture:

Related learning recommendations: excel tutorial

The above is the detailed content of How to select two non-adjacent columns in excel at the same time. For more information, please follow other related articles on the PHP Chinese website!