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 have a couple of helpful…