From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Targeting large data groups

Targeting large data groups - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Targeting large data groups

In Excel, as with all other Windows programs, you have to know how to select your data if you want to modify it. So let's take a look at a few techniques. Well some are pretty straightforward. Put your mouse pointer here at the beginning and you can just drag and as long as you don't let go off the mouse button, you can reduce or enlarge the selection area. Okay, that's great, but what if you wanted to select some things that are not quite so straightforward? Well let's do this. Click on the first cell here A5. Now if you scroll down, you can see there's the end of this selection area. Well, it can be kind of hard to try to drag to select that, because Excel starts doing that and it can scroll much faster than you can select. So I'm just going to press Ctrl+Home. So here's an easier way to do that. Click the first cell, scroll down, so I'm just to use going to use the rolling wheel on the mouse, put your mouse pointer on the last cell there, and before you click hold the Shift key…

Contents