Excel 简明教程

Select Data in Excel 2010

MS Excel 提供各种选择工作表中数据的方法。让我们看看这些方法。

MS Excel provides various ways of selecting data in the sheet. Let us see those ways.

Select with Mouse

将鼠标拖动到要选择的数据上。它会像下面所示那样选择那些单元格。

Drag the mouse over the data you want to select. It will select those cells as shown below.

select data with mouse

Select with Special

如果您想选择特定的区域，则选择该区域中的任何单元格。按下 F5 会显示下面的对话框。

If you want to select specific region, select any cell in that region. Pressing F5 will show the below dialogue box.

clicking f5

单击 Special button 可查看下面的对话框。从单选按钮中选择 current region 。单击 ok 可查看当前选定的区域。

Click on Special button to see the below dialogue box. Select current region from the radio buttons. Click on ok to see the current region selected.

select current region

正如您在下面的屏幕中看到的，数据已针对当前区域选择。

As you can see in the below screen, the data is selected for the current region.

selected data