Excel - Select Data in Excel

Microsoft Excel - Editing Worksheet

Part 16 - Select Data in 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 with Special

 

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



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.




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