Finding and replacing data

On the Home tab in the ribbon the editing group on the right-hand side contains…a number of features including a binoculars icon for Find & Select.…Some of the things we're about to show you in this movie could be done more…efficiently with a filter, but not always.…Sometimes we're simply looking for data.…Let's imagine that we're looking for somebody named Rick.…Before searching for data in Excel it's best to narrow down the search.…If you click a single cell and then activate the Find feature, you will…automatically be looking in the entire worksheet.…

If you select a range--possibly you have this range already selected for…a different reason--…if you start a Find now, we're only looking for data within the range.…Now let's say we are looking for someone named Rick.…The only location in this worksheet where we see names like that is column A.…Let's go to column A, select that first, and now our search process using Find will…only be looking in column A. Notice it's "Find and Replace".…We're simply going to do Find here.…