How to implement drop-down selection in Excel?

#How to implement drop-down selection in Excel?

Implementation method:

1. Open the Excel document. You can see that the beginning of the data starts with 1.

#2. Pull down and you can see that the end is 128.

#3. If you use the conventional method of holding down the left mouse button and sliding, the selection is too slow, and if you use the method of clicking on the column header, sometimes the data is not easy to paste. .

#4. Click the first cell at the beginning of the data, and then hold down the [Shift] key.

5. Click the scroll bar on the right, pull it down, and then click the cell at the end of the data

6. Finally, you can select only this part of the area.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to implement drop-down selection in Excel?. For more information, please follow other related articles on the PHP Chinese website!