How to select multiple spaced cells

How to select multiple spaced cells: 1. Press the "ctrl" key on the keyboard and click the cells to be selected with the mouse to select multiple desired discontinuous cells; 2. Press the "shift F8" key on the keyboard, and "Add to Selection" will be displayed at the bottom of the table. Use the left mouse button to quickly select the cells you want to select.

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

Method 1: You can hold down the CTRL key and click the cells to be selected with the mouse to select multiple desired non-contiguous cells.

After selecting the cells that need to be filled, click the "Fill Color" option, as shown in the figure.

Method 2: But sometimes there is a lot of data in the table and it feels tiring to hold down the CTRL key at the same time. We can hold down the shift F8 key at the same time and a pop-up will pop up in the lower border column of the table. "Add to selection", so that you can quickly select the cells you want to select with just the left mouse button.

Related learning recommendations: excel tutorial

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