• Excel Video Tutorials

Select Data in Excel 2010


Advertisements

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 the below dialogue box.

Clicking F5 on Cell

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.

Selecting Current region

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

See Selected Data

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements