Select Data in Excel 2010


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

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

Clicking F5 on Cell

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

Selecting Current region

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

See Selected Data