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

Finding and replacing data - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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…

Contents