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.
Finding and replacing data - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Finding and replacing data
If you have a worksheet with a lot of data on it, knowing how to find and how to replace data is very important. So let's take a look. Right now this worksheet is sorted by Last Name, and let's say we have to leave it that way, but you want to find everybody who is in California, and you can see here in Column D we have the States listed. So you want to make sure you are on the Home tab and over here on the right, the little binoculars, choose Find & Select and the first option is Find. I am just going to cancel out of here for a second just to show you the shortcut is Ctrl+F, F for Find. So let's type in CA for California, click Find Next and look what happens. It finds someone whose name is Carol. Click Find Next again, going to find somebody whose name is Carly. Hmm. Click Find Next again, okay, finally it finds California. Well, there has got to be a better way. So let's click back up here on the top. You can leave that CA in there. But click this Options button, and you see we…
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.