From the course: Excel Essential Training (Microsoft 365)

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Finding and replacing data

Finding and replacing data

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Finding and replacing data

“

- [Instructor] When you're looking for data within a list, sometimes it would be helpful to use a feature found on the home tab, off to the right, called Find & Select. At other times, you might consider using Excels filter, and that's covered in a later movie in this course. Find & Select. And before using this, consider where you're trying to look. That'll shorten the time it takes to find information. If I'm looking for somebody named Rick, and that's not his last name, if it were the last name, I'd simply sort this data based on what's in column A and scroll to that part of the alphabet. But I'm looking for a certain Rick. I'm not sure which one it is. I'll click column A and then go to that icon on the home tab, Find & Select. Find. So we're looking for Rick here. Now, for the moment, I don't care if it's upper or lowercase. That should work okay. We'll simply try and Find All, and it jumps to the first one.…

Contents