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 - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.